Skip to content

1luvc0d3/metabase-mcp

MCP Developer Tools

A headless, API‑key authenticated MCP server for Metabase that adds AI‑driven SQL insights, batch and workflow capabilities, security guardrails, audit logging and rate limiting.

TypeScript Latest v1.4.1 · 15d ago Security brief →

Features

  • 30 tools covering read, batch execution (up to 20 parallel ops), workflow pipelines with output references, write operations, NLQ→SQL and automated insights
  • Built‑in SQL guardrails for injection detection, DDL/DML blocking and dangerous pattern enforcement
  • Tiered rate limiting per operation type (read/write/LLM) and comprehensive audit logging with risk assessment

Recent releases

View all 8 releases →
Upgrade now
v1.4.1 Breaking risk
Breaking upgrade

Fix dashboard card API 404

Upgrade now
v1.4.0 Breaking risk
Breaking upgrade

Node.js >=20 + tool ACLs

v1.3.0 New feature
⚠ Upgrade required
  • To revert to pretty‑printed output, set `format: "default"` in tool calls.
  • Existing scripts using individual tool calls will continue to work; new scripts can leverage batch and workflow features.
Notable features
  • `batch_execute` enables parallel execution of up to 20 read operations in a single call
  • `run_workflow` provides composable multi‑step pipelines with output chaining and per‑step error handling
  • Compact JSON responses are now the default for all tools, reducing token usage by ~50%
Full changelog

Introduces CodeAct-inspired composable tools and makes compact responses the default. Inspired by Apple's CodeAct research and Cloudflare Code Mode.

What's New

batch_execute — parallel operations in one call

Run up to 20 read operations simultaneously. Ideal for fetching multiple dashboards, cards, or schemas in a single round trip.

{
  "operations": [
    { "tool": "get_dashboard", "args": { "dashboard_id": 1 } },
    { "tool": "get_dashboard", "args": { "dashboard_id": 2 } },
    { "tool": "execute_card", "args": { "card_id": 5 } }
  ]
}

run_workflow — composable multi-step pipelines

Chain tools sequentially with $stepName.path references to pipe outputs between steps. Eliminates multi-turn chatter for common data exploration flows.

{
  "steps": [
    { "name": "find", "tool": "search_content", "args": { "query": "revenue" } },
    { "name": "details", "tool": "get_card", "args": { "card_id": "$find.results[0].id" } },
    { "name": "data", "tool": "execute_card", "args": { "card_id": "$find.results[0].id" } }
  ]
}

Default compact responses

All tools now return compact JSON by default (~50% token reduction). Use format: "default" to opt into pretty-printed output.

What's Changed

  • batch_execute tool — parallel execution of multiple read operations (#40)
  • run_workflow tool — composable pipelines with output chaining and per-step error handling (#40)
  • Compact responses by default — all 30 tools now use compact JSON (#40)
  • 30 total tools (up from 28)

Install

One-click

Download metabase-mcp-1.3.0.mcpb below, double-click in Claude Desktop.

npm

npx @ai-1luvc0d3/[email protected]

Full Changelog: https://github.com/1luvc0d3/metabase-mcp/compare/v1.2.0...v1.3.0

v1.2.0 New feature
Notable features
  • New `format: "compact"` option reduces token usage by ~50%
  • Streamable HTTP transport added alongside stdio
Full changelog

Adds token-optimized compact response format and Streamable HTTP transport alongside stdio.

What's Changed

  • Compact response format — new format: "compact" option on query/schema tools reduces token usage by ~50% (#38)
  • Streamable HTTP transport — MCP server now supports HTTP in addition to stdio for remote deployments (#38)
  • README repositioned vs Metabase's official MCP (v0.60) — clarifies our differentiation (#37)

Install

npm

npx @ai-1luvc0d3/[email protected]

Full Changelog: https://github.com/1luvc0d3/metabase-mcp/compare/v1.1.1...v1.2.0

v1.1.1 Maintenance

Minor fixes and improvements.

Full changelog

Patch release bringing the repo into full compliance with Anthropic's MCP Directory Policy ahead of directory submission.

What's Changed

  • Tool annotations on all 28 tools (#32) — every tool declares `readOnlyHint` or `destructiveHint` plus `title`, per MCP spec
  • Privacy Policy section in README (#32) — documents what's collected, transmitted, and retained
  • Troubleshooting and Support sections in README (#32)

Install

One-click

Download `metabase-mcp-1.1.1.mcpb` below, double-click in Claude Desktop.

npm

```bash
npx @ai-1luvc0d3/[email protected]
```

Full Changelog: https://github.com/1luvc0d3/metabase-mcp/compare/v1.1.0...v1.1.1

Weekly OSS security release digest.

The CVE patches and breaking changes that affected production tools this week. One email, every Sunday.

No spam, unsubscribe anytime.

About

Stars
4
Forks
1
Languages
TypeScript JavaScript
Downloads/week
15 ↓43%
NPM Maintainers
1 Single npm maintainer
Contributors
3
TypeScript
Types included ✓

Install & Platforms

Install via
npm

Alternative to

Metabase Official MCP

Beta — feedback welcome: [email protected]