Metabase AI Assistant

Name: Metabase AI Assistant
Author: enessari

by enessariversion 3.2.0i★ –iRuns on your computer

Registry nameio.github.enessari/metabase-ai-assistant

Install

Overview

Description from the maker (original English)

MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL

PopNx MCP’s three pillars

These three are never merged into one score: opinions, measurements and popularity are different things.

User voiceiNo reviews yetReviews open together with accounts in a later step
Our basic checksi1 of 1 passedChecked from public information; code not scanned yet
UsageiVery new↓ 60/wk · ★ –

What you can do with it

We have not written a plain-language summary for this one yet. Below are the facts we read from the registry.

Connection: Runs on your computer
Transport: stdio
Category: Databases & datasets
You need to fill in: METABASE_URL, METABASE_PASSWORD, METABASE_API_KEY, DATABASE_PASSWORD

Install

Pick the AI app you use, then copy the settings.

Before you install

Basic checks: 1 of 1 passed
Runs on your computer with your user’s permissions (files, network, apps).
You fill in yourself: METABASE_URL, METABASE_USERNAME, METABASE_PASSWORD, METABASE_API_KEY, DATABASE_HOST, DATABASE_PORT, DATABASE_NAME, DATABASE_USER, DATABASE_PASSWORD

Values marked secret are keys to your account. Never share them or paste them into a chat.

You need

npmNode.js installed (for the npx command)

Which app do you use?

ClaudeClaude CodeCursorVS CodeChatGPT

Pick your app above. We remember it, so next time the button says “Install in …”.

Open Claude Desktop → Settings → Developer → Edit Config, and paste this into claude_desktop_config.json

{
  "mcpServers": {
    "metabase-ai-assistant": {
      "command": "npx",
      "args": [
        "-y",
        "metabase-ai-assistant"
      ],
      "env": {
        "METABASE_URL": "your-value",
        "METABASE_USERNAME": "your-value",
        "METABASE_PASSWORD": "your-value",
        "METABASE_API_KEY": "your-value",
        "DATABASE_HOST": "your-value",
        "DATABASE_PORT": "your-value",
        "DATABASE_NAME": "your-value",
        "DATABASE_USER": "your-value",
        "DATABASE_PASSWORD": "your-value"
      }
    }
  }
}

Run this in your terminal

claude mcp add metabase-ai-assistant --env METABASE_URL=your-value --env METABASE_USERNAME=your-value --env METABASE_PASSWORD=your-value --env METABASE_API_KEY=your-value --env DATABASE_HOST=your-value --env DATABASE_PORT=your-value --env DATABASE_NAME=your-value --env DATABASE_USER=your-value --env DATABASE_PASSWORD=your-value -- npx -y metabase-ai-assistant

Fill in the empty values before running it.

Open in Cursor

Or copy the settings yourself

Paste into .cursor/mcp.json in your project, or ~/.cursor/mcp.json

{
  "mcpServers": {
    "metabase-ai-assistant": {
      "command": "npx",
      "args": [
        "-y",
        "metabase-ai-assistant"
      ],
      "env": {
        "METABASE_URL": "your-value",
        "METABASE_USERNAME": "your-value",
        "METABASE_PASSWORD": "your-value",
        "METABASE_API_KEY": "your-value",
        "DATABASE_HOST": "your-value",
        "DATABASE_PORT": "your-value",
        "DATABASE_NAME": "your-value",
        "DATABASE_USER": "your-value",
        "DATABASE_PASSWORD": "your-value"
      }
    }
  }
}

Your browser asks to open the app, then the app shows the settings and asks you to confirm. Key values are left empty for you to fill in.

Open in VS Code

Or copy the settings yourself

Paste into .vscode/mcp.json in your project

{
  "servers": {
    "metabase-ai-assistant": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "metabase-ai-assistant"
      ],
      "env": {
        "METABASE_URL": "your-value",
        "METABASE_USERNAME": "your-value",
        "METABASE_PASSWORD": "your-value",
        "METABASE_API_KEY": "your-value",
        "DATABASE_HOST": "your-value",
        "DATABASE_PORT": "your-value",
        "DATABASE_NAME": "your-value",
        "DATABASE_USER": "your-value",
        "DATABASE_PASSWORD": "your-value"
      }
    }
  }
}

Your browser asks to open the app, then the app shows the settings and asks you to confirm. Key values are left empty for you to fill in.

This one runs on your computer, and ChatGPT can only connect to servers on the internet. Pick another app.

Your choice stays on this device in a cookie; no account needed.

Values you fill in

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

These settings are generated from the maker’s registry entry. If the README says otherwise, follow the README.

What it can do

Runs on your computer; the tool list appears in your AI app after you install it.

Basic checksi

We check information anyone can see; we have not read the code. Checks that do not apply are left out of the count. · Checked Nov 8, 2026

✓ Pass
Maker matches the repo
The registry name was verified with the GitHub account enessari, which owns the repo
… Not checked yet
Still maintained
We have not read this repo from GitHub yet
… Not checked yet
Has a licence
We have not read this repo from GitHub yet
– Not applicable
Endpoint responds
This one runs on your computer; there is no internet endpoint
– Not applicable
Sign-in with OAuth
Runs on your computer and uses local settings instead
… Not checked yet
No hidden instructions in tool descriptions
Runs on your computer; we can only read tool lists from internet endpoints

Compared with others in Databases & datasetsi

More stars than 0% of the other 1144 servers in this category
Published to the registry more recently than 3% of the other 1144 servers in this category
Basic checks equal to or better than 100% of the other 1144 servers in this category

Compared with every active server in this category in the registry. Stars count only when the publisher owns the repo.

Common questions

Is Metabase AI Assistant safe?

It passed 1 of 1 applicable basic checks. We have not read the code. Before adding a key or token, see what access the server asks for and use a key with only the permissions you need.

What keys or codes does it need?

You need to fill in: METABASE_URL, METABASE_PASSWORD, METABASE_API_KEY, DATABASE_PASSWORD

Does it run on my computer or in the cloud?

It runs on your computer. Your AI app starts it when needed, and data does not pass through the maker’s servers (unless it calls an online service itself).

Is it still maintained?

The GitHub repo last changed –, and the latest version (3.2.0) reached the registry 10 months ago.

Which apps can use it?

Apps that support MCP, such as Claude Desktop, Claude Code, Cursor and VS Code. You also need Node.js on your computer.

What can I use instead?

In the same category: Supabase, MongoDB MCP Server, Elasticsearch MCP Server

Alternatives

Servers in the same category from other makers, sorted by stars.

Reading a card:↓ Downloads per weeki★ GitHub starsiThree pillars: reviews · checks · usageiUpdated = latest version published to the registryi

Supabase

Supabase’s official server lets AI create tables, query data and review project settings in your Supabase database.

by supabaseWidely used↓ 235.4K/wk★ 3KUpdated 2 days ago

Computer or cloud✓ supabase.com

Install

MongoDB MCP Server

MongoDB Model Context Protocol Server

by mongodb-jsWidely used↓ 157.1K/wk★ 1.2KUpdated 3 days ago

Runs on your computer

Install

Elasticsearch MCP Server

MCP server for interacting with Elasticsearch

by cr7258Growing↓ 2.7K/wk★ 315Updated 14 months ago

Runs on your computer

Install

README from the maker

Open the README

Copied from the maker’s repo as written. PopNx MCP has not reviewed or endorsed it. HTML, images and scripts are removed. Links lead off this site.

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

🇬🇧 [English (Main Documentation)](README.md)
🇹🇷 [Türkçe Dokümantasyon](README_TR.md)
🇨🇳 [中文文档 (Chinese)](README_ZH.md)
🇸🇦 [التوثيق باللغة العربية (Arabic)](README_AR.md)

Core Architectural Highlights
Next-Gen Autonomous Features (v5.3)
Metabase Version Compatibility
Quick Start & Installation
Client Configuration & Desktop Setup
Claude Desktop (One-Click DXT & JSON)
Cursor IDE, Windsurf & VS Code
ChatGPT Custom GPTs & Actions
Google Gemini & AI Studio
Google Antigravity SDK & MCP
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:

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

Metabase AI Assistant

Overview

PopNx MCP’s three pillars

What you can do with it

Install

Before you install

Values you fill in

What it can do

Basic checksi

Maker matches the repo

Still maintained

Has a licence

Endpoint responds

Sign-in with OAuth

No hidden instructions in tool descriptions

Compared with others in Databases & datasetsi

Common questions

Alternatives

Supabase

MongoDB MCP Server

Elasticsearch MCP Server

README from the maker

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

Run unit tests

Run integration workflows

Run security & PII zero-leak fuzzing tests

License

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