MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL
If you already use Metabase, the metabase mcp server is the piece that lets your assistant work with it directly. MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL.
That's it! Your AI assistant now has full Metabase superpowers. 🦸
The server ships on npm as metabase-ai-assistant, so your MCP client can launch it on demand — there is no separate build step. Add the server block to your client's configuration, restart it, and the tools register themselves.
The toolset is worth reading before you wire it up, because it tells you what the integration is really for:
Feature — This Projectdb_list — List all databasesdb_schemas — Get schemas in a databasedb_tables — Get tables with fieldssql_execute — Execute SQL queriesdb_table_create — Create tables (AI-prefixed)db_view_create — Create viewsdb_matview_create — Create materialized viewsdb_index_create — Create indexesdb_vacuum_analyze — VACUUM and ANALYZEdb_query_explain — EXPLAIN query plansdb_table_stats — Table statisticsConfiguration is passed through the environment: METABASE_URL, METABASE_API_KEY, ANTHROPIC_API_KEY, OPENAI_API_KEY. Treat anything key-shaped as a real credential — scope it to the minimum the server needs, and rotate it if it ever lands in a shared config.
This sits in the database access group, where several servers overlap in what they claim to do but differ sharply once you actually set them up. Metabase's toolset — Feature, db_list, db_schemas and 11 more — is a fair guide to whether it matches your workflow. It is maintained by enessari; worth a glance at recent repository activity before you build anything load-bearing on it.
This entry was verified against Metabase's own documentation before publication; SyncDev keeps the directory reviewed rather than auto-generated.
| Tool | What it does |
|---|---|
| Feature | **This Project** |
| db_list | List all databases |
| db_schemas | Get schemas in a database |
| db_tables | Get tables with fields |
| sql_execute | Execute SQL queries |
| db_table_create | Create tables (AI-prefixed) |
| db_view_create | Create views |
| db_matview_create | Create materialized views |
| db_index_create | Create indexes |
| db_vacuum_analyze | VACUUM and ANALYZE |
| db_query_explain | EXPLAIN query plans |
| db_table_stats | Table statistics |
| db_index_usage | Index usage analysis |
| db_schema_explore | Fast schema exploration |
### Add to Claude Desktop / Cursor
```json
{
"mcpServers": {
"metabase": {
"command": "npx",
"args": ["-y", "metabase-ai-assistant"],
"env": {
"METABASE_URL": "https://your-metabase.com",
"METABASE_API_KEY": "mb_your_api_key"
}
}
}
}Configuration as documented by the project. Restart the client after saving.
| Variable | Description | Required |
|---|---|---|
| METABASE_URL | Endpoint or connection string the server talks to. | Yes |
| METABASE_API_KEY | Credential the server authenticates with. | Yes |
| ANTHROPIC_API_KEY | Credential the server authenticates with. | Yes |
| OPENAI_API_KEY | Credential the server authenticates with. | Yes |
Read-only SQL access to Postgres — let your assistant inspect schemas and answer questions from real data.
Manage your whole Supabase project in conversation — database, auth, storage, Edge Functions and branches.
Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.
Serverless Postgres with database branching — point your assistant at Neon and let it work on disposable copies.