superset-mcp

MCP (Model Context Protocol) server for Apache Superset. Gives AI assistants full access to your Superset instance — dashboards, charts, datasets, databases, and SQL execution.

Prerequisites

• uv — Python package manager
• Access to a running Apache Superset instance

Setup (takes ~1 minute)

1. Clone the repo

git clone <repo-url>
cd superset-mcp

2. Configure credentials

cp .env.example .env

Edit .env:

SUPERSET_URL=http://your-superset-host:8088
SUPERSET_USERNAME=your-username
SUPERSET_PASSWORD=your-password

3. Test it works

uv run superset-mcp

You should see the MCP server start without errors. Press Ctrl+C to stop.

Connect to your AI client

Replace /ABSOLUTE/PATH/TO/superset-mcp with the actual path where you cloned the repo.

Claude Code

Add to ~/.claude/settings.json (or project-level .claude/settings.json):

{
  "mcpServers": {
    "superset": {
      "command": "uv",
      "args": ["--directory", "/ABSOLUTE/PATH/TO/superset-mcp", "run", "superset-mcp"],
      "env": {
        "SUPERSET_URL": "http://your-superset-host:8088",
        "SUPERSET_USERNAME": "your-username",
        "SUPERSET_PASSWORD": "your-password"
      }
    }
  }
}

Or run in terminal:

claude mcp add superset -- uv --directory /ABSOLUTE/PATH/TO/superset-mcp run superset-mcp

Claude Desktop

Add to ~/Library/Application Support/Claude/claude_desktop_config.json (macOS)
or %APPDATA%\Claude\claude_desktop_config.json (Windows):

{
  "mcpServers": {
    "superset": {
      "command": "uv",
      "args": ["--directory", "/ABSOLUTE/PATH/TO/superset-mcp", "run", "superset-mcp"],
      "env": {
        "SUPERSET_URL": "http://your-superset-host:8088",
        "SUPERSET_USERNAME": "your-username",
        "SUPERSET_PASSWORD": "your-password"
      }
    }
  }
}

Cursor

Add to .cursor/mcp.json in your project or ~/.cursor/mcp.json globally:

{
  "mcpServers": {
    "superset": {
      "command": "uv",
      "args": ["--directory", "/ABSOLUTE/PATH/TO/superset-mcp", "run", "superset-mcp"],
      "env": {
        "SUPERSET_URL": "http://your-superset-host:8088",
        "SUPERSET_USERNAME": "your-username",
        "SUPERSET_PASSWORD": "your-password"
      }
    }
  }
}

Available Tools

Dashboards

Charts

Datasets

Databases

SQL

Example prompts

Once connected to your AI assistant:

• "List all published dashboards"
• "Create a new dashboard called 'Sales Overview'"
• "Show me all charts in dashboard 11"
• "Run a SQL query on database 2: SELECT count() FROM orders"*
• "What datasets are used by the 'Revenue' dashboard?"
• "Create a bar chart using dataset 5 showing sales by region"