Metabase MCP Server for Claude
Query and explore your Metabase instance from Claude — list dashboards and cards, retrieve and execute saved questions, run SQL queries, export large result sets, and search across all Metabase resources — with the Metabase MCP server optimized for 90% token reduction.
Open the source and read safety notes before installing.
Safety notes
- Read-only mode is enabled by default (`METABASE_READ_ONLY_MODE=true`), restricting Claude to SELECT queries only.
- The `execute` tool runs SQL against your connected databases — ensure the Metabase service account has appropriate read permissions.
Privacy notes
- Dashboard data, card results, database schema information, and query results from your Metabase instance are surfaced in Claude's context.
- Your `METABASE_API_KEY` (or email/password) grants Metabase API access — keep credentials in the MCP config env.
Prerequisites
- A Metabase instance (Metabase Cloud or self-hosted).
- A Metabase API key (Metabase 50+): Admin Panel → Settings → Authentication → API Keys.
- Or email/password credentials for older Metabase versions.
- Node.js with `npx` available.
- An MCP client such as Claude Code or Claude Desktop.
Schema details
- Install type
- cli
- Troubleshooting
- No
- Scope
- Source repo
- Estimated setup
- 5 minutes
- Difficulty
- beginner
- Website
- https://www.metabase.com
Full copyable content
{
"mcpServers": {
"metabase": {
"command": "npx",
"args": ["-y", "@jerichosequitin/metabase-mcp"],
"env": {
"METABASE_URL": "https://your-metabase.example.com",
"METABASE_API_KEY": "<your-api-key>"
}
}
}
}About this resource
Overview
The Metabase MCP Server connects Claude to your Metabase instance, giving read access to dashboards, cards, tables, databases, and collections — plus the ability to execute queries and export large result sets. Engineered for 90% token reduction through intelligent response optimization: structured metadata is compressed and paginated to keep responses within Claude's context window. Featured on Claude.ai. MIT licensed, 82+ stars.
Key capabilities
- List & retrieve — list dashboards, cards, tables, databases, and collections; retrieve any item by ID in bulk (up to 50 per call).
- Search — query across all Metabase resources with filtering.
- Execute — run SQL queries or execute saved cards against your databases.
- Export — export up to 1M rows from any card in CSV, JSON, or XLSX format.
- Cache management — granular internal cache invalidation.
Tools
| Tool | Purpose |
|---|---|
list |
List all records for a resource type (cards, dashboards, tables, databases, collections) |
retrieve |
Get detailed info for specific items by ID (batch up to 50) |
search |
Query across all Metabase resources with filtering |
execute |
Run SQL queries or execute saved cards |
export |
Export up to 1M rows in CSV, JSON, or XLSX |
clear_cache |
Granular internal cache management |
Authentication options
| Method | Env vars | Notes |
|---|---|---|
| API Key (recommended) | METABASE_API_KEY |
Metabase 50+ only |
| Email/password | METABASE_USER_EMAIL + METABASE_PASSWORD |
Works with older versions |
How it compares
| Server | Dashboards | SQL execution | Bulk export | Token optimization | Notes |
|---|---|---|---|---|---|
| Metabase MCP | Yes | Yes | Yes (1M rows) | Yes (90% reduction) | Community |
| Grafana MCP | Yes | Yes | No | No | Official |
| Tableau MCP | Yes | No | No | No | Official |
| Looker MCP | Yes | Yes | No | No | Community |
Metabase MCP's bulk export capability (up to 1M rows as CSV/JSON/XLSX) is unique among BI MCP servers.
Installation
Claude Code
claude mcp add metabase \
-e METABASE_URL=https://your-metabase.example.com \
-e METABASE_API_KEY=<your-api-key> \
-- npx -y @jerichosequitin/metabase-mcp
Claude Desktop
{
"mcpServers": {
"metabase": {
"command": "npx",
"args": ["-y", "@jerichosequitin/metabase-mcp"],
"env": {
"METABASE_URL": "https://your-metabase.example.com",
"METABASE_API_KEY": "<your-api-key>"
}
}
}
}
Generate an API key at Admin Panel → Settings → Authentication → API Keys (requires Metabase version 50 or later).
Requirements
- Metabase instance (Cloud or self-hosted).
- API key (Metabase 50+) or email/password credentials.
- Node.js (for
npx). - An MCP client (Claude Code or Claude Desktop).
Security
- Read-only mode is on by default — set
METABASE_READ_ONLY_MODE=falseonly if you need write operations. - SQL execution runs against your connected databases via Metabase's service account — check that account's permissions before enabling non-read-only mode.
Source Verification Notes
Verified on 2026-06-18:
- Repository
jerichosequitin/metabase-mcp(MIT) on npm as@jerichosequitin/metabase-mcp(v1.1.6) documents all six tools,METABASE_URL/METABASE_API_KEY/METABASE_USER_EMAIL/METABASE_PASSWORD/METABASE_READ_ONLY_MODEenv vars, 1M-row bulk export, 90% token reduction optimization, and Claude.ai featured listing. - Claude Code MCP documentation at
code.claude.com/docs/en/mcpdescribes the stdio connector pattern used above.
Source citations
Add this badge to your README
How it compares
Metabase MCP Server for Claude side by side with 3 alternatives on trust, install, platform support, and disclosed safety notes — all from reviewed registry metadata.
| Field | Metabase MCP Server for Claude Query and explore your Metabase instance from Claude — list dashboards and cards, retrieve and execute saved questions, run SQL queries, export large result sets, and search across all Metabase resources — with the Metabase MCP server optimized for 90% token reduction. Open dossier | MCP SQLite Server for Claude Read and write any local SQLite database from Claude — get database info, list tables, inspect schemas, create/read/update/delete records, and run raw SQL queries — with the MCP SQLite server that connects to any `.db` file you specify. Open dossier | Tableau MCP Server for Claude Query Tableau datasources, list and view workbooks, get rendered view images, explore Pulse metrics, search content, and run admin insights from Claude — with the official Tableau MCP server covering 30+ tools for Tableau Server and Tableau Cloud. Open dossier | Teradata MCP Server for Claude Connect Claude to Teradata — list databases and tables, inspect DDL, run SQL queries, preview data, analyze column quality, and explore DBA diagnostics — with the official Teradata MCP server supporting optional ML tool expansion via the teradataml Python package. Open dossier |
|---|---|---|---|---|
| Trust | ||||
| Install risk | Review first | Review first | Review first | Review first |
| Notes | Safety ✓ Privacy ✓ | Safety ✓ Privacy ✓ | Safety ✓ Privacy ✓ | Safety ✓ Privacy ✓ |
| Category | mcp | mcp | mcp | mcp |
| Source | source-backed | source-backed | source-backed | source-backed |
| Author | Jericho Sequitin | jparkerweb | Tableau | Teradata |
| Added | 2026-06-18 | 2026-06-18 | 2026-06-18 | 2026-06-18 |
| Platforms | Claude CodeCodexCursorClaude Desktop | Claude CodeClaude Desktop | Claude CodeClaude Desktop | Claude CodeClaude Desktop |
| Source repo | — | — | — | — |
| Safety notes | ✓Read-only mode is enabled by default (`METABASE_READ_ONLY_MODE=true`), restricting Claude to SELECT queries only. The `execute` tool runs SQL against your connected databases — ensure the Metabase service account has appropriate read permissions. | ✓The `query` tool executes arbitrary SQL including INSERT, UPDATE, and DELETE statements — it is not read-only. Point the server at a copy or test database to avoid accidental data loss before trusting it with production data. | ✓The `delete-workbook`, `delete-datasource`, and `delete-extract-refresh-task` tools permanently remove Tableau content — confirm before executing. The `revoke-access-token` tool revokes OAuth tokens; use with care as it may interrupt other integrations. Admin insights tools (`query-admin-insights-*`) expose site-wide usage data — restrict access to users with admin roles. | ✓The `base_query` tool executes arbitrary SQL on your Teradata system — only connect with credentials scoped to the minimum required permissions. Row limits (`DEFAULT_ROW_LIMIT`, `MAX_ROW_LIMIT`) prevent accidental full-table scans returning millions of rows; leave defaults in place unless you need larger result sets. |
| Privacy notes | ✓Dashboard data, card results, database schema information, and query results from your Metabase instance are surfaced in Claude's context. Your `METABASE_API_KEY` (or email/password) grants Metabase API access — keep credentials in the MCP config env. | ✓All database content including table schemas, record data, and query results are surfaced in Claude's context — do not connect databases containing sensitive personal or credential data unless you intend to share it with the model. No credentials are required and no data is sent to external services — the server operates entirely locally. | ✓Datasource query results, workbook metadata, view images, user lists, and Pulse metric data from your Tableau site are surfaced in Claude's context. View images rendered via `get-view-image` include the actual data visualization — do not use in contexts where dashboard data is confidential. Your PAT value grants full REST API access — treat it as a secret. | ✓Query results, schema definitions, DDL, and session/system metadata from your Teradata instance are surfaced in Claude's context. Your database credentials are embedded in the `DATABASE_URI` — keep it in the MCP config env and never commit it to version control. |
| Prerequisites |
|
|
|
|
| Install | | | | |
| Config | | | | |
| Citations | ||||
| Claim | Unclaimed | Unclaimed | Unclaimed | Unclaimed |
Signals
Loading live community signals…
A short, calm digest of reviewed Claude resources. Unsubscribe any time.