MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL
Connect Runs on your machine
claude mcp add metabase-ai-assistant -e METABASE_URL=<METABASE_URL> -e METABASE_USERNAME=<METABASE_USERNAME> -e METABASE_PASSWORD=<METABASE_PASSWORD> -e METABASE_API_KEY=<METABASE_API_KEY> -e DATABASE_HOST=<DATABASE_HOST> -e DATABASE_PORT=<DATABASE_PORT> -e DATABASE_NAME=<DATABASE_NAME> -e DATABASE_USER=<DATABASE_USER> -e DATABASE_PASSWORD=<DATABASE_PASSWORD> -- npx -y [email protected]{
"mcpServers": {
"metabase-ai-assistant": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"METABASE_URL": "<METABASE_URL>",
"METABASE_USERNAME": "<METABASE_USERNAME>",
"METABASE_PASSWORD": "<METABASE_PASSWORD>",
"METABASE_API_KEY": "<METABASE_API_KEY>",
"DATABASE_HOST": "<DATABASE_HOST>",
"DATABASE_PORT": "<DATABASE_PORT>",
"DATABASE_NAME": "<DATABASE_NAME>",
"DATABASE_USER": "<DATABASE_USER>",
"DATABASE_PASSWORD": "<DATABASE_PASSWORD>"
}
}
}
}{
"mcpServers": {
"metabase-ai-assistant": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"METABASE_URL": "<METABASE_URL>",
"METABASE_USERNAME": "<METABASE_USERNAME>",
"METABASE_PASSWORD": "<METABASE_PASSWORD>",
"METABASE_API_KEY": "<METABASE_API_KEY>",
"DATABASE_HOST": "<DATABASE_HOST>",
"DATABASE_PORT": "<DATABASE_PORT>",
"DATABASE_NAME": "<DATABASE_NAME>",
"DATABASE_USER": "<DATABASE_USER>",
"DATABASE_PASSWORD": "<DATABASE_PASSWORD>"
}
}
}
}{
"servers": {
"metabase-ai-assistant": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"METABASE_URL": "<METABASE_URL>",
"METABASE_USERNAME": "<METABASE_USERNAME>",
"METABASE_PASSWORD": "<METABASE_PASSWORD>",
"METABASE_API_KEY": "<METABASE_API_KEY>",
"DATABASE_HOST": "<DATABASE_HOST>",
"DATABASE_PORT": "<DATABASE_PORT>",
"DATABASE_NAME": "<DATABASE_NAME>",
"DATABASE_USER": "<DATABASE_USER>",
"DATABASE_PASSWORD": "<DATABASE_PASSWORD>"
}
}
}
}Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.
Tools
This server runs locally, so its tools are listed by your MCP client once it starts.
Environment variables
| Name | Description |
|---|---|
METABASE_URLRequired | Metabase instance URL (e.g., http://localhost:3000) |
METABASE_USERNAMEOptional | Metabase username for authentication |
METABASE_PASSWORDOptional, secret | Metabase password for authentication |
METABASE_API_KEYOptional, secret | Metabase API key (alternative to username/password) |
DATABASE_HOSTOptional | PostgreSQL database host for direct SQL execution |
DATABASE_PORTOptional | PostgreSQL database port |
DATABASE_NAMEOptional | PostgreSQL database name |
DATABASE_USEROptional | PostgreSQL database user |
DATABASE_PASSWORDOptional, secret | PostgreSQL database password |
Details
| Package | [email protected] (NPM, stdio) |
| First published | 23 Jan 2026 |
| Last updated | 23 Jan 2026 |
| Registry name | io.github.enessari/metabase-ai-assistant |
More databases servers See all
Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.