Connects agents to a Metabase instance to generate and run SQL, build dashboards and automate BI tasks.
Setup
Choose your client, copy the config, then fill in any required environment variables.
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~/.codex/config.toml
[mcp_servers.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>" }
# codex 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~/.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>"
}
}
}
}.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>"
}
}
}
}~/.gemini/settings.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>"
}
}
}
}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>"
}
}
}
}.trae/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>"
}
}
}
}Environment variables
METABASE_URLMETABASE_PASSWORDMETABASE_API_KEYDATABASE_PASSWORD
Replace the placeholders with your own credentials and keep them out of version control.