Mmcp.market

Metabase AI Assistant MCP server

by enessari·io.github.enessari/metabase-ai-assistant·v3.2.0·49 stars

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

B83/100grade B
What users say
No reviews yet
Be the first
Safety scan
B83/100

full report

Adoption
Growing

49 stars59 downloads/wk

Reviews

Write one

Nobody has reviewed Metabase AI Assistant yet.

If you have run it, two minutes of your experience saves the next person an afternoon.

Metabase AI Assistant tools (100, 34 write)

write = sends, deletes, buys or posts

Read from the package source without running it. The installed server may list more.

  • activity_cleanup

    Clean up old activity logs to maintain performance and storage efficiency

  • activity_database_usage

    Get database usage patterns and statistics showing which databases are most active

  • activity_error_analysis

    Analyze error patterns and common failure points to identify improvement opportunities

  • activity_log_init

    Initialize activity logging system for a database - creates log table and starts tracking operations

  • activity_operation_stats

    Analyze operation statistics and patterns over specified time period

  • activity_performance_insights

    Get performance insights showing slow operations and optimization opportunities

  • activity_session_summary

    Get comprehensive summary of current or specified session activities and performance

  • activity_timeline

    Get chronological timeline of recent activities for debugging and monitoring

  • ai_relationships_suggest

    AI-powered virtual relationship discovery using naming patterns and data analysis - finds implicit connections between tables

  • ai_sql_explain

    Break down complex SQL queries into plain English - explains joins, aggregations, and business logic

  • ai_sql_generate

    Convert natural language requests into SQL queries - understands business context and table relationships

  • ai_sql_optimize

    Analyze and improve SQL query performance - suggests indexes, query restructuring, and execution optimizations

  • db_ai_dropwrite action

    Safely remove AI-created database objects - only works on objects with claude_ai_ prefix for security

  • db_ai_list

    List all database objects created by AI (with claude_ai_ prefix)

  • db_connection_info

    Get database connection information from Metabase (requires admin permissions)

  • db_index_createwrite action

    Create database index for query performance - improves search and join operations on specified columns

  • db_index_usage

    Analyze index usage statistics - find unused or rarely used indexes

  • db_list

    Get list of all databases in Metabase instance with IDs and connection types

  • db_matview_createwrite action

    Create a new materialized view directly in the database (PostgreSQL only)

  • db_query_explain

    Get execution plan for a SQL query - shows how PostgreSQL will execute the query

  • db_relationships_detect

    Detect existing foreign key relationships between tables - finds explicitly defined database constraints

  • db_schema_analyze

    Deep schema analysis with column details, keys, constraints - requires direct DB connection for comprehensive insights

  • db_schema_explore

    Fast schema exploration with table counts and basic info - lightweight method for discovering data structure

  • db_schemas

    Get all schema names in specified database - useful for data exploration and finding business data locations

  • db_table_createwrite action

    Create new table directly in database with security controls - requires schema selection and approval

  • db_table_ddl

    Get the DDL (CREATE statement) for a table

  • db_table_stats

    Get table statistics including row count, size, dead tuples, last vacuum/analyze times

  • db_tables

    Get comprehensive table list across all schemas with field counts - provides overview of data structure

  • db_test_speed

    Check database response time and performance - run this before heavy operations to determine optimal timeout settings

  • db_vacuum_analyzewrite action

    Run VACUUM and ANALYZE on PostgreSQL tables to optimize storage and update statistics (PostgreSQL only)

  • db_view_createwrite action

    Create a new view directly in the database (with claude_ai_ prefix)

  • db_view_ddl

    Get the DDL (CREATE statement) for a view

  • definition_get_metric

    Get metric definition with calculation formula and business context

  • definition_get_template

    Get dashboard or question template with layout and configuration

  • definition_global_search

    Search across all definition tables with unified results

  • definition_search_terms

    Search business terms and definitions with relevance ranking

  • definition_tables_init

    Initialize definition lookup tables system for documentation, metrics, templates, and search

  • mb_action_createwrite action

    Create a Metabase Action for data modification (INSERT, UPDATE, DELETE)

  • mb_action_executewrite action

    Execute a Metabase action with parameters

  • mb_action_list

    List all actions for a model

  • mb_alert_createwrite action

    Create an alert for a question that triggers on specified conditions

  • mb_alert_list

    List all alerts, optionally filtered by question

  • mb_auto_describe

    Automatically generate AI-powered descriptions for databases, tables, and fields with timestamp signatures

  • mb_card_archive

    Archive a card/question (soft delete)

  • mb_card_clone

    Clone a card and retarget to a different table (for template cards)

  • mb_card_copy

    Copy a card/question to a new location

  • mb_card_datawrite action

    Execute a card/question and get the results in specified format

  • mb_card_deletewrite action

    Permanently delete a card/question

  • mb_card_get

    Get detailed information about a specific card/question

  • mb_card_updatewrite action

    Update an existing card/question

  • mb_collection_copy

    Copy an entire collection with all contents

  • mb_collection_createwrite action

    Create a new collection in Metabase for organizing questions and dashboards

  • mb_collection_list

    List all collections with hierarchy and item counts

  • mb_collection_move

    Move questions, dashboards, or collections to a different collection

  • mb_collection_permissions_get

    Get permissions graph for a collection

  • mb_collection_permissions_updatewrite action

    Update permissions for a collection

  • mb_dashboard_add_card

    Add a question card to a dashboard with specific positioning, sizing, and layout

  • mb_dashboard_add_filter

    Add a filter to a dashboard for interactive data filtering across multiple cards

  • mb_dashboard_card_removewrite action

    Remove a card from a dashboard

  • mb_dashboard_card_updatewrite action

    Update card position and size on a dashboard

  • mb_dashboard_copy

    Copy a dashboard with all its cards

  • mb_dashboard_createwrite action

    Create a new dashboard in Metabase with layout options

  • mb_dashboard_deletewrite action

    Delete a dashboard

  • mb_dashboard_get

    Get detailed information about a dashboard

  • mb_dashboard_layout_optimize

    Automatically optimize dashboard layout for better visual hierarchy and user experience

  • mb_dashboard_template_executivewrite action

    Create an executive dashboard with standard KPIs, metrics, and layout - auto-generates questions and arranges them professionally

  • mb_dashboard_updatewrite action

    Update dashboard properties

  • mb_dashboards

    List existing dashboards

  • mb_embed_settings

    Get embedding settings and enabled features for the Metabase instance

  • mb_embed_url_generate

    Generate signed embedding URL for a dashboard or question

  • mb_field_metadata

    Get or update field metadata including display name, description, and semantic type

  • mb_field_values

    Get distinct values for a field (for filter dropdowns)

  • mb_metric_createwrite action

    Create a custom metric definition in Metabase for KPI tracking and business intelligence

  • mb_permission_group_add_user

    Add a user to a permission group

  • mb_permission_group_createwrite action

    Create a new permission group

  • mb_permission_group_deletewrite action

    Delete a permission group

  • mb_permission_group_list

    List all permission groups in Metabase

  • mb_permission_group_remove_userwrite action

    Remove a user from a permission group

  • mb_pulse_createwrite action

    Create a scheduled report (pulse) that sends dashboards/questions on a schedule

  • mb_question_createwrite action

    Create new question/chart

  • mb_question_create_parametricwrite action

    Create a parametric question with filters, variables, and dynamic queries - supports date ranges, dropdowns, and field filters

  • mb_questions

    Browse saved questions and charts in Metabase - filter by collection to find specific reports

  • mb_relationships_createwrite action

    Create virtual relationships in Metabase model - enables cross-table queries and improved dashboard capabilities

  • mb_search

    Search across all Metabase items (cards, dashboards, collections, tables)

  • mb_table_metadata

    Get or update table metadata including display name, description, and visibility

  • mb_user_createwrite action

    Create a new Metabase user

  • mb_user_disable

    Disable (deactivate) a user account

  • mb_user_get

    Get detailed information about a specific user

  • mb_user_list

    List all Metabase users with filtering options

  • mb_user_updatewrite action

    Update an existing user

  • mb_visualization_recommend

    AI-powered visualization recommendation based on query results and data types

  • mb_visualization_settings

    Get or update visualization settings for a question (chart type, colors, labels, etc.)

  • parametric_dashboard_createwrite action

    Create dashboard with parametric questions and shared filters

  • parametric_question_createwrite action

    Create parametric question with date, text search, and category filters

  • parametric_template_presetwrite action

    Create parametric question from preset templates (date range analysis, category filter, text search, period comparison)

  • sql_executewrite action

    Run SQL queries against database - supports SELECT, DDL with security controls, returns formatted results

  • web_explore_metabase_docs

    Comprehensively explore Metabase documentation - crawls main docs and discovers all available sections, APIs, and guides

  • web_fetch_metabase_docs

    Fetch specific Metabase documentation page for API details, best practices, and feature information

  • web_metabase_api_reference

    Get comprehensive Metabase API reference with endpoints, parameters, examples, and response formats

  • web_search_metabase_docs

    Search across all Metabase documentation for specific topics, APIs, or solutions - uses intelligent content analysis

Public scan report

scanner v0.1.10 · 2026-10-01 · same rubric, same numbers if you re-run it

no findings
  • Code scan14 source files scanned25/25
  • –Live reliabilityno gateway calls yet and no remote to proben/a
  • –Tool poisoningtools not inspected (local package is not executed); not countedn/a
  • Auth qualitystatic API keys via environment variables6/15
  • Maintenancelast push 28 days ago15/15
  • Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10
Overall 83/100. Components that don't apply are left out of the denominator. Any critical finding is an F.RubricAppeal a findingJSON

Install Metabase AI Assistant in Claude Code, Cursor or VS Code

Runs npx -y metabase-ai-assistant on your machine. Read the scan report first; the gateway never runs local packages.

claude mcp add metabase-ai-assistant -- npx -y metabase-ai-assistant
Add to Cursor

What the publisher says

From the Metabase AI Assistant repository's README, as published. We do not edit it. Read it on GitHub

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)
  • 🇹🇷 Türkçe Dokümantasyon
  • 🇨🇳 中文文档 (Chinese)
  • 🇸🇦 التوثيق باللغة العربية (Arabic)

Table of Contents

  • 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

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:

Shortened. The full README is on GitHub.

Nothing above is checked by us. What we check is on the safety report.

Metabase AI Assistant: common questions

Is Metabase AI Assistant MCP server safe?
Mostly: it is graded B (83/100). Read the Metabase AI Assistant safety report
How do I install Metabase AI Assistant?
It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.
Does Metabase AI Assistant need an API key?
Yes. The registry entry asks for METABASE_PASSWORD, METABASE_API_KEY, DATABASE_PASSWORD.
Is Metabase AI Assistant maintained?
The last commit was 40 days ago (2026-09-03). The latest release is v3.2.0.
What can I use instead of Metabase AI Assistant?
Servers from other publishers that do the same job: DBHub MCP server, Greptimedb MCP server and NeoSQL MCP server. Compare all Metabase AI Assistant alternatives.

Alternatives to Metabase AI Assistant

Same job from other publishers: the closest match first, then the best rated.

All Metabase AI Assistant alternatives →
  • DBHub
    Token-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite
    A
  • Greptimedb
    Query GreptimeDB metrics, logs and traces with SQL, TQL and RANGE. Manage pipelines and dashboards.
    A
  • NeoSQL MCP
    Schemas, SQL, ERDs, and codegen for PostgreSQL, MySQL, Oracle, SQLite, and more via NeoSQL Desktop.
    A
  • PostgreSQL (hardened, read-only)
    Read-only PostgreSQL over MCP. Writes refused at the parsed SQL, plus a READ ONLY transaction.
    C
  • MCP Superset
    Apache Superset MCP server — 135+ tools for dashboards, charts, datasets, SQL Lab, and security
    B

More from enessari →