Metabase MCP

What it does

Connects AI assistants to a Metabase instance, allowing them to interact directly with your business intelligence data. It acts as a bridge between the Metabase API and MCP clients, enabling conversational data exploration and automated reporting.

Tools

• list_databases: Lists all configured databases in Metabase.
• list_tables: Retrieves all tables in a specific database with metadata.
• get_table_fields: Gets detailed field and column information for a table.
• execute_query: Runs native SQL queries with parameter support.
• execute_mongodb_query: Executes MongoDB queries with automatic JSON conversion for pipelines.
• execute_card: Runs saved Metabase questions/cards.
• list_cards: Lists all saved questions/cards.
• create_card: Creates new questions/cards using SQL.
• create_mongodb_card: Creates new MongoDB questions/cards.
• list_collections: Browses all Metabase collections.
• create_collection: Creates new collections for better organization.

Installation

Add the following to your claude_desktop_config.json:

{
    "mcpServers": {
        "metabase-mcp": {
            "command": "uvx",
            "args": ["metabase-mcp"],
            "env": {
                "METABASE_URL": "https://your-metabase-instance.com",
                "METABASE_API_KEY": "your-api-key-here"
            }
        }
    }
}

Supported hosts

Confirmed for Claude Desktop and Cursor IDE.