Metabase MCP
Score = points from our five tests (install, handshake, maintenance, docs, license). Not a quality or security rating. Methodology
- Install20/20
- Handshake30/30
- Maintenance25/25
- Docs15/15
- License10/10
Self-hosted open source
Runs on your own instance of this open-source product. You need your own instance; we tested a local copy.
Self-hosted open source: Metabase MCP ships in open-source Metabase. You need your own instance. We tested official OSS metabase.jar v0.65.6 from downloads.metabase.com (released 2026-11-18 UTC) on 127.0.0.1 with a local admin login (Eclipse Temurin JRE 21 in a user directory, H2 app DB, bundled example database that ships with OSS Metabase only, anonymous tracking off). No Cloud account, trial or license key was used. The MCP endpoint /api/metabase-mcp is on by default in our fresh-install test. Unauthenticated initialize returned HTTP 401 with an OAuth challenge. We signed in with OAuth dynamic client registration and PKCE and requested only the read scopes agent:content:read and agent:query:run. Initialize and tools/list then listed 21 tools (the vendor blog says 24; official docs say visualize_query is hidden from clients that cannot render inline charts). 9 tools are annotated readOnlyHint; 11 are annotated destructiveHint (alert_write, bookmark_content, collection_write, dashboard_write, document_write, execute_sql, measure_write, metric_write, question_write, segment_write, subscription_write); duplicate_content is a write tool without destructiveHint. The tool list was not filtered by the granted read-only scopes. Real read-only calls, 5 of 5 passed: browse_data list_databases (bundled example database that ships with OSS Metabase), search "orders" (ORDERS table first), execute_query MBQL count on ORDERS (18,760 rows), glossary (empty), learn (topic catalog). No write or destructive tool was called. Tool output is wrapped in data-boundary markers (data, not instructions). Access and refresh tokens were revoked at /oauth/revoke (HTTP 200); a later initialize with the old token returned 401. The instance (jar, JRE, app DB, tokens) was deleted after the test. Official docs: https://www.metabase.com/docs/latest/ai/mcp. License: AGPL-3.0 for the OSS core and the OSS jar (GitHub reports NOASSERTION because the repo is dual-licensed).
Tool-call test (2026-11-19 UTC, direct MCP Streamable HTTP client, no LLM): pass. 5 of 5 read-only calls passed on our own local OSS v0.65.6 instance after a local admin OAuth login. No write or destructive tool was called. You need your own Metabase instance. Evidence: live endpoint probe, Nov 19, 2026 UTC.
Transport (tested 2026-11-19 UTC): Streamable HTTP
Token cost (estimate): approx. 23367 tokens, cl100k estimate (21 tools, measured 2026-11-19 UTC, version 0.65.6). This is an estimate from our testing of the tool names, descriptions and input schemas, counted with cl100k_base.
Permissions: 5 read, 11 write (state-changing), 5 unclassified · Auth: OAuth · Rate limit: unknown · Pricing unit: unknown
Auth: OAuth. Rate limit: unknown. Pricing unit: unknown.
alert_write— write (state-changing)bookmark_content— write (state-changing)browse_collection— readbrowse_data— readcollection_write— write (state-changing)dashboard_write— write (state-changing)document_write— write (state-changing)duplicate_content— write (state-changing)execute_query— unclassifiedexecute_sql— unclassifiedget_content— readget_parameter_values— readglossary— unclassifiedlearn— unclassifiedmeasure_write— write (state-changing)metric_write— write (state-changing)question_write— write (state-changing)run_saved_question— unclassifiedsearch— readsegment_write— write (state-changing)subscription_write— write (state-changing)
recorded OAuth challenge or oauth-client-note
Score 100/100 · Tools 21 · Token cost approx. 23,367 tokens · Compare · Last tested 2026-11-19 UTC · Version tested 0.65.6 · Client endpoint https://{your-metabase-url}/api/metabase-mcp (streamable-http) · Repo metabase/metabase
Summary: Metabase MCP completed an MCP handshake on our own local instance after a local admin login and listed 21 tools. You need your own instance.
Evidence summary
- Handshake
- pass
- Tools listed
- 21
- Context cost
- approx. 23367 tokens, cl100k estimate (21 tools, measured 2026-11-19 UTC, version 0.65.6; an estimate) ranking · add up your servers' context cost
- Login
- Needs a login to your own Metabase instance
- Tested
- 2026-11-19 UTC
Test results
| Test | Result | Points | Evidence |
|---|---|---|---|
| install | pass | 20 | official OSS metabase.jar v0.65.6 from downloads.metabase.com ran on 127.0.0.1 with Eclipse Temurin JRE 21 (user dir, no sudo), H2 app DB, bundled example database that ships with OSS Metabase only, anonymous tracking off; instance stopped and deleted after the test. Official published path: https://downloads.metabase.com/v0.65.6/metabase.jar. You need your own instance. |
| handshake | pass | 30 | MCP initialize + tools/list over streamable-http (protocol None, server metabase 0.1.0) succeeded on our own local instance after a local admin login; 21 tools listed in 0.5s. Without credentials the endpoint returned HTTP 401 with an OAuth challenge. You need your own instance. |
| maintenance | pass | 25 | Repo pushed 0 days before test; 50,412 GitHub stars. |
| docs | pass | 15 | official vendor docs page; states the MCP endpoint; client setup instructions. Self-hosted open source rule: scored from the vendor's docs (https://www.metabase.com/docs/latest/ai/mcp). |
| license | pass | 10 | AGPL-3.0 (OSI-approved), from the repo license file (https://github.com/metabase/metabase/blob/master/LICENSE-AGPL.txt): LICENSE-AGPL.txt is GNU AGPL Version 3. LICENSE.txt (https://github.com/metabase/metabase/blob/master/LICENSE.txt) says non-enterprise source and the OSS binaries at downloads.metabase.com are released under the AGPL. GitHub reports NOASSERTION because the repo is dual-licensed (enterprise/ is Metabase Commercial License). We tested the OSS jar. |
Local-model readiness
Token cost (estimate): approx. 23367 tokens, cl100k estimate for 21 tools · about 285% of an 8k context. This is an estimate from our testing (counted with cl100k_base).
Small-model friendly (schema heuristic, not a model result): unknown.
Not tested
Small-model task runs: Not yet tested.
What we tested and what we didn't
Tested on 2026-11-19 UTC
- Install from the registry
- We connected to our own local instance after a local admin login and asked for its tool list: it listed 21 tools. You need your own instance (Method details: MCP
initializethentools/list) - Maintenance signals (last push, archived/deprecated status)
- Docs (README length, install and config example)
- License (OSI-approved or not)
- Token cost (estimate)
Not tested
- Security: not audited (no code review, no permission or data-flow analysis)
- Real tasks (no functional task runs yet)
- Behaviour with real credentials or a real account
- Performance, rate limits or load
- Correctness of results beyond the listed tasks
Methodology: how we test. A high score means it installs and responds, not that giving it access to your data carries no risk.
Known security issues
Not yet checked.
Monthly roundup: MCP security issues, October 2026.
Tool list changes
Baseline recorded from the 2026-11-19 UTC test run; changes appear after the next test.
Snapshot hash (fingerprint of the tool list)
11708211591c: SHA-256 of the canonical tool names, descriptions and input schemas. If it changes, the tool list changed.
Raw test record (JSON)
{
"name": "metabase-mcp",
"version": "0.65.6",
"registry": "self-hosted",
"status": "working",
"tested": "2026-11-19",
"tools_count": 21,
"deprecated": false,
"archived": false,
"tests": {
"install": [
"pass",
20,
"official OSS metabase.jar v0.65.6 from downloads.metabase.com ran on 127.0.0.1 with Eclipse Temurin JRE 21 (user dir, no sudo), H2 app DB, bundled example database that ships with OSS Metabase only, anonymous tracking off; instance stopped and deleted after the test. Official published path: https://downloads.metabase.com/v0.65.6/metabase.jar. You need your own instance."
],
"handshake": [
"pass",
30,
"MCP `initialize` + `tools/list` over streamable-http (protocol None, server metabase 0.1.0) succeeded on our own local instance after a local admin login; 21 tools listed in 0.5s. Without credentials the endpoint returned HTTP 401 with an OAuth challenge. You need your own instance."
],
"maintenance": [
"pass",
25,
"Repo pushed 0 days before test; 50,412 GitHub stars."
],
"docs": [
"pass",
15,
"official vendor docs page; states the MCP endpoint; client setup instructions. Self-hosted open source rule: scored from the vendor's docs (https://www.metabase.com/docs/latest/ai/mcp)."
],
"license": [
"pass",
10,
"AGPL-3.0 (OSI-approved), from the repo license file (https://github.com/metabase/metabase/blob/master/LICENSE-AGPL.txt): LICENSE-AGPL.txt is GNU AGPL Version 3. LICENSE.txt (https://github.com/metabase/metabase/blob/master/LICENSE.txt) says non-enterprise source and the OSS binaries at downloads.metabase.com are released under the AGPL. GitHub reports NOASSERTION because the repo is dual-licensed (enterprise/ is Metabase Commercial License). We tested the OSS jar."
]
},
"testedAt": "2026-11-19T06:03:39.837Z"
}Install
official OSS metabase.jar v0.65.6 from downloads.metabase.com ran on 127.0.0.1 with Eclipse Temurin JRE 21
Tools listed
alert_write, bookmark_content, browse_collection, browse_data, collection_write, dashboard_write, document_write, duplicate_content, execute_query, execute_sql, get_content, get_parameter_values, glossary, learn, measure_write, metric_write, question_write, run_saved_question, search, segment_write, subscription_write
Quick config
{
"mcpServers": {
"metabase-mcp": {
"type": "http",
"url": "https://{your-metabase-url}/api/metabase-mcp"
}
}
}Add to config Opens the config generator with this server selected.
Setup
- Install. No install step: it is a remote server at https://{your-metabase-url}/api/metabase-mcp.
- Configure. Add the mcpServers entry below to your MCP client config.
- Verify. Restart the client and check that tools/list returns tools (21 in our test).
{
"mcpServers": {
"metabase-mcp": {
"type": "http",
"url": "https://{your-metabase-url}/api/metabase-mcp"
}
}
}Test history
- 2026-11-19 UTC: New
Related: Best data and analytics MCP servers
FAQ
Is Metabase MCP deprecated?
No. Metabase MCP was not deprecated or archived when we last tested it on 2026-11-19 UTC.
What replaces Metabase MCP?
Nothing; Metabase MCP is not deprecated as of 2026-11-19 UTC.
Does Metabase MCP need an API key?
It needs a login to your own Metabase instance (OAuth, local admin). We used a local admin login on an OSS instance we ran ourselves; we did not use Metabase Cloud, a trial, or a license key. Without a login the endpoint returned HTTP 401 with an OAuth challenge and listed no tools.
Embed the badge
Every tested server gets a free embeddable badge. It shows the current score and test date and expires after 90 days. Testing is free; payment never changes a score.