Calame

Calame is a self-hosted web app that connects to your PostgreSQL, MySQL, or SQLite database, lets you configureaccess 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 thebuilt-in chatto query your data in natural language. No code generation, no lock-in — Calame is the control plane.

git clone https://github.com/Calame-Tech/calame.git cd calame pnpm install pnpm dev

On the first run Calame auto-generates aCALAME_SECRET_KEYused 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/dataso that file survives restarts — otherwise every restart invalidates your saved tokens. You can also setCALAME_SECRET_KEYyourself via the environment to reuse an existing secret.

- 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

- 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 toclient_email = X)
- Write queue with approval workflow for mutating queries

- Open,Bearer token,password,OIDC SSO,OAuth 2.1(Google, Microsoft, GitHub…), orexternal 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

- 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-hostedOllama, vLLM, LM Studio

- Email invitations (SMTP), user management, metrics dashboard
- HashiCorp Vault integration for secrets
- Docker + reverse-proxy templates (Caddy, nginx) included

┌────────────┐ ┌─────────────┐ ┌───────────────────────────────┐ │ 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 aprofile— pick tables, mask PII columns, pick auth mode.
- Start the profile. Its MCP endpoint ishttp://localhost:4567/mcp/<profile>.
- Point your MCP client at it, or open the built-in chat.

Something broken? Have a use case we missed? Open an issue or start a discussion.

In short: you can self-host, fork, and modify Calame freely; the BUSL onee/only restricts repackaging it as a paid competing product. Each BUSL-licensed version automatically converts to Apache 2.0 four years after its publication.

Production-grade MCP server for Databricks: SQL Warehouses, Jobs API, multi-workspace support.

A comprehensive Model Context Protocol (MCP) server for SeaTable that exposes end‑to‑end database capabilities (schema introspection, CRUD, querying, linking, select option management, and file attachment stubs) through 18+ rigorously defined tools.

Official MCP server for dbt (data build tool) providing integration with dbt Core/Cloud CLI, project metadata discovery, model information, and semantic layer querying capabilities.

Build robust data workflows, integrations, and analytics on a single intuitive platform.

Query and analyze data with MotherDuck and local DuckDB

Official Supabase MCP server for managing Supabase projects, databases, auth, storage, edge functions, and SQL workflows from AI agents.

A collection of tools for managing the platform, addressing data quality and reading and writing to Teradata Database.

Apify-hosted MCP server for Airtable with 15 tools. Full CRUD for records, tables, fields, search, and schema inspection. No local setup needed.

A read-only MCP server for Avro data sources, powered by the CData JDBC Driver.