metabase-ai-assistant

---

⭐ 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 support outputSchema + structuredContent for 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)