io.github.enessari/metabase-ai-assistant
MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL
Ask AI about io.github.enessari/metabase-ai-assistant
Powered by Claude Β· Grounded in docs
I know everything about io.github.enessari/metabase-ai-assistant. Ask me about installation, configuration, usage, or troubleshooting.
0/500
Reviews
Documentation
π Metabase AI Assistant
The Most Powerful MCP Server for Metabase
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.
π¦ Install Now β’ π Documentation β’ π― Features β’ β Star Us
β Why This Project?
"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 | β | β |
π Quick Start
One-Line Install
npx metabase-ai-assistant
Add to Claude Desktop / Cursor
{
"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. π¦Έ
π― What Can You Do?
π¬ Natural Language β SQL
You: "Show me total revenue by product category for the last 30 days"
AI: Uses ai_sql_generate β Runs query β Returns formatted results
π Instant Dashboard Creation
You: "Create an executive dashboard for our e-commerce sales"
AI: Uses mb_dashboard_template_executive β Creates fully configured dashboard
π Deep Database Exploration
You: "What tables are related to 'orders' and show their relationships"
AI: Uses db_relationships_detect β Returns complete ER diagram info
π‘οΈ Enterprise-Grade Security
You: "DROP TABLE users"
AI: π Blocked - Read-only mode active
π§ Complete Tool List (134)
π All tools include MCP annotations and
title. 16 priority tools supportoutputSchema+structuredContentfor typed JSON responses.
π Database Operations (25 tools)
| Tool | Description |
|---|---|
db_list | List all databases |
db_schemas | Get schemas in a database |
db_tables | Get tables with fields |
sql_execute | Execute SQL queries |
db_table_create | Create tables (AI-prefixed) |
db_view_create | Create views |
db_matview_create | Create materialized views |
db_index_create | Create indexes |
db_vacuum_analyze | VACUUM and ANALYZE |
db_query_explain | EXPLAIN query plans |
db_table_stats | Table statistics |
db_index_usage | Index usage analysis |
db_schema_explore | Fast schema exploration |
db_schema_analyze | Deep schema analysis |
db_relationships_detect | Detect foreign keys |
| ...and more |
π€ AI-Powered Features (5 tools)
| Tool | Description |
|---|---|
ai_sql_generate | Natural language β SQL |
ai_sql_optimize | Query optimization suggestions |
ai_sql_explain | Explain SQL in plain English |
ai_relationships_suggest | Suggest table relationships |
mb_auto_describe | Auto-generate descriptions |
π Question/Card Management (12 tools)
| Tool | Description |
|---|---|
mb_question_create | Create new questions |
mb_questions | List all questions |
mb_question_create_parametric | Parametric questions |
mb_card_get | Get card details |
mb_card_update | Update cards |
mb_card_delete | Delete cards |
mb_card_archive | Archive cards |
mb_card_data | Get card data as JSON |
mb_card_copy | Copy cards |
mb_card_clone | Clone cards |
| ...and more |
π Dashboard Management (14 tools)
| Tool | Description |
|---|---|
mb_dashboard_create | Create dashboards |
mb_dashboards | List all dashboards |
mb_dashboard_get | Get dashboard details |
mb_dashboard_update | Update dashboards |
mb_dashboard_delete | Delete dashboards |
mb_dashboard_add_card | Add cards to dashboard |
mb_dashboard_add_filter | Add filters |
mb_dashboard_layout_optimize | Optimize layout |
mb_dashboard_template_executive | Executive templates |
| ...and more |
π₯ User & Permission Management (10 tools)
| Tool | Description |
|---|---|
mb_user_list | List users |
mb_user_get | Get user details |
mb_user_create | Create users |
mb_user_update | Update users |
mb_user_disable | Disable users |
mb_permission_group_list | List groups |
mb_permission_group_create | Create groups |
| ...and more |
π Metadata Analytics (14 tools)
| Tool | Description |
|---|---|
mb_meta_overview | Instance health check |
mb_meta_query_performance | Query analytics |
mb_meta_content_usage | Content usage stats |
mb_meta_user_activity | User activity |
mb_meta_table_dependencies | Table dependencies |
mb_meta_impact_analysis | Breaking change analysis |
mb_meta_optimization_recommendations | Index suggestions |
mb_meta_export_workspace | Backup to JSON |
mb_meta_import_preview | Import dry-run |
mb_meta_compare_environments | Dev vs Prod diff |
mb_meta_auto_cleanup | Safe cleanup |
| ...and more |
π‘οΈ Security Features
| Feature | Description |
|---|---|
| π Read-Only Mode | Blocks INSERT, UPDATE, DELETE, DROP (default: enabled) |
| π·οΈ AI Prefix | All AI-created objects use claude_ai_ prefix |
| β Explicit Approval | Destructive operations require confirmation |
| π Activity Logging | Full audit trail of all operations |
| π Env Validation | Zod-validated environment variables |
| πΎ Auto-Backup | Prompts for backup before destructive ops |
# Enable/disable read-only mode
METABASE_READ_ONLY_MODE=true # Default: blocks write ops
METABASE_READ_ONLY_MODE=false # Allow write operations
βοΈ Configuration
Create a .env file:
# Required
METABASE_URL=https://your-metabase.com
METABASE_API_KEY=mb_your_api_key
# Or use username/password
# METABASE_USERNAME=admin@example.com
# METABASE_PASSWORD=your_password
# Security (defaults to true)
METABASE_READ_ONLY_MODE=true
# AI Features (optional)
ANTHROPIC_API_KEY=sk-ant-...
OPENAI_API_KEY=sk-...
# Performance (optional)
CACHE_TTL_MS=600000 # 10 minutes
π¦ Installation Options
npm (Recommended)
npm install -g metabase-ai-assistant
Docker
docker run -e METABASE_URL=... -e METABASE_API_KEY=... ghcr.io/enessari/metabase-ai-assistant
From Source
git clone https://github.com/enessari/metabase-ai-assistant.git
cd metabase-ai-assistant
npm install
npm run mcp
ποΈ Architecture
metabase-ai-assistant/
βββ src/
β βββ mcp/
β β βββ server.js # MCP Server entry point
β β βββ tool-registry.js # 134 tool definitions + annotations + outputSchema
β β βββ tool-router.js # Dynamic routing with read-only gate
β β βββ handlers/ # 15 modular handler files
β βββ utils/
β β βββ structured-response.js # Structured output (MCP 2025-06-18)
β β βββ cache.js # TTL-based caching
β β βββ config.js # Zod validation
β β βββ response-optimizer.js # Compact response formatting
β βββ metabase/
β βββ client.js # Metabase API client
π€ Contributing
We welcome contributions! See CONTRIBUTING.md for guidelines.
# Fork, clone, install
git clone https://github.com/YOUR_USERNAME/metabase-ai-assistant.git
npm install
# Create feature branch
git checkout -b feature/amazing-feature
# Test and submit PR
npm test
git push origin feature/amazing-feature
π Resources
π License
Apache License 2.0 - see LICENSE
β Star this repo if it helps you!
Built with β€οΈ by Abdullah Enes SARI @ ONMARTECH LLC
Keywords: Metabase MCP Server, Model Context Protocol, AI SQL Generation, Business Intelligence, Claude AI, Cursor AI, Natural Language SQL, Dashboard Automation, PostgreSQL, Data Analytics, LLM Tools
