Skip to content
MCP server

Metabase Ai Assistant

MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL

Runs locallyStatus and history
Install
Pricing
Open source
Runs
Locally
Version
3.2.0
Listing updated
4 days ago

About Metabase Ai Assistant

Metabase Ai Assistant is an open-source MCP server for analytics and data. It runs locally on your machine and is started by your AI client.

Install

Run in a terminal

claude mcp add metabase-ai-assistant --env METABASE_URL='<METABASE_URL>' --env METABASE_PASSWORD='<METABASE_PASSWORD>' --env METABASE_API_KEY='<METABASE_API_KEY>' --env DATABASE_PASSWORD='<DATABASE_PASSWORD>' -- npx -y metabase-ai-assistant

Add to claude_desktop_config.json

{
  "mcpServers": {
    "metabase-ai-assistant": {
      "command": "npx",
      "args": [
        "-y",
        "metabase-ai-assistant"
      ],
      "env": {
        "METABASE_URL": "<METABASE_URL>",
        "METABASE_PASSWORD": "<METABASE_PASSWORD>",
        "METABASE_API_KEY": "<METABASE_API_KEY>",
        "DATABASE_PASSWORD": "<DATABASE_PASSWORD>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "metabase-ai-assistant": {
      "command": "npx",
      "args": [
        "-y",
        "metabase-ai-assistant"
      ],
      "env": {
        "METABASE_URL": "<METABASE_URL>",
        "METABASE_PASSWORD": "<METABASE_PASSWORD>",
        "METABASE_API_KEY": "<METABASE_API_KEY>",
        "DATABASE_PASSWORD": "<DATABASE_PASSWORD>"
      }
    }
  }
}

Add to .vscode/mcp.json

{
  "servers": {
    "metabase-ai-assistant": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "metabase-ai-assistant"
      ],
      "env": {
        "METABASE_URL": "<METABASE_URL>",
        "METABASE_PASSWORD": "<METABASE_PASSWORD>",
        "METABASE_API_KEY": "<METABASE_API_KEY>",
        "DATABASE_PASSWORD": "<DATABASE_PASSWORD>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "metabase-ai-assistant": {
      "command": "npx",
      "args": [
        "-y",
        "metabase-ai-assistant"
      ],
      "env": {
        "METABASE_URL": "<METABASE_URL>",
        "METABASE_PASSWORD": "<METABASE_PASSWORD>",
        "METABASE_API_KEY": "<METABASE_API_KEY>",
        "DATABASE_PASSWORD": "<DATABASE_PASSWORD>"
      }
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "metabase-ai-assistant": {
      "command": "npx",
      "args": [
        "-y",
        "metabase-ai-assistant"
      ],
      "env": {
        "METABASE_URL": "<METABASE_URL>",
        "METABASE_PASSWORD": "<METABASE_PASSWORD>",
        "METABASE_API_KEY": "<METABASE_API_KEY>",
        "DATABASE_PASSWORD": "<DATABASE_PASSWORD>"
      }
    }
  }
}

Configuration

  • METABASE_URLMetabase instance URL (e.g., http://localhost:3000)Required
  • METABASE_USERNAMEMetabase username for authentication
  • METABASE_PASSWORDMetabase password for authentication
  • METABASE_API_KEYMetabase API key (alternative to username/password)
  • DATABASE_HOSTPostgreSQL database host for direct SQL execution
  • DATABASE_PORTPostgreSQL database port
  • DATABASE_NAMEPostgreSQL database name
  • DATABASE_USERPostgreSQL database user
  • DATABASE_PASSWORDPostgreSQL database password

Pricing

Open source

Metabase Ai Assistant FAQ

Is Metabase Ai Assistant free?

Yes. Metabase Ai Assistant is open source, so you can use and self-host it for free.

How do I add Metabase Ai Assistant to Claude Code?

Run this command in your terminal: claude mcp add metabase-ai-assistant --env METABASE_URL='<METABASE_URL>' --env METABASE_PASSWORD='<METABASE_PASSWORD>' --env METABASE_API_KEY='<METABASE_API_KEY>' --env DATABASE_PASSWORD='<DATABASE_PASSWORD>' -- npx -y metabase-ai-assistant

What are the best alternatives to Metabase Ai Assistant?

The closest alternatives to Metabase Ai Assistant are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Tapetide - Indian Stock Market MCP, Midplane and World Monitor.

Alternatives to Metabase Ai Assistant

  1. Open-source analytics app where an AI agent builds charts and dashboards from your data

    • Remote
    • Open source
    • 7.7K GitHub stars
    • Analytics and data
  2. Hosted MCP connector for managing Google Ads, Meta Ads, GA4 and Search Console from chat

    • 8 tools
    • Remote
    • Freemium
    • 8.1K GitHub stars
    • Marketing and SEO
  3. Indian NSE and BSE stock market data for AI assistants through 48 MCP tools

    • 17 tools
    • Remote
    • Freemium
    • 150 GitHub stars
    • Finance and payments
  4. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  5. World Monitor

    MCP server

    Live geopolitical intelligence dashboard with an API and MCP server for agents

    • Remote
    • Freemium
    • Analytics and data
  6. CompanyData

    MCP server

    Search and enrich company records from official registers via the CompanyData API

    • 3 tools
    • Remote
    • Paid
    • 3 GitHub stars
    • Analytics and data