Apache Superset MCP Server

1

Add it to Claude Code

Run this in a terminal.

Run in terminal
claude mcp add -e "SUPERSET_URL=${SUPERSET_URL}" -e "SUPERSET_USERNAME=${SUPERSET_USERNAME}" -e "SUPERSET_PASSWORD=${SUPERSET_PASSWORD}" mcp-superset -- uvx mcp-superset
Required:SUPERSET_URLSUPERSET_USERNAMESUPERSET_PASSWORD
README.md

Full-featured MCP server for Apache Superset with 128+ tools

mcp-superset

A comprehensive Model Context Protocol (MCP) server for Apache Superset. Gives AI assistants (Claude, GPT, etc.) full control over your Superset instance — dashboards, charts, datasets, SQL Lab, users, roles, RLS, and more — through 128+ tools.

Comparison with Other Superset MCP Servers

Feature mcp-superset superset-mcp superset-mcp (Winding2020) superset-mcp-server
Total tools 128+ ~60 ~31 4
Language Python Python TypeScript TypeScript
Dashboard CRUD 15 tools 5 8 -
Dashboard native filters 5 tools - - -
Chart CRUD 11 tools 5 7 -
Database tools 18 tools 14 1 1
Dataset tools 11 tools 3 7 -
SQL Lab 5 tools 7 1 1
Security (users/roles) 22 tools 2 - -
Row Level Security 5 tools - - -
Groups 9 tools - - -
Permissions audit yes - - -
Dashboard access grant/revoke yes - - -
Auto datasource_access sync yes - - -
Reports & annotations 10 tools - - -
Tags 7 tools 7 - -
Asset export/import yes - - -
Safety: confirmation flags 14 types - - -
Safety: DDL/DML blocking yes - - -
Safety: system role protection yes - - -
Transport HTTP, SSE, stdio stdio stdio stdio
Auth method JWT + auto-refresh + CSRF Username/password + token file Username/password or token LDAP
Superset versions 6.0.1 4.1.1 not specified not specified
CLI with args --host --port --transport - - -
PyPI package mcp-superset superset-mcp superset-mcp (npm) -
uvx support yes - - -
License MIT MIT - Apache 2.0
GitHub stars new 170 21 5

Key differentiators:

  • Only MCP server with full security management (users, roles, RLS, groups, permissions audit)
  • Only one with built-in safety validations (confirmation flags, DDL/DML blocking)
  • Only one with dashboard native filter management
  • Only one with automatic datasource_access synchronization
  • Only one with multiple transport options (HTTP, SSE, stdio)
  • Only one with configurable CLI (--host, --port, --transport, --env-file)

Features

  • 128+ MCP tools covering the complete Superset REST API
  • Dashboard management — CRUD, copy, publish/unpublish, export/import, embedded mode, native filters
  • Chart management — CRUD, copy, data retrieval, export/import, cache warmup
  • Database management — CRUD, connection testing, schema/table introspection, SQL validation
  • Dataset management — CRUD, duplicate, schema refresh, export/import
  • SQL Lab — query execution, formatting, cost estimation, results & CSV export
  • Security — users, roles, permissions, Row Level Security (RLS), groups
  • Access control automation — grant/revoke dashboard access with automatic datasource permission sync
  • Audit — comprehensive permissions matrix (u

Tools (5)

dashboard_crudPerform create, read, update, and delete operations on Superset dashboards.
chart_crudManage Superset charts including creation, retrieval, and updates.
sql_lab_queryExecute queries in SQL Lab, format SQL, and export results.
security_managementManage users, roles, groups, and Row Level Security (RLS) policies.
permissions_auditPerform a comprehensive audit of user permissions and access matrices.

Environment Variables

SUPERSET_URLrequiredThe base URL of your Apache Superset instance
SUPERSET_USERNAMErequiredUsername for authentication
SUPERSET_PASSWORDrequiredPassword for authentication

Configuration

claude_desktop_config.json
{"mcpServers": {"superset": {"command": "uvx", "args": ["mcp-superset"], "env": {"SUPERSET_URL": "http://localhost:8088", "SUPERSET_USERNAME": "admin", "SUPERSET_PASSWORD": "admin"}}}}

Try it

→List all dashboards currently available in my Superset instance.
→Create a new chart based on the 'sales_data' dataset showing total revenue by month.
→Run a SQL query to check the top 10 customers from the 'orders' table in SQL Lab.
→Audit the permissions for the user 'jdoe' and identify any excessive access rights.
→Grant the 'Marketing' role access to the 'Q3 Performance' dashboard.

Frequently Asked Questions

What are the key features of Apache Superset?

128+ MCP tools covering the complete Superset REST API. Full security management including users, roles, RLS, and groups. Built-in safety validations with confirmation flags and DDL/DML blocking. Dashboard native filter management and automatic datasource access synchronization. Support for multiple transport options including HTTP, SSE, and stdio.

What can I use Apache Superset for?

Automating the creation and deployment of BI dashboards for new projects.. Performing security audits to ensure users have appropriate access to sensitive datasets.. Streamlining SQL Lab workflows by allowing AI to generate and execute complex analytical queries.. Managing large-scale dashboard and chart migrations across different Superset environments..

How do I install Apache Superset?

Install Apache Superset by running: uvx mcp-superset

What MCP clients work with Apache Superset?

Apache Superset works with any MCP-compatible client including Claude Desktop, Claude Code, Cursor, and other editors with MCP support.

Turn this server into reusable context

Keep Apache Superset docs, env vars, and workflow notes in Conare so your agent carries them across sessions.

Need the old visual installer? Open Conare IDE.
Open Conare
View all database servers →

Related MCP Servers

GoSQLX
Production-ready SQL parsing SDK for Go with 7 SQL tools
database61 stars
Altinity MCP
Interact with ClickHouse databases through the Model Context Protocol
database23 stars
Bonnard
Self-hosted semantic layer for AI agents.
database19 stars
BioBTree
A unified biomedical graph database that integrates 50+ primary data sources
database16 stars
Hypabase
A Python hypergraph library with provenance and SQLite persistence.
database11 stars
Kafka MCP
MCP server for Apache Kafka to inspect topics, groups, and manage offsets.
database10 stars