metabase-server MCP Server

A Model Context Protocol server for Metabase integration.

This is a TypeScript-based MCP server that implements integration with Metabase API. It allows AI assistants to interact with Metabase, providing access to:

Dashboards, questions/cards, and databases as resources
Tools for listing and executing Metabase queries
Ability to view and interact with Metabase data

Features

Resources

List and access Metabase resources via metabase:// URIs
Access dashboards, cards/questions, and databases
JSON content type for structured data access

Tools

list_dashboards - List all dashboards in Metabase
list_cards - List all questions/cards in Metabase
list_databases - List all databases in Metabase
execute_card - Execute a Metabase question/card and get results
get_dashboard_cards - Get all cards in a dashboard
execute_query - Execute a SQL query against a Metabase database

Related MCP server: Metabase Server MCP

Configuration

Before running the server, you need to set the following environment variables:

# Required environment variables export METABASE_URL=https://your-metabase-instance.com export METABASE_USERNAME=your_username export METABASE_PASSWORD=your_password

You can set these environment variables in your shell profile or use a .env file with a package like dotenv.

Development

Install dependencies:

npm install

Build the server:

npm run build

For development with auto-rebuild:

npm run watch

Installation

To use with Claude Desktop, add the server config:

On MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json On Windows: %APPDATA%/Claude/claude_desktop_config.json

{ "mcpServers": { "metabase-server": { "command": "/path/to/metabase-server/build/index.js", "env": { "METABASE_URL": "https://your-metabase-instance.com", "METABASE_USERNAME": "your_username", "METABASE_PASSWORD": "your_password" } } } }

Note: You can also set these environment variables in your system instead of in the config file if you prefer.