Metabase Ai Assistant MCP 伺服器 | PlugMCP
跳到正文 Metabase AI Assistant — Model Context Protocol (MCP) Server
Metabase AI Assistant is an enterprise-grade Model Context Protocol (MCP) server that connects Large Language Models (LLMs), AI coding assistants, and automated data workflows directly to your Metabase Business Intelligence instance.
The most powerful MCP Server for Metabase - 111+ tools for AI SQL generation, dashboard automation & enterprise BI. Works with Claude, Cursor, ChatGPT.
把任意工具接入任意代理。面向非開發者的 MCP 伺服器目錄;閘道承載流量,n8n 承載應用。
產品
目錄
開發者
公司
Apache-2.0 API 金鑰METABASE_URL, METABASE_USERNAME, METABASE_PASSWORD, METABASE_API_KEY, DATABASE_HOST, DATABASE_PORT, DATABASE_NAME, DATABASE_USER, DATABASE_PASSWORD Featuring 152 dedicated tools , native dbt Metadata & Metrics Auto-Syncer , Metabase to dbt Reverse Lineage Exposures , dbt-Smart Question Creator , Lightdash Code-as-BI YAML-to-Dashboard generation, Cube.js-style Pre-aggregations & Multi-Hop Lineage Joins , Omni.co Controlled Semantic-to-YAML bridge , autonomous self-healing SQL execution, full-scale dashboard architecting, proactive anomaly detection, query index advisory, zero-leak PII masking, and strict security guardrails. Works seamlessly with Claude, Cursor, ChatGPT, Gemini, and Google Antigravity .
🌍 Language Versions / Dil Seçenekleri / 语言版本 / النسخ اللغوية
Table of Contents
Core Architectural Highlights Metabase AI Assistant transforms standard AI interfaces (Claude Desktop, Cursor, VS Code, ChatGPT, Gemini, automated agent frameworks) into full-fledged Metabase power users:
dbt Deep Scanning & MetricFlow Integration (dbt_project_scan_deep) : 9-tier architectural classification, doc('...') resolution, and catalog.json table/column profiling.
Cube.js Multi-Hop Lineage Joins (dbt_lineage_joins_graph) : Resolves shortest join paths via Dijkstra Min-Heap algorithms with 3-color DAG cycle detection.
Cube.js Pre-Aggregation & Rollup Advisor (dbt_semantic_preagg_advisor) : Generates multi-dialect Materialized View DDLs (Postgres, BigQuery, Snowflake, ClickHouse, DuckDB, Redshift, MySQL) with HyperLogLog distinct counts.
Lightdash Code-as-BI Dashboard Builder (dbt_build_dashboard_from_yaml) : Translates meta.metabase and meta.lightdash formatting options into collision-free 24-column Metabase Dashboards.
Omni.co Controlled Semantic-to-YAML Exporter (dbt_semantic_export_yaml) : Serializes approved business rules into clean dbt schema.yml / semantic_models.yml code blocks.
Autonomous Self-Healing SQL Engine (ai_sql_execute_and_heal) : 3-iteration automated error-recovery loop for resilient querying.
Zero-Leak Enterprise PII Masker : Real-time sanitization of emails, phone numbers, national IDs, credit cards, IP addresses, and tokens.
Next-Gen Autonomous Features (v5.1)
1. dbt Architectural Hierarchy & Source Prioritization $$\mathbf{Gold;Marts;(fct_,;dim_,;rpt_)} ;\gg; \mathbf{Silver;(int_)} ;\gg; \mathbf{Bronze;Staging;(stg_)}$$
dbt_inspect_models: Parses dbt manifest.json and MetricFlow semantic models.
dbt_prioritize_sources: Dynamically routes natural language questions to pre-aggregated, tested dimensional and fact tables.
2. Governance-First Semantic Memory (No Silent Learning, No Hard-Deletes)
semantic_memory_propose: Proposes a business rule in PENDING_APPROVAL status.
semantic_memory_approve: Explicitly activates the rule with required data steward comments.
semantic_memory_deprecate: Safely soft-archives rules with mandatory audit reasons (DEPRECATED).
semantic_memory_restore: Instantly restores archived rules.
semantic_memory_list: Lists all rules with complete audit history and timestamps.
3. Autonomous Self-Healing SQL Engine (ai_sql_execute_and_heal)
Catches syntax errors, Levenshtein-distance column misspellings, missing GROUP BY clauses, and dialect quirks across Postgres, MySQL, BigQuery, Snowflake, and SQLite.
Preserves fix history in _provenance.healing_trail.
Metabase Version Compatibility Metabase AI Assistant provides backward and forward compatibility across all major Metabase architectures:
Quick Start & Installation
Global Execution via NPX npx metabase-ai-assistant
Manual Installation via NPM npm install -g metabase-ai-assistant
Client Configuration & Desktop Setup
1. Claude Desktop
Option A: One-Click Extension (DXT / MCPB)
Open Claude Desktop Settings -> Developer / Extensions -> Install Local Extension .
Select this repository folder.
Or install via Smithery CLI:
npx -y @smithery/cli install metabase-ai-assistant --client claude
Option B: Manual JSON Configuration Add the server definition to claude_desktop_config.json:
macOS : ~/Library/Application Support/Claude/claude_desktop_config.json
Windows : %APPDATA%\Claude\claude_desktop_config.json
{
"mcpServers": {
"metabase": {
"command": "npx",
"args": ["-y", "metabase-ai-assistant"],
"env": {
"METABASE_URL": "https://your-metabase-instance.com",
"METABASE_API_KEY": "mb_your_api_key_here",
"METABASE_READ_ONLY_MODE": "true"
}
}
}
}
2. Cursor IDE, Windsurf & VS Code Add to .cursor/mcp.json or VS Code MCP settings:
{
"mcpServers": {
"metabase": {
"command": "npx",
"args": ["-y", "metabase-ai-assistant"],
"env": {
"METABASE_URL": "https://your-metabase-instance.com",
"METABASE_API_KEY": "mb_your_api_key_here",
"METABASE_READ_ONLY_MODE": "true"
}
}
}
}
3. ChatGPT Custom GPTs & Actions Expose Metabase AI Assistant as an OpenAPI Action for ChatGPT Plus / Team / Enterprise:
Start the Remote SSE/HTTP server: npm run start:sse
In ChatGPT, create a Custom GPT -> Actions -> Import from URL : https://your-domain.com/tools/openapi.json
Detailed setup guide: docs/integrations/CHATGPT_ACTIONS_GUIDE.md
4. Google Gemini & Google AI Studio Pass tool definitions to Gemini Function Calling SDKs (@google/genai or google-generativeai):
5. Cloudflare Workers (Serverless Edge) Deploy directly to Cloudflare's edge network for free:
cd deploy/cloudflare
npx wrangler deploy
Tool Categories Overview (143 Tools) The 143 MCP tools are categorized into 10 operational domains:
dbt & Semantic Layer (6 tools) : Model hierarchy inspection, lineage resolution, source prioritization, governance-first business memory (propose, approve, soft-deprecate, restore).
Autonomous AI BI Operations (4 tools) : Self-healing SQL engine, end-to-end dashboard architect, query index advisor, proactive anomaly detector.
SQL & Query Execution (14 tools) : Direct SQL queries, async execution jobs, query status tracking, pagination, and speed benchmarks.
AI Query Intelligence (6 tools) : Natural language to SQL, query performance optimizer, query explainer, automated table description.
Cards & Visualizations (34 tools) : Question creation, query execution, parametric filtering, card cloning, visualization settings.
Dashboards & Layouts (22 tools) : Dashboard creation, grid placement, filter linking, tab management, executive templates.
Collections & Organization (8 tools) : Collection tree traversal, hierarchical moves, permission graphs, item listing.
Schema & Data Modeling (18 tools) : Schema retrieval, foreign key inference, data profiling, table definitions.
User & Permission Administration (12 tools) : User invitations, group assignments, membership controls, status toggling.
Actions & Documentation (19 tools) : Metabase actions execution, pulses, alerts, webhooks, metrics, segment definitions, workspace migration.
Testing & Quality Assurance Backed by an automated multi-tier test suite covering unit logic, integration workflows, and security fuzzing:
# Run complete test suite (32 suites, 583 tests)
npm test
# Run unit tests
npm run test:unit
# Run integration workflows
npm run test:integration
# Run security & PII zero-leak fuzzing tests
npm run test:security
License Licensed under the Apache License 2.0 . See the LICENSE file for details.
Graphify Turn any codebase, with its docs, SQL schemas, configs, and PDFs, into a queryable knowledge graph. A /graphify skill for Claude Code, Cursor, Codex, and Gemini CLI: local deterministic AST parsing, e Private Gpt Complete API layer for private AI applications on local models: RAG, skills, tools, MCP, text-to-sql, and more. Works with any OpenAI-compatible inference server. Scientific Agent Skills Turn any AI agent into an AI Scientist. The #1 Agent Skills library for science, used by 250,000+ scientists worldwide. 177 ready-to-use validated skills plus 100+ scientific databases covering biolog Open Code Review Secure, fast, efficient, battle-tested at Alibaba's scale. Hybrid architecture code review tool: deterministic pipelines + LLM Agent, precise line-level comments, built-in multi-language ruleset (NPE, Codebase Memory Local code intelligence for developers and AI agents. Connect code, docs and infrastructure in a persistent graph, with CBM Lens, MCP tools, agent integrations and change-aware test selection. Orm The Prisma ORM: write your application in TypeScript with human-readable queries instead of SQL. Host your database on Prisma Postgres and your app on Prisma Compute. OpenViking Self-evolving Context Database for AI Agents. Unify Agent Memory, Knowledge RAG and Skills. Context Mode Free, local plugin that keeps tool output out of your coding agent's context window. Sandbox and SQLite FTS5 search, 99% fewer bytes in context. Works with Claude Code, Codex, Pi, OMP, OpenCode, Gemin Dbx 25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Dock Xerj AI search engine and MCP server for bots and agents. One Rust binary indexes code, docs, logs, JSONL/CSV and PDFs for BM25 full-text, vector and hybrid search, code search without grep, agent memory a Wasp The batteries-included full-stack framework for the AI era. Develop JS/TS web apps (React, Node.js, and Prisma) using declarative code that abstracts away complex full-stack features like auth, backgr WrenAI GenBI (Generative BI) for AI agents, an open-source, governed text-to-SQL through an open context layer that turns natural-language questions into trusted dashboards, charts, and SQL across 20+ data s Databases MCP 伺服器 最佳 Databases MCP 伺服器
尚無工具清單。遠端伺服器會在首次健康檢查後取得工具清單。
如何安裝 Metabase Ai Assistant? 在本頁複製適用於 Cursor、Claude Desktop、Claude Code 或 VS Code 的 stdio 設定。它使用發布者的安裝方式,而不是 PlugMCP 代理伺服器。
Metabase Ai Assistant 需要 API 金鑰嗎? 發布者列出了以下環境變數:METABASE_URL, METABASE_USERNAME, METABASE_PASSWORD, METABASE_API_KEY, DATABASE_HOST, DATABASE_PORT, DATABASE_NAME, DATABASE_USER, DATABASE_PASSWORD。
Metabase Ai Assistant 使用哪種傳輸方式? Metabase Ai Assistant 透過 stdio 在本機執行。
Metabase Ai Assistant 上次檢查是什麼時候? 上次檢查時間:2026-10-28。 The most powerful MCP Server for Metabase - 111+ tools for AI SQL generation, dashboard automation & enterprise BI. Works with Claude, Cursor, ChatGPT.
工具
0 / 10