Metabase MCP Server

by cheukyin175

67 stars
457 downloads
Not rated
GitHub

About

Metabase MCP server provides integration with the Metabase API, enabling LLM with MCP capabilites to directly interact with your analytics data, this server acts as a bridge between your analytics platform and conversational AI.

Details

Author
cheukyin175
GitHub stars
67
Downloads
457
Categories
Search

- List databases, explore tables, and inspect fields with metadata
- Execute native SQL queries with parameter support and templating
- Execute MongoDB queries with automatic JSON conversion
- Run, create, and manage Metabase cards/questions
- Create and organize collections for better data organization
- Secure authentication via API keys or email/password

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

  1. Download and install Highlight from highlightai.com/download
  2. Navigate to the plugins tab and select "Add Custom Plugin"
  3. Configure the plugin with the settings below
    Plugin Name Metabase MCP Server
    Command (node, npx, python, etc.)

    Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.

  4. Enable "Start Automatically" if you want the plugin to start when Highlight launches

From the repository

Install via uvx metabase-mcp (no installation required) or pip install metabase-mcp. Configure a .env file with Metabase credentials (API key or email/password). Run the server with uvx metabase-mcp or from source using uv run python server.py. Additional transport options: --sse for SSE, --http for HTTP.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "metabase mcp server": {
            "metabase-mcp": {
                "command": "uvx",
                "args": [
                    "metabase-mcp"
                ]
            }
        }
    }
}

McpServers

{
    "metabase-mcp": {
        "command": "uvx",
        "args": [
            "metabase-mcp"
        ]
    }
}

Metabase MCP Server - Connect AI Assistants to Your Metabase Analytics

PyPI version
Python 3.12+
License: MIT
FastMCP

A high-performance Model Context Protocol (MCP) server for Metabase, enabling AI assistants like Claude, Cursor, and other MCP clients to interact seamlessly with your Metabase instance. Query databases, execute SQL, manage dashboards, and automate analytics workflows with natural language through AI-powered database operations.

Perfect for: Data analysts, developers, and teams looking to integrate AI assistants with their Metabase business intelligence platform for automated SQL queries, dashboard management, and data exploration.

Key Features

Database Operations

- List Databases: Browse all configured Metabase databases - Table Discovery: Explore tables with metadata and descriptions - Field Inspection: Get detailed field/column information with smart pagination

Query & Analytics

- SQL Execution: Run native SQL queries with parameter support and templating - MongoDB Support: Execute native MongoDB queries with automatic JSON conversion for aggregation pipelines - Card Management: Execute, create, and manage Metabase questions/cards (SQL and MongoDB) - Collection Organization: Create and manage collections for better organization - Natural Language Queries: Let AI assistants translate questions into SQL or MongoDB queries

Authentication & Security

- API Key Support: Secure authentication via Metabase API keys (recommended) - Session-based Auth: Alternative email/password authentication - Environment Variables: Secure credential management via .env files

AI Assistant Integration

- Claude Desktop: Native integration with Anthropic's Claude AI - Cursor IDE: Seamless integration for AI-assisted development - Any MCP Client: Compatible with all Model Context Protocol clients

Enhanced Performance & Reliability

- Context-aware Logging: Real-time logging with debug, info, warning, and error levels visible to AI clients - Proper Error Handling: FastMCP ToolError exceptions for better error messages and debugging - Middleware Stack: Built-in error handling and logging middleware for production reliability - Best Practices: Follows latest FastMCP patterns with duplicate prevention and clean configuration - Modern Python: Uses Python 3.12+ type hints (| syntax) for better type safety

Quick Start

Prerequisites

- Python 3.12+ - Metabase instance with API access - uvx or uv package manager

Installation

Option 1: Using uvx (Easiest - No Installation Required)

```bash
No reviews yet — be the first

Sign in to leave a review

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.