📊 Metabase MCP Server

First, install Node.js if you haven't already:

- Download from: nodejs.org
- Or install via package manager:

Install uv which includes Python and package management:
Windows:

macOS/Linux:

Or install via package managers:

This command will automatically:

- Install the required Python version (if not already available)
- Create a virtual environment for the project
- Install all necessary packages and dependencies

uv sync

You have three options to configure your Metabase credentials for the MCP Server:

Option 1: Using a .env file (Recommended)
Create a .env file in the project root:

METABASE_URL=http://localhost:3000
METABASE_API_KEY=mb_xxx_your_key
PORT=3200
HOST=localhost
TRANSPORT=streamable-http
LOG_LEVEL=DEBUG

Option 2: Using command-line arguments
Pass configuration directly via command line:

 uv run src/metabase_mcp_server.py --metabase-url http://localhost:3000 --metabase-api-key "YOUR_API_KEY" --port 3200 --host localhost --transport streamable-http --log-level DEBUG

Option 3: Using environment variables in MCP client config
Configure directly in your MCP client without a .env file (see examples below).

{
  "mcpServers": {
    "metabase": {
      "type": "stdio",
      "command": "C:\\Users\\YourName\\Projects\\metabase-mcp-server\\.venv\\Scripts\\python.exe",
      "args": [
        "C:\\Users\\YourName\\Projects\\metabase-mcp-server\\src\\metabase_mcp_server.py"
      ],
      "env": {
        "METABASE_URL": "http://localhost:3000",
        "METABASE_API_KEY": "mb_xxx_your_key",
        "PORT": 3200,
        "HOST": "localhost",
        "TRANSPORT": "streamable-http",
        "LOG_LEVEL": "DEBUG"
      }
    }
  }
}

For stdio transport (recommended for local MCP server):

Windows:

{
  "mcpServers": {
    "metabase": {
      "type": "stdio",
      "command": "C:\\Users\\YourName\\Projects\\metabase-mcp-server\\.venv\\Scripts\\python.exe",
      "args": [
        "C:\\Users\\YourName\\Projects\\metabase-mcp-server\\src\\metabase_mcp_server.py"
      ]
    }
  }
}

Mac:

{
  "mcpServers": {
    "metabase": {
      "type": "stdio",
      "command": "/Users/YourName/Projects/metabase-mcp-server/venv/Scripts/python",
      "args": [
        "/Users/YourName/Projects/metabase-mcp-server/src/metabase_mcp_server.py"
      ]
    }
  }
}

The Metabase MCP Server supports flexible configuration through environment variables, command-line arguments, or a combination of both.

| Variable | Description | Default Value | Example |
| ------------------ | -------------------------- | ----------------- | --------------------------- |
| METABASE_URL | Your Metabase instance URL | Required | http://127.0.0.1:3000 |
| METABASE_API_KEY | Your Metabase API key | Required | mb_xxx_your_api_key |
| TRANSPORT | Transport protocol | streamable-http | stdio, streamable-http |
| HOST | Host for HTTP transports | localhost | 0.0.0.0, 127.0.0.1 |
| PORT | Port for HTTP transports | 3200 | 8080, 9000 |
| LOG_LEVEL | Logging level | INFO | DEBUG, WARNING, ERROR |

Configuration values are applied in the following priority order (highest to lowest):

1. Command-line arguments (overrides everything)
2. Environment variables (overrides defaults)
3. Default values

To get your Metabase API key:

1. Log into your Metabase instance
2. Click on your profile picture (top-right corner)
3. Select "Account settings"
4. Navigate to the "API Keys" tab
5. Click "Create API Key"
6. Give your key a descriptive name (e.g., "MCP Server Key")
7. Copy the generated key (starts with mb_)

⚠️ Important: Store your API key securely and never commit it to version control. The key provides full access to your Metabase instance.

---

For production use or team collaboration, you can deploy the Metabase MCP Server remotely. We use this approach internally at Codewalnut.

We've included Docker configuration files to make remote deployment straightforward.

docker run -d \
  -p 3200:3200 \
  -e METABASE_URL="http://your-metabase-instance.com" \
  -e METABASE_API_KEY="mb_xxx_your_api_key" \
  metabase-mcp-server

- Cloud Providers: AWS ECS, Google Cloud Run, Azure Container Instances
- VPS/Dedicated Servers: DigitalOcean, Linode, Vultr
- Container Platforms: Kubernetes, Docker Swarm
- Platform-as-a-Service: Railway, Render, Fly.io

Our team at CodeWalnut offers deployment and consulting services. Contact us for enterprise-grade setup and support.

---

```bash

npm install -g @modelcontextprotocol/inspector