# Metabase

Connects AI assistants directly to a Metabase instance to search catalog items, execute SQL queries, and build charts under user permissions.

- MCP server · `type=mcp` · Claude Code, Codex, Cursor, GitHub Copilot, Windsurf (Devin Desktop), Cline, Zed · ★ 49845
- Author: metabase
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/metabase/metabase/tree/HEAD/src/metabase/mcp
- Updated: 2026-10-24
- HTML: https://affpapa.org/en/nevibecode/mcp/metabase

## What it does

Metabase runs an internal MCP server over the Streamable HTTP transport at `/api/metabase-mcp`. It exposes the platform's Agent API so clients can browse collections, inspect metadata catalogs, run saved questions, and visualize query results.

Authentication relies on an embedded OAuth 2.0 server without external identity providers. Standard session cookies and API keys fail with HTTP 401 because MCP routes ignore them entirely. Access tokens enforce strict scopes: `agent:content:read` and `agent:query:run` form the default baseline, while running raw queries via `execute_sql` or editing dashboards requires explicit user approval.

On Enterprise installations with `ai_controls`, administrators can toggle individual MCP tool permissions for specific user groups inside the admin interface.

## Requirements
- Remote server: `https://{metabase_host}/api/mcp`

## Install

### Claude Code (native platform)

1. **Template address**
- The server address is a template: replace {…} or […] with your own values

2. **Platform CLI: remote server**
```bash
claude mcp add --transport http mcp https://{metabase_host}/api/mcp
```

### Codex

1. **Template address**
- The server address is a template: replace {…} or […] with your own values

2. **Platform CLI: remote server**
```bash
codex mcp add mcp --url https://{metabase_host}/api/mcp
```

### Cursor

1. **Template address**
- The server address is a template: replace {…} or […] with your own values

2. **Config file**
File `.cursor/mcp.json`:
```json
{
    "mcpServers": {
        "mcp": {
            "url": "https://{metabase_host}/api/mcp"
        }
    }
}
```

### GitHub Copilot

1. **Template address**
- The server address is a template: replace {…} or […] with your own values

2. **Config file**
File `.vscode/mcp.json`:
```json
{
    "servers": {
        "mcp": {
            "type": "http",
            "url": "https://{metabase_host}/api/mcp"
        }
    }
}
```

### Gemini CLI

1. **Template address**
- The server address is a template: replace {…} or […] with your own values

2. **Platform CLI: remote server**
```bash
gemini mcp add -t http mcp https://{metabase_host}/api/mcp
```

## When to use it
- run analytical SQL queries using execute_sql
- search collections and saved questions across Metabase
- render charts and visual data summaries with visualize_query
- create or modify dashboards via dashboard_write

## Example prompts
- Search Metabase for existing questions about monthly churn and run them.
- Run a SQL query against the orders database and render a visual chart.
- Check the schema using catalog://metabase/fields for the customer table.

## Similar
- [World Monitor](https://affpapa.org/en/nevibecode/mcp/world-monitor.md) — MCP server · ★ 89408
- [Scrapling MCP Server](https://affpapa.org/en/nevibecode/mcp/scrapling-mcp-server.md) — MCP server · ★ 89433
- [apify-mcp-server](https://affpapa.org/en/nevibecode/mcp/apify-mcp-server.md) — MCP server · ★ 12927
- [Nhost](https://affpapa.org/en/nevibecode/mcp/nhost.md) — MCP server · ★ 9366

From the same set: [metabase/metabase](https://affpapa.org/en/nevibecode/by/metabase/metabase.md) — 9 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md