mcp-superset

Overview

mcp-superset is a feature-rich MCP server that provides complete control over Apache Superset through 137 tools. It stands out with advanced security management, including users, roles, Row Level Security (RLS), groups, and permissions audit. The server supports multiple transport options (HTTP, SSE, stdio) and includes built-in safety features like confirmation flags for destructive operations and DDL/DML blocking in SQL Lab. The project offers comprehensive documentation, installation options, and seamless integration with various MCP clients.

Try asking AI

After installing, here are 9 things you can ask your AI assistant:

• superset_dashboard_list

  List dashboards with filtering and pagination

  Try:Show me all dashboardsTry:List my latest dashboards
• superset_dashboard_create

  Create a new dashboard

  Try:Create a new sales dashboardTry:Make a marketing performance dashboard
• superset_chart_create

  Create a new chart

  Try:Create a bar chart showing monthly salesTry:Make a pie chart of market share
• superset_database_test_connection

  Test database connectivity

  Try:Test connection to PostgreSQL databaseTry:Check if my MySQL database is accessible
• superset_dataset_create

  Create a dataset from a table or SQL query

  Try:Create a dataset from my orders tableTry:Make a dataset from this SQL query
• superset_sqllab_execute

  Execute a SQL query (SELECT only)

  Try:Run this query: SELECT * FROM salesTry:Get top 10 customers by revenue
• superset_user_create

  Create a new user

  Try:Create a new user for John SmithTry:Add a user with analytics role
• superset_role_create

  Create a new role

  Try:Create a new role for data analystsTry:Make an admin role with all permissions
• superset_dashboard_export

  Export dashboard as ZIP (base64)

  Try:Export my sales dashboardTry:Get a backup of my marketing dashboard
• superset_dataset_refresh_schema

  Refresh columns from source

  Try:Refresh schema for my orders datasetTry:Update columns for customer dataset
• superset_dashboard_filter_add

  Add a native filter (auto-generates correct ID format)

  Try:Add a date filter to my dashboardTry:Add a region filter to sales dashboard
• superset_query_stop

  Stop a running query

  Try:Stop my slow-running queryTry:Cancel the query that's taking too long

Comparable tools

Installation

# From PyPI
pip install mcp-superset

# With uv (recommended)
uv pip install mcp-superset

# Run without installing
uvx mcp-superset

SUPERSET_BASE_URL=https://superset.example.com
SUPERSET_USERNAME=admin
SUPERSET_PASSWORD=your_password

# Using CLI
mcp-superset

# With stdio transport (for Claude Desktop, etc.)
mcp-superset --transport stdio

{
  "mcpServers": {
    "superset": {
      "command": "uvx",
      "args": ["mcp-superset", "--transport", "stdio"],
      "env": {
        "SUPERSET_BASE_URL": "https://superset.example.com",
        "SUPERSET_USERNAME": "admin",
        "SUPERSET_PASSWORD": "your_password"
      }
    }
  }
}

FAQ

What Superset versions are supported?

This MCP server is specifically built for Superset 6.0.1 and may not be compatible with earlier versions.

How does the authentication work?

The server supports JWT authentication with automatic token refresh and CSRF handling. You can authenticate using username/password or LDAP.

Can I use this with MCP clients other than Claude?

Yes, it supports multiple MCP clients through HTTP, SSE, and stdio transports, including Cursor, Windsurf, and any MCP-compatible client.

Compare mcp-superset with