Metabase MCP Server - Connect AI Assistants to Your Metabase Analytics

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)

# Run directly without installing (like npx for Python)
uvx metabase-mcp

# With environment variables
METABASE_URL=https://your-instance.com METABASE_API_KEY=your-key uvx metabase-mcp

Option 2: Install from PyPI

# Install globally
uv tool install metabase-mcp

# Or with pip
pip install metabase-mcp

# Then run
metabase-mcp

Option 3: Development Setup (From Source)

# Clone the repository
git clone https://github.com/cheukyin175/metabase-mcp.git
cd metabase-mcp

# Install dependencies
uv sync

# Run the server
uv run python server.py

Configuration

Create a .env file with your Metabase credentials:

cp .env.example .env

Configuration Options

Option 1: API Key Authentication (Recommended)

METABASE_URL=https://your-metabase-instance.com
METABASE_API_KEY=your-api-key-here