Skip to content
VS Code

metabase ai assistant for VS Code

io.github.enessari/metabase-ai-assistant

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

client:VS Code transport:stdio runtime:npm

Install metabase ai assistant in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "metabase-url",
      "description": "METABASE_URL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "metabase-username",
      "description": "METABASE_USERNAME",
      "password": true
    },
    {
      "type": "promptString",
      "id": "metabase-password",
      "description": "METABASE_PASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "metabase-api-key",
      "description": "METABASE_API_KEY",
      "password": true
    },
    {
      "type": "promptString",
      "id": "database-host",
      "description": "DATABASE_HOST",
      "password": true
    },
    {
      "type": "promptString",
      "id": "database-port",
      "description": "DATABASE_PORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "database-name",
      "description": "DATABASE_NAME",
      "password": true
    },
    {
      "type": "promptString",
      "id": "database-user",
      "description": "DATABASE_USER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "database-password",
      "description": "DATABASE_PASSWORD",
      "password": true
    }
  ],
  "servers": {
    "metabase-ai-assistant": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "metabase-ai-assistant"
      ],
      "env": {
        "METABASE_URL": "${input:metabase-url}",
        "METABASE_USERNAME": "${input:metabase-username}",
        "METABASE_PASSWORD": "${input:metabase-password}",
        "METABASE_API_KEY": "${input:metabase-api-key}",
        "DATABASE_HOST": "${input:database-host}",
        "DATABASE_PORT": "${input:database-port}",
        "DATABASE_NAME": "${input:database-name}",
        "DATABASE_USER": "${input:database-user}",
        "DATABASE_PASSWORD": "${input:database-password}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

metabase ai assistant in other clients