← Index

io.github.enessari/metabase-ai-assistant

io.github.enessari/metabase-ai-assistant·v3.2.0·Databases
Quality Score
80
/100

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

§01  Install
Claude Desktop (claude_desktop_config.json)
{
  "mcpServers": {
    "metabase-ai-assistant": {
      "command": "npx",
      "args": [
        "-y",
        "metabase-ai-assistant"
      ],
      "env": {
        "METABASE_URL": "<metabase_url>",
        "METABASE_USERNAME": "<metabase_username>",
        "METABASE_PASSWORD": "<your-metabase_password>",
        "METABASE_API_KEY": "<your-metabase_api_key>",
        "DATABASE_HOST": "<database_host>",
        "DATABASE_PORT": "<database_port>",
        "DATABASE_NAME": "<database_name>",
        "DATABASE_USER": "<database_user>",
        "DATABASE_PASSWORD": "<your-database_password>"
      }
    }
  }
}
Cursor (.cursor/mcp.json)
{
  "mcpServers": {
    "metabase-ai-assistant": {
      "command": "npx",
      "args": [
        "-y",
        "metabase-ai-assistant"
      ],
      "env": {
        "METABASE_URL": "<metabase_url>",
        "METABASE_USERNAME": "<metabase_username>",
        "METABASE_PASSWORD": "<your-metabase_password>",
        "METABASE_API_KEY": "<your-metabase_api_key>",
        "DATABASE_HOST": "<database_host>",
        "DATABASE_PORT": "<database_port>",
        "DATABASE_NAME": "<database_name>",
        "DATABASE_USER": "<database_user>",
        "DATABASE_PASSWORD": "<your-database_password>"
      }
    }
  }
}
Cline (cline_mcp_settings.json)
npx -y metabase-ai-assistant
§02  Environment variables
METABASE_URL
required

Metabase instance URL (e.g., http://localhost:3000)

METABASE_USERNAME

Metabase username for authentication

METABASE_PASSWORD
secret

Metabase password for authentication

METABASE_API_KEY
secret

Metabase API key (alternative to username/password)

DATABASE_HOST

PostgreSQL database host for direct SQL execution

DATABASE_PORT

PostgreSQL database port

DATABASE_NAME

PostgreSQL database name

DATABASE_USER

PostgreSQL database user

DATABASE_PASSWORD
secret

PostgreSQL database password

§03  MCP Quality Score  ·  methodology
freshness
20
completeness
10
installability
25
documentation
15
stability
10
§04  Alternatives in Databases