เซิร์ฟเวอร์ MCP Metabase Ai Assistant | PlugMCP
ข้ามไปยังเนื้อหา ไดเรกทอรี ผลิตภัณฑ์ แหล่งข้อมูล Pricing จากผู้เผยแพร่
เอกสารประกอบ 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.
MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL
เสียบเครื่องมือใดก็ได้เข้ากับเอเจนต์ใดก็ได้ ไดเรกทอรี MCP สำหรับคนที่ไม่เขียนเซิร์ฟเวอร์
ผลิตภัณฑ์
ไดเรกทอรี
นักพัฒนา
บริษัท
3.2.0 API keyMETABASE_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.
คะแนนในไดเรกทอรี 20/100 อยู่ในรายการ 10 จาก 10
อยู่ใน MCP Registry ทางการ 18 จาก 18
ผู้ดูแลอ้างสิทธิ์แล้ว 0 จาก 8
ตอบกลับพร้อมรายการเครื่องมือ 0 จาก 12
ดาวบน GitHub 0 จาก 16
ยอดดาวน์โหลดรายสัปดาห์ 0 จาก 10
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 เซิร์ฟเวอร์ MCP หมวด Databases เซิร์ฟเวอร์ MCP ที่ดีที่สุดในหมวด Databases
ยังไม่มีรายการเครื่องมือ เซิร์ฟเวอร์แบบรีโมตจะได้รายการหลังการตรวจสอบสถานะครั้งแรก
ติดตั้ง Metabase Ai Assistant อย่างไร? คัดลอกคอนฟิก stdio สำหรับ Cursor, Claude Desktop, Claude Code หรือ VS Code ได้ในหน้านี้ คอนฟิกนี้ใช้การติดตั้งของผู้เผยแพร่ ไม่ใช่พร็อกซีของ PlugMCP
Metabase Ai Assistant ต้องใช้ API key ไหม? ผู้เผยแพร่ระบุตัวแปรสภาพแวดล้อมเหล่านี้: 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-11-09 MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL
เครื่องมือมีคำอธิบาย 0 จาก 6