Metabase Server

Metabase Server is an MCP server that connects AI assistants to Metabase instances via the Metabase API. Developed in TypeScript, it exposes business intelligence assets—such as saved questions, dashboards, and connected database schemas—directly to Model Context Protocol clients. Data analysts, developers, and operations teams use this server to inspect metrics and execute analytical workflows through natural language interfaces. The integration offers structured access to Metabase resources using custom URI schemes and provides dedicated tools to inspect existing cards, list dashboards, extract specific dashboard cards, and execute SQL queries directly against Metabase-connected databases. Authentication is managed through environment variables supporting either Metabase API keys or username and password credentials. By bridging AI interfaces with business intelligence systems, Metabase Server enables real-time reporting retrieval, ad-hoc querying, and programmatic data exploration without requiring users to switch away from their primary MCP-compatible desktop clients or developer environments.

Category: Data & Analytics

Tags: bi, business-intelligence, metabase, SQL, visualization

Visit Metabase Server

How to install and configure Metabase Server

1. Build and install the server locally using npm: bash git clone https://github.com/imlewc/metabase-server.git && cd metabase-server && npm i && npm run build && npm link Alternatively, install via Smithery: bash npx -y @smithery/cli install @imlewc/metabase-server --client claude 2. Open your Claude Desktop configuration file (claude_desktop_config.json). 3. Add metabase-server to the mcpServers object: json { "mcpServers": { "metabase-server": { "command": "metabase-server", "env": { "METABASE_URL": "https://your-metabase-instance.com", "METABASE_API_KEY": "your_metabase_api_key" } } } } If an API key is not available, provide METABASE_USERNAME and METABASE_PASSWORD instead of METABASE_API_KEY. 4. Save the configuration and restart Claude Desktop.

What you can do with Metabase Server

• Running raw SQL queries directly against configured Metabase data sources to extract ad-hoc business reporting metrics. - Listing and inspecting questions or cards across an organization's workspace to locate existing data visualizations. - Extracting every card and question linked to a specific Metabase dashboard to review consolidated business KPI summaries. - Discovering accessible databases mapped within Metabase to examine schema structures and available data connections.

Key facts

• https://github.com/imlewc/metabase-server
• Data & Analytics, Databases & Data Stores
• bi, business-intelligence, metabase, SQL, visualization

Part of MCP Servers

How do I install Metabase Server?

You can install Metabase Server by cloning its repository from GitHub, running npm install, building the project, and linking it globally with npm link. Alternatively, install it using the Smithery CLI or configure it to run using npx within your client configuration file.

What can Metabase Server do?

Metabase Server exposes tools to list dashboards, questions or cards, and databases stored in your Metabase workspace. It allows you to execute individual saved questions, retrieve all cards on a target dashboard, and execute custom SQL queries against connected databases.

Which MCP clients work with Metabase Server?

Metabase Server runs over standard input/output (stdio) and works with any compatible MCP client. Documented clients include Claude Desktop and Claude Code CLI, as well as debugging environments like the Model Context Protocol Inspector.

What authentication methods does Metabase Server support?

The server supports two authentication mechanisms using environment variables. The preferred method is using METABASE_URL and METABASE_API_KEY. Alternatively, it can fall back to using METABASE_URL along with METABASE_USERNAME and METABASE_PASSWORD if no API key is specified.