Skip to main content
Glama

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

Tool

Description

list_dashboards

List all dashboards (with optional search)

get_dashboard

Get a dashboard by ID or slug

get_dashboard_charts

Get all charts in a dashboard

get_dashboard_datasets

Get all datasets used by a dashboard

create_dashboard

Create a new dashboard

update_dashboard

Update title, layout, metadata

publish_dashboard

Publish a draft dashboard

copy_dashboard

Duplicate a dashboard

delete_dashboard

Delete a dashboard

Charts

Tool

Description

list_charts

List all charts (with optional search)

get_chart

Get a chart by ID or UUID

get_chart_data

Fetch the latest data for a chart

create_chart

Create a new chart

update_chart

Update chart properties

delete_chart

Delete a chart

Datasets

Tool

Description

list_datasets

List all datasets

get_dataset

Get a dataset by ID or UUID

create_dataset

Create from a table or SQL query

get_or_create_dataset

Get existing or create new

refresh_dataset

Sync columns from source table

update_dataset

Update dataset properties

get_dataset_related_objects

See which charts/dashboards use it

delete_dataset

Delete a dataset

Databases

Tool

Description

list_databases

List all database connections

get_database

Get a database connection by ID

list_schemas

List schemas in a database

list_tables

List tables in a schema

get_table_metadata

Get column info for a table

get_select_star

Get a SELECT * template for a table

SQL

Tool

Description

execute_sql

Run a SQL query and get results

format_sql

Pretty-print a SQL query

estimate_query_cost

Estimate query cost (if supported)

list_saved_queries

List saved SQL queries

save_query

Save a SQL query


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"

Install Server
A
security – no known vulnerabilities
F
license - not found
B
quality - B tier

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/thedeceptio/superset-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server