Metabase MCP Server

Integrates AI assistants with the Metabase business intelligence and analytics platform.

A Model Context Protocol server that integrates AI assistants with Metabase analytics platform.

This 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.

- Resource Access: Navigate Metabase resources via intuitivemetabase://URIs
- Two Authentication Methods: Support for both session-based and API key authentication
- Structured Data Access: JSON-formatted responses for easy consumption by AI assistants
- Comprehensive Logging: Detailed logging for easy debugging and monitoring
- Error Handling: Robust error handling with clear error messages

The server exposes the following tools for AI assistants:

- list_dashboards: Retrieve all available dashboards in your Metabase instance
- list_cards: Get all saved questions/cards in Metabase
- list_databases: View all connected database sources
- list_collections: List all collections in Metabase
- list_tables: List all tables in a specific database
- get_table_fields: Get all fields/columns in a specific table

- execute_card: Run saved questions and retrieve results with optional parameters
- execute_query: Execute custom SQL queries against any connected database

- get_dashboard_cards: Extract all cards from a specific dashboard
- create_dashboard: Create a new dashboard with specified name and parameters
- update_dashboard: Update an existing dashboard's name, description, or parameters
- delete_dashboard: Delete a dashboard
- add_card_to_dashboard: Add or update cards in a dashboard with position specifications and optional tab assignment

- create_card: Create a new question/card with SQL query
- update_card_visualization: Update visualization settings for a card

- create_collection: Create a new collection to organize dashboards and questions

The server supports two authentication methods:

Option 1: Username and Password Authentication

# Required METABASE_URL=https://your-metabase-instance.com [email protected] METABASE_PASSWORD=your_password # Optional LOG_LEVEL=info # Options: debug, info, warn, error, fatal

Option 2: API Key Authentication (Recommended for Production)

# Required METABASE_URL=https://your-metabase-instance.com METABASE_API_KEY=your_api_key # Optional LOG_LEVEL=info # Options: debug, info, warn, error, fatal

You can set these environment variables directly or use a.envfile withdotenv.

To use this MCP server with Claude or other AI assistants, fork this repository and deploy using Smithery:
- Fork this repository to your GitHub account
- Go toSmitheryand connect with your GitHub account
- Deploy the forked repository through Smithery's interface

{ "mcpServers": { "metabase-mcp": { "command": "npx", "args": [ "-y", "@smithery/cli@latest", "run", "YOUR_GITHUB_USERNAME/metabase-mcp-server", "--config", "{\"metabaseUrl\":\"https://your-metabase-instance.com\",\"metabaseApiKey\":\"your_api_key\",\"metabasePassword\":\"\",\"metabaseUserEmail\":\"\"}" ] } } }

{ "mcpServers": { "metabase-mcp": { "command": "npx", "args": [ "-y", "@smithery/cli@latest", "run", "YOUR_GITHUB_USERNAME/metabase-mcp-server", "--config", "{\"metabaseUrl\":\"https://your-metabase-instance.com\",\"metabaseApiKey\":\"\",\"metabasePassword\":\"your_password\",\"metabaseUserEmail\":\"[email protected]\"}" ] } } }

- recommend using API key authentication for production environments
- Keep your API keys and credentials secure
- Consider using environment variables instead of hardcoding credentials
- Apply appropriate network security measures to restrict access to your Metabase instance

Contributions are welcome! Please feel free to submit a Pull Request.

Official Airtable MCP server and skills for working with bases, records, workflows, and business operations from AI agents.

MCP Server For Apache Doris, an MPP-based real-time data warehouse.

Official MCP Server from Atlan which enables you to bring the power of metadata to your AI tools

Query Onchain data, like ERC20 tokens, transaction history, smart contract state.

Read and write access to your Baserow tables.

Introspect and query your apps deployed to Convex.

Interact with the data stored in Couchbase clusters using natural language.

Maritime intelligence for tracking vessels, analysing ports, and exploring ship data.