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