Skip to main content
mcpSource-backedReview first Safety Privacy

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.

HarnessClaude CodeCodexCursorClaude Desktop
Review first review before installing

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
Source repository stats
Scope
Source repo
Collection metadata
Estimated setup
5 minutes
Difficulty
beginner
Tool listing metadata
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=false only 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_MODE env vars, 1M-row bulk export, 90% token reduction optimization, and Claude.ai featured listing.
  • Claude Code MCP documentation at code.claude.com/docs/en/mcp describes the stdio connector pattern used above.

Source citations

Add this badge to your README

Show that Metabase MCP Server for Claude is listed on HeyClaude. Paste this Markdown into your README — it renders the badge and links back to this page.

Listed on HeyClaude
[![Listed on HeyClaude](https://heyclau.de/badge/mcp/metabase-mcp-server.svg)](https://heyclau.de/entry/mcp/metabase-mcp-server)

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.

FieldMetabase 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 riskReview firstReview firstReview firstReview first
Notes Safety Privacy Safety Privacy Safety Privacy Safety Privacy
Categorymcpmcpmcpmcp
Sourcesource-backedsource-backedsource-backedsource-backed
AuthorJericho SequitinjparkerwebTableauTeradata
Added2026-06-182026-06-182026-06-182026-06-18
Platforms
Claude CodeCodexCursorClaude Desktop
Claude CodeClaude Desktop
Claude CodeClaude Desktop
Claude CodeClaude Desktop
Source repo
Safety notesRead-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 notesDashboard 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
  • 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.
  • A local SQLite database file (`.db`) you want to connect to.
  • Node.js with `npx` available.
  • An MCP client such as Claude Code or Claude Desktop.
  • A Tableau Server or Tableau Cloud account with a Personal Access Token (PAT) — create one in My Account Settings.
  • Your Tableau Server URL, site name, PAT name, and PAT value.
  • Node.js 22.7.5+ with `npx` available.
  • An MCP client such as Claude Code or Claude Desktop.
  • A Teradata database instance accessible from your network.
  • A Teradata username and password with appropriate query permissions.
  • Python with `uvx` available.
  • An MCP client such as Claude Code or Claude Desktop.
Install
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 mcp add sqlite -- npx -y mcp-sqlite /path/to/database.db
claude mcp add tableau -e SERVER=https://your-tableau-server.com -e SITE_NAME=your_site -e PAT_NAME=your_pat -e PAT_VALUE=your_pat_value -- npx -y @tableau/mcp-server@latest
claude mcp add teradata -e DATABASE_URI="teradata://username:password@host:1025/databasename" -- uvx teradata-mcp-server
Config
{
  "mcpServers": {
    "metabase": {
      "command": "npx",
      "args": ["-y", "@jerichosequitin/metabase-mcp"],
      "env": {
        "METABASE_URL": "https://your-metabase.example.com",
        "METABASE_API_KEY": "<your-api-key>",
        "METABASE_READ_ONLY_MODE": "true"
      }
    }
  }
}
{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": ["-y", "mcp-sqlite", "/path/to/database.db"]
    }
  }
}
{
  "mcpServers": {
    "tableau": {
      "command": "npx",
      "args": ["-y", "@tableau/mcp-server@latest"],
      "env": {
        "SERVER": "https://your-tableau-server.com",
        "SITE_NAME": "your_site",
        "PAT_NAME": "your_pat",
        "PAT_VALUE": "your_pat_value"
      }
    }
  }
}
{
  "mcpServers": {
    "teradata": {
      "command": "uvx",
      "args": ["teradata-mcp-server"],
      "env": {
        "DATABASE_URI": "teradata://username:password@host:1025/databasename",
        "DEFAULT_ROW_LIMIT": "1000",
        "MAX_ROW_LIMIT": "50000"
      }
    }
  }
}
Citations
ClaimUnclaimedUnclaimedUnclaimedUnclaimed

Signals

Loading live community signals…

More like this, weekly

A short, calm digest of reviewed Claude resources. Unsubscribe any time.