Metabase

🚀 metabase-server MCP Server

A Model Context Protocol server for Metabase integration.

This is a TypeScript-based MCP server that integrates with the Metabase API. It enables AI assistants to interact with Metabase, providing access to the following:

• Dashboards, questions/cards, and databases as resources
• Tools to list and execute Metabase queries
• The ability to view and interactively access Metabase data

🚀 Quick Start

The metabase-server is designed to integrate with Metabase, allowing AI assistants to interact with Metabase resources and execute queries.

✨ 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 cards/questions in Metabase
• list_databases - List all databases in Metabase
• execute_card - Execute a Metabase question/card and get the results
• get_dashboard_cards - Get all cards in a dashboard
• execute_query - Execute an SQL query against a Metabase database

📦 Installation

Prerequisites

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 configuration file or use a package.json file with the dotenv package.

Installation Steps

For Use with Claude Desktop

To use with Claude Desktop, add the server configuration:

• 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 variables via system environment variables instead of in the configuration file.

Using Smithery

To automatically install metabase-server via Smithery:

npx -y @smithery/cli install @imlewc/metabase-server --client claude

💻 Usage Examples

Development

Install dependencies

npm install

Build the server

npm run build

Development with auto-rebuild

npm run watch

Debugging

Since MCP servers communicate via standard input/output, debugging can be challenging. We recommend using MCP Inspector, which is provided as a package script:

npm run inspector

The Inspector will provide a URL to access the debugging tools in a browser.