metabase-mcp

Overview

Metabase MCP server is a high-performance Model Context Protocol implementation that bridges AI assistants with Metabase analytics platforms. It provides comprehensive tools for database operations, SQL and MongoDB query execution, card management, and collection organization. The server supports multiple authentication methods including API keys and email/password, and is designed for seamless integration with popular AI clients like Claude Desktop and Cursor IDE.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• list_databases

  List all configured databases in Metabase

  Try:List all databases in MetabaseTry:Show me the available data sources
• list_tables

  Get all tables in a specific database with metadata

  Try:List tables in the sales databaseTry:Show me all tables in database ID 1
• get_table_fields

  Retrieve field/column information for a table

  Try:Show me columns in the users tableTry:Get field information for products table
• execute_query

  Execute native SQL queries with parameter support

  Try:Run SQL query to get top 10 customersTry:Execute SELECT * FROM orders WHERE date > '2023-01-01'
• execute_mongodb_query

  Execute native MongoDB queries with automatic JSON conversion

  Try:Run MongoDB aggregation pipeline on user dataTry:Execute MongoDB query to find active users
• execute_card

  Run saved Metabase questions/cards

  Try:Run the monthly sales report cardTry:Execute the active users dashboard query
• list_cards

  List all saved questions/cards

  Try:Show all saved questionsTry:List all cards in Metabase
• create_card

  Create new questions/cards with SQL queries

  Try:Create a card for monthly revenueTry:Make a new question showing user signups
• create_mongodb_card

  Create new MongoDB questions/cards with native query support

  Try:Create a MongoDB card for user analyticsTry:Make a new question with MongoDB aggregation
• list_collections

  Browse all collections

  Try:Show all collectionsTry:List dashboard collections
• create_collection

  Create new collections for organization

  Try:Create a sales collectionTry:Make a new collection for marketing reports

Comparable tools

Installation

# Run directly without installing (like npx for Python)
uvx metabase-mcp

# With environment variables
METABASE_URL=https://your-instance.com METABASE_API_KEY=your-key uvx metabase-mcp

# Install globally
uv tool install metabase-mcp

# Or with pip
pip install metabase-mcp

# Then run
metabase-mcp

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

FAQ

What authentication methods are supported?

The server supports API key authentication (recommended) and email/password authentication. Credentials can be provided via environment variables.

Which AI assistants are compatible with this MCP server?

The server is compatible with Claude Desktop, Cursor IDE, and any other MCP clients that support the Model Context Protocol.

Compare metabase-mcp with