Metabase AI Assistant MCP server
MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL
49 stars59 downloads/wk
Reviews
Write oneNobody 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 postsRead from the package source without running it. The installed server may list more.
activity_cleanupClean up old activity logs to maintain performance and storage efficiency
activity_database_usageGet database usage patterns and statistics showing which databases are most active
activity_error_analysisAnalyze error patterns and common failure points to identify improvement opportunities
activity_log_initInitialize activity logging system for a database - creates log table and starts tracking operations
activity_operation_statsAnalyze operation statistics and patterns over specified time period
activity_performance_insightsGet performance insights showing slow operations and optimization opportunities
activity_session_summaryGet comprehensive summary of current or specified session activities and performance
activity_timelineGet chronological timeline of recent activities for debugging and monitoring
ai_relationships_suggestAI-powered virtual relationship discovery using naming patterns and data analysis - finds implicit connections between tables
ai_sql_explainBreak down complex SQL queries into plain English - explains joins, aggregations, and business logic
ai_sql_generateConvert natural language requests into SQL queries - understands business context and table relationships
ai_sql_optimizeAnalyze and improve SQL query performance - suggests indexes, query restructuring, and execution optimizations
db_ai_dropwrite actionSafely remove AI-created database objects - only works on objects with claude_ai_ prefix for security
db_ai_listList all database objects created by AI (with claude_ai_ prefix)
db_connection_infoGet database connection information from Metabase (requires admin permissions)
db_index_createwrite actionCreate database index for query performance - improves search and join operations on specified columns
db_index_usageAnalyze index usage statistics - find unused or rarely used indexes
db_listGet list of all databases in Metabase instance with IDs and connection types
db_matview_createwrite actionCreate a new materialized view directly in the database (PostgreSQL only)
db_query_explainGet execution plan for a SQL query - shows how PostgreSQL will execute the query
db_relationships_detectDetect existing foreign key relationships between tables - finds explicitly defined database constraints
db_schema_analyzeDeep schema analysis with column details, keys, constraints - requires direct DB connection for comprehensive insights
db_schema_exploreFast schema exploration with table counts and basic info - lightweight method for discovering data structure
db_schemasGet all schema names in specified database - useful for data exploration and finding business data locations
db_table_createwrite actionCreate new table directly in database with security controls - requires schema selection and approval
db_table_ddlGet the DDL (CREATE statement) for a table
db_table_statsGet table statistics including row count, size, dead tuples, last vacuum/analyze times
db_tablesGet comprehensive table list across all schemas with field counts - provides overview of data structure
db_test_speedCheck database response time and performance - run this before heavy operations to determine optimal timeout settings
db_vacuum_analyzewrite actionRun VACUUM and ANALYZE on PostgreSQL tables to optimize storage and update statistics (PostgreSQL only)
db_view_createwrite actionCreate a new view directly in the database (with claude_ai_ prefix)
db_view_ddlGet the DDL (CREATE statement) for a view
definition_get_metricGet metric definition with calculation formula and business context
definition_get_templateGet dashboard or question template with layout and configuration
definition_global_searchSearch across all definition tables with unified results
definition_search_termsSearch business terms and definitions with relevance ranking
definition_tables_initInitialize definition lookup tables system for documentation, metrics, templates, and search
mb_action_createwrite actionCreate a Metabase Action for data modification (INSERT, UPDATE, DELETE)
mb_action_executewrite actionExecute a Metabase action with parameters
mb_action_listList all actions for a model
mb_alert_createwrite actionCreate an alert for a question that triggers on specified conditions
mb_alert_listList all alerts, optionally filtered by question
mb_auto_describeAutomatically generate AI-powered descriptions for databases, tables, and fields with timestamp signatures
mb_card_archiveArchive a card/question (soft delete)
mb_card_cloneClone a card and retarget to a different table (for template cards)
mb_card_copyCopy a card/question to a new location
mb_card_datawrite actionExecute a card/question and get the results in specified format
mb_card_deletewrite actionPermanently delete a card/question
mb_card_getGet detailed information about a specific card/question
mb_card_updatewrite actionUpdate an existing card/question
mb_collection_copyCopy an entire collection with all contents
mb_collection_createwrite actionCreate a new collection in Metabase for organizing questions and dashboards
mb_collection_listList all collections with hierarchy and item counts
mb_collection_moveMove questions, dashboards, or collections to a different collection
mb_collection_permissions_getGet permissions graph for a collection
mb_collection_permissions_updatewrite actionUpdate permissions for a collection
mb_dashboard_add_cardAdd a question card to a dashboard with specific positioning, sizing, and layout
mb_dashboard_add_filterAdd a filter to a dashboard for interactive data filtering across multiple cards
mb_dashboard_card_removewrite actionRemove a card from a dashboard
mb_dashboard_card_updatewrite actionUpdate card position and size on a dashboard
mb_dashboard_copyCopy a dashboard with all its cards
mb_dashboard_createwrite actionCreate a new dashboard in Metabase with layout options
mb_dashboard_deletewrite actionDelete a dashboard
mb_dashboard_getGet detailed information about a dashboard
mb_dashboard_layout_optimizeAutomatically optimize dashboard layout for better visual hierarchy and user experience
mb_dashboard_template_executivewrite actionCreate an executive dashboard with standard KPIs, metrics, and layout - auto-generates questions and arranges them professionally
mb_dashboard_updatewrite actionUpdate dashboard properties
mb_dashboardsList existing dashboards
mb_embed_settingsGet embedding settings and enabled features for the Metabase instance
mb_embed_url_generateGenerate signed embedding URL for a dashboard or question
mb_field_metadataGet or update field metadata including display name, description, and semantic type
mb_field_valuesGet distinct values for a field (for filter dropdowns)
mb_metric_createwrite actionCreate a custom metric definition in Metabase for KPI tracking and business intelligence
mb_permission_group_add_userAdd a user to a permission group
mb_permission_group_createwrite actionCreate a new permission group
mb_permission_group_deletewrite actionDelete a permission group
mb_permission_group_listList all permission groups in Metabase
mb_permission_group_remove_userwrite actionRemove a user from a permission group
mb_pulse_createwrite actionCreate a scheduled report (pulse) that sends dashboards/questions on a schedule
mb_question_createwrite actionCreate new question/chart
mb_question_create_parametricwrite actionCreate a parametric question with filters, variables, and dynamic queries - supports date ranges, dropdowns, and field filters
mb_questionsBrowse saved questions and charts in Metabase - filter by collection to find specific reports
mb_relationships_createwrite actionCreate virtual relationships in Metabase model - enables cross-table queries and improved dashboard capabilities
mb_searchSearch across all Metabase items (cards, dashboards, collections, tables)
mb_table_metadataGet or update table metadata including display name, description, and visibility
mb_user_createwrite actionCreate a new Metabase user
mb_user_disableDisable (deactivate) a user account
mb_user_getGet detailed information about a specific user
mb_user_listList all Metabase users with filtering options
mb_user_updatewrite actionUpdate an existing user
mb_visualization_recommendAI-powered visualization recommendation based on query results and data types
mb_visualization_settingsGet or update visualization settings for a question (chart type, colors, labels, etc.)
parametric_dashboard_createwrite actionCreate dashboard with parametric questions and shared filters
parametric_question_createwrite actionCreate parametric question with date, text search, and category filters
parametric_template_presetwrite actionCreate parametric question from preset templates (date range analysis, category filter, text search, period comparison)
sql_executewrite actionRun SQL queries against database - supports SELECT, DDL with security controls, returns formatted results
web_explore_metabase_docsComprehensively explore Metabase documentation - crawls main docs and discovers all available sections, APIs, and guides
web_fetch_metabase_docsFetch specific Metabase documentation page for API details, best practices, and feature information
web_metabase_api_referenceGet comprehensive Metabase API reference with endpoints, parameters, examples, and response formats
web_search_metabase_docsSearch 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
- 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
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
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.
- DBHubToken-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLitenot reviewedWidely usedA
- GreptimedbQuery GreptimeDB metrics, logs and traces with SQL, TQL and RANGE. Manage pipelines and dashboards.not reviewedGrowingA
NeoSQL MCPSchemas, SQL, ERDs, and codegen for PostgreSQL, MySQL, Oracle, SQLite, and more via NeoSQL Desktop.not reviewedGrowingA- PostgreSQL (hardened, read-only)Read-only PostgreSQL over MCP. Writes refused at the parsed SQL, plus a READ ONLY transaction.not reviewedGrowingC
- MCP SupersetApache Superset MCP server — 135+ tools for dashboards, charts, datasets, SQL Lab, and securitynot reviewedGrowingB