io.github.enessari/metabase-ai-assistant
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_URLrequired
Metabase instance URL (e.g., http://localhost:3000)
METABASE_USERNAMEMetabase username for authentication
METABASE_PASSWORDsecret
Metabase password for authentication
METABASE_API_KEYsecret
Metabase API key (alternative to username/password)
DATABASE_HOSTPostgreSQL database host for direct SQL execution
DATABASE_PORTPostgreSQL database port
DATABASE_NAMEPostgreSQL database name
DATABASE_USERPostgreSQL database user
DATABASE_PASSWORDsecret
PostgreSQL database password
§03 MCP Quality Score · methodology
freshness
20
completeness
10
installability
25
documentation
15
stability
10
§04 Alternatives in Databases
ai.haymon/dbmcp
ai.haymon/dbmcp
Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite
ai.smithery/MisterSandFR-supabase-mcp-selfhosted
ai.smithery/MisterSandFR-supabase-mcp-selfhosted
Manage Supabase projects end to end across database, auth, storage, realtime, and migrations. Moni…
ai.smithery/afgong-sqlite-mcp-server
ai.smithery/afgong-sqlite-mcp-server
Explore your Messages SQLite database to browse tables and inspect schemas with ease. Run flexible…