metabase-lite-mcp

An MCP (Model Context Protocol) server that lets AI agents interact with Metabase — search dashboards & cards, explore database metadata, and run read-only query previews.

Use Case

Give your AI agent (Claude, Cursor, etc.) the ability to:

• Search & read saved questions (cards) and dashboards
• Explore database schema — list databases, tables, fields, and collections
• Run query previews — execute read-only SQL/Mongo queries with built-in safety validation (write operations are blocked before they ever reach Metabase)

This is useful for agents that need to understand your data, find existing reports, validate queries, or build new dashboards on your behalf.

Prerequisites

• Node.js 18+
• A Metabase instance with API key access enabled
• A Metabase API key (inherits permissions from its group)

Install

npm install -g metabase-lite-mcp

Or use directly with npx (no install needed) — see configuration below.

Configuration

The server requires two environment variables:

| Variable | Description | Example | |---|---|---| | METABASE_BASE_URL | Your Metabase instance URL | https://metabase.example.com | | METABASE_API_KEY | Metabase API key | mb_xxxxxxxxxxxxxx |

Usage with Claude Code

Add to your .mcp.json (project-level or ~/.claude/.mcp.json for global):

{
  "mcpServers": {
    "metabase": {
      "command": "npx",
      "args": ["-y", "metabase-lite-mcp"],
      "env": {
        "METABASE_BASE_URL": "https://metabase.example.com",
        "METABASE_API_KEY": "mb_xxxxxxxxxxxxxx"
      }
    }
  }
}

Usage with Cursor

Add to your Cursor MCP settings (.cursor/mcp.json):

{
  "mcpServers": {
    "metabase": {
      "command": "npx",
      "args": ["-y", "metabase-lite-mcp"],
      "env": {
        "METABASE_BASE_URL": "https://metabase.example.com",
        "METABASE_API_KEY": "mb_xxxxxxxxxxxxxx"
      }
    }
  }
}

Available Tools

| Tool | Description | |---|---| | get_configured_databases | List all databases configured in Metabase | | get_database_metadata | Get tables and fields for a specific database | | get_collections | List all collections | | search_cards | Search saved questions by name/text | | get_card | Get full details of a saved question | | search_dashboards | Search dashboards by name/text | | get_dashboard_full | Get full dashboard with tabs, cards, and filters | | run_query_preview | Execute a read-only query and return results |

Safety

All queries are validated before being sent to Metabase:

• SQL: Blocks INSERT, UPDATE, DELETE, DROP, ALTER, TRUNCATE, CREATE, GRANT, REVOKE, CALL, EXECUTE, and multi-statement queries
• MongoDB: Blocks $out and $merge pipeline stages

Development

git clone https://github.com/sanjeevsingla/metabase-lite-mcp.git
cd metabase-lite-mcp
npm install
npm run build
npm run watch      # Rebuild on changes
npm run inspector  # Launch MCP inspector to test tools interactively

License

MIT