Metabase Ai Assistant
MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL
- Pricing
- Open source
- Runs
- Locally
- Version
- 3.2.0
- Listing updated
- 4 days ago
About Metabase Ai Assistant
Metabase Ai Assistant is an open-source MCP server for analytics and data. It runs locally on your machine and is started by your AI client.
Install
Run in a terminal
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-assistantAdd to 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>"
}
}
}
}Add to ~/.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>"
}
}
}
}Add to .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>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_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>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"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>"
}
}
}
}Configuration
METABASE_URLMetabase instance URL (e.g., http://localhost:3000)RequiredMETABASE_USERNAMEMetabase username for authenticationMETABASE_PASSWORDMetabase password for authenticationMETABASE_API_KEYMetabase API key (alternative to username/password)DATABASE_HOSTPostgreSQL database host for direct SQL executionDATABASE_PORTPostgreSQL database portDATABASE_NAMEPostgreSQL database nameDATABASE_USERPostgreSQL database userDATABASE_PASSWORDPostgreSQL database password
Pricing
Open source
Metabase Ai Assistant FAQ
Is Metabase Ai Assistant free?
Yes. Metabase Ai Assistant is open source, so you can use and self-host it for free.
How do I add Metabase Ai Assistant to Claude Code?
Run this command in your terminal: 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
What are the best alternatives to Metabase Ai Assistant?
The closest alternatives to Metabase Ai Assistant are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Tapetide - Indian Stock Market MCP, Midplane and World Monitor.
Alternatives to Metabase Ai Assistant

Agent-Native Analytics
MCP serverOpen-source analytics app where an AI agent builds charts and dashboards from your data
- Remote
- Open source
- 7.7K GitHub stars
- Analytics and data

Google Ads + Meta Ads + SEO/GEO MCP
MCP serverHosted MCP connector for managing Google Ads, Meta Ads, GA4 and Search Console from chat
- 8 tools
- Remote
- Freemium
- 8.1K GitHub stars
- Marketing and SEO

Tapetide - Indian Stock Market MCP
MCP serverIndian NSE and BSE stock market data for AI assistants through 48 MCP tools
- 17 tools
- Remote
- Freemium
- 150 GitHub stars
- Finance and payments

Midplane
MCP serverPostgres gateway for AI agents with table grants, column masking and approval for writes
Runs locally- Open source
- 5 GitHub stars
- Databases

World Monitor
MCP serverLive geopolitical intelligence dashboard with an API and MCP server for agents
- Remote
- Freemium
- Analytics and data

CompanyData
MCP serverSearch and enrich company records from official registers via the CompanyData API
- 3 tools
- Remote
- Paid
- 3 GitHub stars
- Analytics and data