MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL
Config is the same across clients — only the file and path differ.
{
"mcpServers": {
"metabase": {
"env": {
"METABASE_URL": "https://your-metabase.com",
"METABASE_API_KEY": "mb_your_api_key"
},
"args": [
"-y",
"metabase-ai-assistant"
],
"command": "npx"
}
}
}Are you the author?
Add this badge to your README to show your security score and help users find safe servers.
134 Tools • MCP SDK v1.26.0 • AI-Powered SQL • Structured Output • Enterprise Security
Run this in your terminal to verify the server starts. Then let us know if it worked — your result helps other developers.
npx -y 'metabase-ai-assistant' 2>&1 | head -1 && echo "✓ Server started successfully"
After testing, let us know if it worked:
Five weighted categories — click any category to see the underlying evidence.
No known CVEs.
Checked metabase-ai-assistant against OSV.dev.
Click any tool to inspect its schema.
Be the first to review
Have you used this server?
Share your experience — it helps other developers decide.
Sign in to write a review.
Others in analytics
MCP Server for GCP environment for interacting with various Observability APIs.
⚡ A Simple / Speedy / Secure Link Shortener with Analytics, 100% run on Cloudflare.
MCP server for InsightSentry financial data API - market data, options, screeners, and more
MCP server for Google Lighthouse performance metrics
MCP Security Weekly
Get CVE alerts and security updates for io.github.enessari/metabase-ai-assistant and similar servers.
Start a conversation
Ask a question, share a tip, or report an issue.
Sign in to join the discussion.
134 Tools • MCP SDK v1.26.0 • AI-Powered SQL • Structured Output • Enterprise Security
Turn your AI assistant into a Metabase power user.
Generate SQL from natural language, create dashboards, manage users, and automate BI workflows.
"I analyzed every Metabase MCP server on the market. This one has 4x more tools and features than any competitor."
| Feature | This Project | Other MCP Servers |
|---|---|---|
| Total Tools | 134 ✅ | 6-30 |
| AI SQL Generation | ✅ | ❌ |
| AI SQL Optimization | ✅ | ❌ |
| Dashboard Templates | ✅ | ❌ |
| User Management | ✅ | ❌ |
| Workspace Export/Import | ✅ | ❌ |
| Read-Only Security Mode | ✅ | ✅ |
| Response Caching | ✅ | ✅ |
| Activity Logging | ✅ | ❌ |
| Metadata Analytics | ✅ | ❌ |
| Parametric Questions | ✅ | ❌ |
| Environment Comparison | ✅ | ❌ |
| Structured Output (JSON) | ✅ | ❌ |
| Tool Annotations | ✅ | ❌ |
npx metabase-ai-assistant
{
"mcpServers": {
"metabase": {
"command": "npx",
"args": ["-y", "metabase-ai-assistant"],
"env": {
"METABASE_URL": "https://your-metabase.com",
"METABASE_API_KEY": "mb_your_api_key"
}
}
}
}
That's it! Your AI assistant now has full Metabase superpowers. 🦸
You: "Show me total revenue by product category for the last 30 days"
AI: Uses ai_sql_generate → Runs query → Returns formatted results
You: "Create an executive dashboard for our e-commerce sales"
AI: Uses mb_dashboard_template_executive → Creates fully configured dashboard
You: "What tables are related to 'orders' and show their relationships"
AI: Uses db_relationships_detect → Returns complete ER diagram info
You: "DROP TABLE users"
AI: 🔒 Blocked - Read-only mode active
🆕 All tools include MCP annotations and
title. 16 priority tools supportoutputSchema+ `structur