Skip to content

1luvc0d3/metabase-mcp

MCP Developer Tools

A write‑enabled, AI‑augmented MCP server for Metabase that adds create/update/delete operations, natural‑language SQL generation, automated insights, and security controls while supporting older Metabase versions.

TypeScript Latest v1.3.0 · 1mo ago Security brief →

Features

  • Write‑enabled CRUD actions for cards, dashboards, and collections
  • Batch execution of up to 20 read ops in parallel
  • Workflow pipelines with chained step references
  • Natural‑language → SQL generation powered by Claude
  • Automated insights and trend analysis

Recent releases

View all 6 releases →
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

v1.1.0 New feature
Notable features
  • .mcpb Claude Desktop Extension for one-click install (metabase-mcp-1.1.0.mcpb)
  • 5 usage examples added to README
Full changelog

Highlights

One-click install via Claude Desktop Extension (.mcpb) — no more editing JSON config files. Download the .mcpb from this release, double-click, and Claude Desktop prompts for your Metabase URL + API key (stored in OS keychain).

What's New

  • 🎁 .mcpb Claude Desktop Extension (#14, #29) — attached to this release as `metabase-mcp-1.1.0.mcpb`
  • 📚 5 usage examples in README covering all tool categories (#30)

Install

One-click (recommended)

  1. Download `metabase-mcp-1.1.0.mcpb` below
  2. Double-click to install in Claude Desktop
  3. Enter your Metabase URL and API key when prompted

Via npm

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

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

v1.0.2 Bug fix

Fixed npm upgrade in the publish workflow for OIDC trusted publishing to work correctly.

Full changelog

What's Changed

First fully automated npm publish via OIDC trusted publishing.

Changes since v1.0.1

  • Fix: upgrade npm to v11+ in publish workflow so OIDC trusted publishing works correctly (#22)

Install

```bash
npx @ai-1luvc0d3/metabase-mcp
```

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
3
Forks
0
Languages
TypeScript JavaScript
Downloads/week
15 ↓43%
NPM Maintainers
1 Single npm maintainer
Contributors
2
TypeScript
Types included ✓

Install & Platforms

Install via
npm

Alternative to

Metabase Official MCP

Beta — feedback welcome: [email protected]