Which integrations are available for this server?

Provides comprehensive integration with Metabase instances including creating models, SQL queries, metrics, and dashboards through the Metabase API, with AI-powered features for natural language SQL generation and intelligent dashboard creation. Enables direct PostgreSQL database connections for schema discovery, table relationship detection, SQL query execution, and safe DDL operations with AI object prefix controls for security.

How do I use Metabase AI Assistant?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Metabase AI Assistant create a dashboard showing monthly sales trends by region" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

🚀 Metabase AI Assistant

The Most Powerful MCP Server for Metabase

111+ Tools • AI-Powered SQL • Enterprise Security • Zero Config

MCP Compatible Claude Cursor Node.js

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	111+ ✅	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	✅	❌

Related MCP server: MCP PostgreSQL Server

🚀 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 (111+)

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

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

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

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

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

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 # Main MCP server (111+ tools) │ │ └── handlers/ # Modular handlers │ │ ├── database.js # DB operations │ │ ├── dashboard.js # Dashboard ops │ │ ├── questions.js # Question ops │ │ └── ai.js # AI features │ ├── utils/ │ │ ├── cache.js # TTL-based caching │ │ ├── config.js # Zod validation │ │ └── response-optimizer.js │ └── 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

Star History

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

Metabase AI Assistant