Metabase AI Assistant

🚀 元数据库AI助手

Metabase最强大的MCP服务器

134工具 • MCP SDK v1.26.0 • 基于人工智能的SQL • 结构化输出 • 企业安全

](https://www.npmjs.com/package/metabase-ai-assistant) ](https://www.npmjs.com/package/metabase-ai-assistant) ](https://github.com/enessari/metabase-ai-assistant/stargazers) 

将你的AI助手变成Metabase的高级用户。\ 从自然语言生成SQL、创建仪表板、管理用户和自动化BI工作流。

______________________________________________________________________

⭐ 为什么是这个项目？

“我分析了市场上的每一台Metabase MCP服务器。这款服务器的工具和功能比任何竞争对手都多4倍。”

______________________________________________________________________

🚀 快速开始

单线安装

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"
      }
    }
  }
}

就是这样！你的AI助手现在拥有完整的Metabase超能力。 🦸

______________________________________________________________________

🎯 你能做什么？

💬 自然语言→ SQL

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

______________________________________________________________________

🔧 完整工具清单（134）

🆕 所有工具都包括MCP注释和 title支持16种优先工具 outputSchema + structuredContent 用于键入JSON响应。

📊 Database Operations (25 tools)

🤖 AI-Powered Features (5 tools)

📋 Question/Card Management (12 tools)

📈 Dashboard Management (14 tools)

👥 User & Permission Management (10 tools)

📊 Metadata Analytics (14 tools)

______________________________________________________________________

🛡️ 安全特性

# Enable/disable read-only mode
METABASE_READ_ONLY_MODE=true  # Default: blocks write ops
METABASE_READ_ONLY_MODE=false # Allow write operations

______________________________________________________________________

⚙️ 配置

创建一个 .env 文件：

# 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

______________________________________________________________________

📦 安装选项

npm（推荐）

npm install -g metabase-ai-assistant

码头工人

docker run -e METABASE_URL=... -e METABASE_API_KEY=... ghcr.io/enessari/metabase-ai-assistant

来源

git clone https://github.com/enessari/metabase-ai-assistant.git
cd metabase-ai-assistant
npm install
npm run mcp

______________________________________________________________________

🏗️ 建筑

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

______________________________________________________________________

🤝 贡献

我们欢迎捐款！看 贡献.md 作为指导方针。

# 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

______________________________________________________________________

📚 资源

• 📖 全部文件
• 🐛 报告问题
• 💬 讨论

______________________________________________________________________

📄 许可证

Apache许可证2.0-请参阅 许可证

______________________________________________________________________

⭐ 如果对你有帮助，请在这个仓库上签名！


______________________________________________________________________

关键词： 元数据库MCP服务器、模型上下文协议、AI SQL生成、商业智能、Claude AI、Cursor AI、自然语言SQL、仪表板自动化、PostgreSQL、数据分析、LLM工具