Metabase MCP
π π - MCP server connecting Claude to Metabase with 28 tools for natural language data anal
What is Metabase MCP?
Metabase MCP is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to π π - mcp server connecting claude to metabase with 28 tools for natural language data anal
π π - MCP server connecting Claude to Metabase with 28 tools for natural language data anal
This server falls under the Analytics and Data Science & ML categories on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- MCP protocol support
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx metabase-mcpConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Metabase MCP
The Metabase MCP Server connects AI assistants to a Metabase instance, enabling natural language data analysis without requiring SQL knowledge. It exposes six tools covering dashboards, saved questions, database sources, and direct SQL query execution, allowing users to explore business data, run ad-hoc queries, and extract insights through conversational prompts. Data analysts and business users connect it to Claude to query their Metabase data warehouse or BI dashboards using plain English.
Prerequisites
- Node.js 18.0.0 or higher installed
- A running Metabase instance (self-hosted or Metabase Cloud) with API access
- Either a Metabase API key (recommended) or a Metabase user email and password
- METABASE_URL: the base URL of your Metabase instance (e.g. https://metabase.yourcompany.com)
- An MCP-compatible client such as Claude Desktop or Cursor
Clone and build the server
Clone the repository, install dependencies, and build the project.
git clone https://github.com/hyeongjun-dev/metabase-mcp-server.git
cd metabase-mcp-server
npm install
npm run buildObtain Metabase credentials
In your Metabase admin settings, generate an API key (Settings > Admin > API Keys) β this is the recommended authentication method. Alternatively use your Metabase user email and password.
Configure environment variables
Set the required environment variables. Use the API key method for production environments as it does not require storing a password.
# API key method (recommended)
export METABASE_URL="https://metabase.yourcompany.com"
export METABASE_API_KEY="your_metabase_api_key"
# Username/password method (alternative)
export METABASE_URL="https://metabase.yourcompany.com"
export METABASE_USER_EMAIL="[email protected]"
export METABASE_PASSWORD="your_password"Configure your MCP client
Add the Metabase MCP server to your Claude Desktop configuration, passing credentials as environment variables.
{
"mcpServers": {
"metabase": {
"command": "node",
"args": ["/path/to/metabase-mcp-server/dist/index.js"],
"env": {
"METABASE_URL": "https://metabase.yourcompany.com",
"METABASE_API_KEY": "your_api_key"
}
}
}
}Verify available tools
Restart your MCP client and ask the AI to list your Metabase dashboards or databases to confirm the connection is working.
Metabase MCP Examples
Client configuration
Claude Desktop configuration using the API key authentication method.
{
"mcpServers": {
"metabase": {
"command": "node",
"args": ["/Users/you/metabase-mcp-server/dist/index.js"],
"env": {
"METABASE_URL": "https://metabase.yourcompany.com",
"METABASE_API_KEY": "your_metabase_api_key_here",
"LOG_LEVEL": "info"
}
}
}
}Prompts to try
Example prompts demonstrating natural language data analysis via the six Metabase MCP tools.
- "List all available dashboards in my Metabase"
- "Show me the databases connected to Metabase"
- "Run the saved question called 'Monthly Revenue by Region'"
- "Execute a SQL query to find the top 10 customers by total spend this quarter"
- "Get all the cards from the Sales Overview dashboard"
- "List all saved questions and tell me which ones relate to customer churn"Troubleshooting Metabase MCP
Authentication fails with 401 Unauthorized errors
Verify METABASE_URL does not have a trailing slash and that your API key or email/password combination is correct. API keys must be generated by an admin in the Metabase admin panel under Settings > API Keys.
execute_query returns permission errors
The Metabase user or API key must have access to the specific database you are querying. Check database permissions in Metabase admin under Permissions > Data.
Server fails to start after npm run build
Ensure Node.js 18.0.0 or higher is installed (node --version). If the build fails, delete node_modules and run npm install again before rebuilding.
Frequently Asked Questions about Metabase MCP
What is Metabase MCP?
Metabase MCP is a Model Context Protocol (MCP) server that π π - mcp server connecting claude to metabase with 28 tools for natural language data anal It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Metabase MCP?
Follow the installation instructions on the Metabase MCP GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Metabase MCP?
Metabase MCP works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Metabase MCP free to use?
Yes, Metabase MCP is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.
Metabase MCP Alternatives β Similar Analytics Servers
Looking for alternatives to Metabase MCP? Here are other popular analytics servers you can use with Claude, Cursor, and VS Code.
OpenMetadata
β 14.0kOpenMetadata is a unified metadata platform for data discovery, data observability, and data governance powered by a central metadata repository, in-depth column level lineage, and seamless team collaboration.
Superset
β 10.9kAn MCP server that provides AI assistants with full access to Apache Superset instances, enabling interaction with dashboards, charts, datasets, databases, and SQL execution capabilities.
Horizon
β 4.4kπ‘ Your own AI-powered news radar. Generates daily briefings in English & Chinese. | η¨ AI ζε»Ίδ½ δΈε±ηζ°ι»ι·θΎΎ
MCP Server Chart
β 4.1kEnables generation of 25+ types of charts and data visualizations using AntV, including bar charts, line charts, maps, mind maps, and specialized diagrams like fishbone and sankey charts. Supports both statistical charts and geographic visualizations
Muapi CLI
β 997Official CLI for muapi.ai β generate images, videos & audio from the terminal. MCP server, 14 AI models, npm + pip installable.
Weather MCP Server
β 907Weather Data Fetcher MCP server built with Node.js, MCP SDK, and Zod. Provides weather details like temperature and forecast for cities such as Noida and Delhi via a registered tool. Simplifies API integration, enabling structured responses for clien
Browse More Analytics MCP Servers
Explore all analytics servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Metabase MCP in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Metabase MCP?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.