How do I install Metabase Ai Assistant?

Copy the stdio config for Cursor, Claude Desktop, Claude Code, or VS Code on this page. It uses the publisher's install, not a PlugMCP proxy.

Does Metabase Ai Assistant need an API key?

The publisher lists these environment variables: METABASE_URL, METABASE_USERNAME, METABASE_PASSWORD, METABASE_API_KEY, DATABASE_HOST, DATABASE_PORT, DATABASE_NAME, DATABASE_USER, DATABASE_PASSWORD.

What transport does Metabase Ai Assistant use?

Metabase Ai Assistant runs locally over stdio.

When was Metabase Ai Assistant last checked?

Last checked 2026-11-09. MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL

Metabase Ai Assistant MCP server

Power your agent

Add this server

The publisher's own command. Not a PlugMCP endpoint.

Add to Cursor Add to VS Code Run on PlugMCP

Host a copy with our keys and logs.

Local command

npx -y [email protected]

Credentials from the publisher

METABASE_URL — Metabase instance URL (e.g., http://localhost:3000)
METABASE_USERNAME — Metabase username for authentication
METABASE_PASSWORD — Metabase password for authentication
METABASE_API_KEY — Metabase API key (alternative to username/password)
DATABASE_HOST — PostgreSQL database host for direct SQL execution
DATABASE_PORT — PostgreSQL database port
DATABASE_NAME — PostgreSQL database name
DATABASE_USER — PostgreSQL database user
DATABASE_PASSWORD — PostgreSQL database password

Claude Code has no install link for a local command. Copy the command below and run it in a terminal.

shClaude Code

1METABASE_URL=<value> METABASE_USERNAME=<value> METABASE_PASSWORD=<secret> METABASE_API_KEY=<secret> DATABASE_HOST=<value> DATABASE_PORT=<value> DATABASE_NAME=<value> DATABASE_USER=<value> DATABASE_PASSWORD=<secret> claude mcp add io.github.enessari-metabase-ai-assistant -- npx -y metabase-ai-assistant@3.2.0

Run in a terminal.

jsonClaude Desktop

1{2  "mcpServers": {3    "io.github.enessari-metabase-ai-assistant": {4      "command": "npx",5      "args": [6        "-y",7        "[email protected]"8      ],9      "env": {10        "METABASE_URL": "<value>",11        "METABASE_USERNAME": "<value>",12        "METABASE_PASSWORD": "<secret>",13        "METABASE_API_KEY": "<secret>",14        "DATABASE_HOST": "<value>",15        "DATABASE_PORT": "<value>",16        "DATABASE_NAME": "<value>",17        "DATABASE_USER": "<value>",18        "DATABASE_PASSWORD": "<secret>"19      }20    }21  }22}

claude_desktop_config.json

Local · npmPublisher installStep-by-step: add this in Claude

Remote URL or a command on your machine? How the two installs differ

Run on PlugMCP

Host a copy with our keys and logs.

A new server you create. It is not this listing's official endpoint. Use the publisher install when you want their URL and their credentials.

Launch

Server facts

Local

Transport: stdio
Version

Tools

No tool list yet. Remote servers get one after the first health check.

FAQ

Questions

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.

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 / 语言版本 / النسخ اللغوية

Core Architectural Highlights
Next-Gen Autonomous Features (v5.3)
Metabase Version Compatibility
Quick Start & Installation
Client Configuration & Desktop Setup
Tool Categories Overview (152 Tools)
Testing & Quality Assurance
Project Roadmap & Upcoming Features
License

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:

Metabase Version Range	Compatibility Level	Key Features Supported
Metabase v0.55 – v0.61+ (Current)	Full Support	Modern MBQL 5 format (`stages`, `lib/type`), `/api/upload/csv`, updated collection permissions, multi-tab dashboards
Metabase v0.50 – v0.54	Full Support	Collection tree hierarchies (`/api/collection/tree`), Model cards, API Key auth (`x-api-key`), sequential parametric queries
Metabase v0.43 – v0.49	Full Support	Session token authentication (`X-Metabase-Session`), legacy MBQL query pipelines, database introspection
Metabase Open Source & Enterprise	Full Support	Automatic feature detection (whitelabeling, audit logs, granular data permissions)

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):

Detailed setup guide: docs/integrations/GOOGLE_GEMINI_GUIDE.md

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.

Developed and maintained by Abdullah Enes SARI (ONMARTECH LLC).

Add this server

Host a copy with our keys and logs.

Server facts

Tools

Questions

How do I install Metabase Ai Assistant?

Does Metabase Ai Assistant need an API key?

What transport does Metabase Ai Assistant use?

When was Metabase Ai Assistant last checked?

Documentation

Metabase AI Assistant — Model Context Protocol (MCP) Server

🌍 Language Versions / Dil Seçenekleri / 语言版本 / النسخ اللغوية

Table of Contents

Core Architectural Highlights

Next-Gen Autonomous Features (v5.1)

1. dbt Architectural Hierarchy & Source Prioritization

2. Governance-First Semantic Memory (No Silent Learning, No Hard-Deletes)

3. Autonomous Self-Healing SQL Engine (ai_sql_execute_and_heal)

Metabase Version Compatibility

Quick Start & Installation

Global Execution via NPX

Manual Installation via NPM

Client Configuration & Desktop Setup

1. Claude Desktop

Option A: One-Click Extension (DXT / MCPB)

Option B: Manual JSON Configuration

2. Cursor IDE, Windsurf & VS Code

3. ChatGPT Custom GPTs & Actions

4. Google Gemini & Google AI Studio

5. Cloudflare Workers (Serverless Edge)

Tool Categories Overview (143 Tools)

Testing & Quality Assurance

License

3. Autonomous Self-Healing SQL Engine (`ai_sql_execute_and_heal`)