Calame
Visual no-code generator that turns any database into multiple scoped MCP servers — one per access group, with PII masking and fail-closed query scoping built in.
Calame
Turn any database into an MCP server — visually.
Quick start · Features · How it works · License
Calame is a self-hosted web app that connects to your PostgreSQL, MySQL, or SQLite database, lets you configure access profiles — per-table permissions, PII masking, row-level scoping — and serves them as MCP (Model Context Protocol) servers with fine-grained auth.
Plug your profile into any MCP client (LLM, Claude Desktop, Cursor, VS Code, ChatGPT Desktop…) or use the built-in chat to query your data in natural language. No code generation, no lock-in — Calame is the control plane.
Quick start
git clone https://github.com/mgasnier95/calame.git
cd calame
pnpm install
pnpm dev
Open http://localhost:4567 — create the admin account, connect a database, create a profile, and you're live.
Or with Docker:
docker compose up
On the first run Calame auto-generates a CALAME_SECRET_KEY used to encrypt
tokens and connection strings, and persists it next to your database
(.calame-secret). If you deploy with Docker, mount a persistent volume on
/data so that file survives restarts — otherwise every restart invalidates
your saved tokens. You can also set CALAME_SECRET_KEY yourself via the
environment to reuse an existing secret.
→ Detailed Quick Start — full walkthrough from install to your first MCP client query (~15 min).
Features
Database connectors
- PostgreSQL · MySQL · SQLite — schema introspection, relations, sample data
- Read-only by design (
SET TRANSACTION READ ONLY), parameterized queries only - Optional SSH tunneling for remote databases
Access profiles
- Pick tables & columns to expose per profile
- PII detection & masking (auto + custom rules, global or per-column)
- Row-level data scoping (e.g. restrict a profile to
client_email = X) - Write queue with approval workflow for mutating queries
Auth — per profile
- Open, Bearer token, password, OIDC SSO, OAuth 2.1 (Google, Microsoft, GitHub…), or external validation URL
- Per-user tokens with revocation
- MCP OAuth 2.1 Dynamic Client Registration (Claude Desktop / Cursor / VS Code auto-discover)
- Full audit log with export
Built-in chat
- Query your data in natural language from the UI — no external client needed
- Pluggable LLM providers:
- Anthropic (Claude direct)
- OpenRouter (Claude, GPT, Gemini, Llama, …)
- Custom OpenAI-compatible — self-hosted Ollama, vLLM, LM Studio
Operations
- Email invitations (SMTP), user management, metrics dashboard
- HashiCorp Vault integration for secrets
- Docker + reverse-proxy templates (Caddy, nginx) included
How it works
┌────────────┐ ┌─────────────┐ ┌───────────────────────────────┐
│ Your DB │──▶│ Calame │──▶│ MCP client (Claude Desktop, │
│ (Pg/My/Lt) │ │ (profiles, │ │ Cursor, VS Code, ChatGPT, │
│ │ │ auth, PII) │ │ built-in chat, LLM…) │
└────────────┘ └─────────────┘ └───────────────────────────────┘
- Connect a database (Calame introspects the schema).
- Create a profile — pick tables, mask PII columns, pick auth mode.
- Start the profile. Its MCP endpoint is
http://localhost:4567/mcp/<profile>. - Point your MCP client at it, or open the built-in chat.
Feedback
Something broken? Have a use case we missed? Open an issue or start a discussion.
License
Calame is dual-licensed:
- Apache 2.0 — root,
packages/*,scripts/, and everything else outsideee/. SeeLICENSE. - Business Source License 1.1 (BUSL-1.1) — the entire
ee/directory (currentlyee/sso, the SSO/OIDC implementation). Seeee/LICENSE.BUSLandee/README.md.
In short: you can self-host, fork, and modify Calame freely; the BUSL on ee/* only restricts repackaging it as a paid competing product. Each BUSL-licensed version automatically converts to Apache 2.0 four years after its publication.
Serveurs connexes
CData MCP Server for Microsoft SQL Server
An MCP server for Microsoft SQL Server by CData. Requires a separately licensed CData JDBC Driver.
楼宇大数据服务
Provides comprehensive building and office address information queries, including enterprise office address search and building information queries.
@exerciseapi/mcp-server
Official MCP server for exerciseapi.dev — search 2,198+ exercises across 12 categories
Library MCP
A local server to query and interact with Markdown knowledge bases by tags, text, slug, or date.
MySQL DB
An MCP server for integrating with and managing MySQL databases.
SAP Fieldglass MCP Server by CData
A read-only MCP server for querying live SAP Fieldglass data, powered by the CData JDBC Driver.
PubChem MCP Server
Provides comprehensive access to PubChem's chemical information database via the PubChem PUG REST API.
CompanyEnrich
Access real-time exclusive B2B data APIs that power your AI agents and workflows
MemFlow MCP
Enables Large Language Models to store and retrieve persistent memories with intelligent search capabilities.
MySQL Server
Provides read-only access to MySQL databases, allowing LLMs to inspect schemas and execute queries.