mcp-superset: MCP server for Apache Superset
mcp-superset
An MCP server for Superset, 130+ tools: dashboards, charts, datasets, SQL Lab, roles and guards against dangerous operations
- 65 ★ on the repository
- Last commit
Broad access
Why this level
- The account opens creating, changing and deleting dashboards, datasets, users and roles
- SQL Lab sends queries to connected databases and the results reach the agent context
Install
- Works in
In your terminal, with SkillFoxx CLI
npx skillfoxx add mcp/mcp-supersetDetects the agents on your machine, shows the access level and pins the version.
Other ways to install
Access and checks
How we reviewBroad accessThe tool can change data, run commands or handle secrets.
- The account opens creating, changing and deleting dashboards, datasets, users and roles
- SQL Lab sends queries to connected databases and the results reach the agent context
This is third-party code. Review the repository files before installing.
What it does
The server covers the Apache Superset REST API and lets the agent manage the whole instance. For dashboards it offers create, copy, publish, export and import, embedded mode and native filters. Charts can be created, copied, have data pulled and the cache warmed. For databases there are connection tests and schema and table browsing, and for datasets duplication and schema refresh. SQL Lab runs queries, formats them, estimates cost and returns results and CSV. Separate tool groups handle reports, annotations, tags, users, roles, groups, row level security rules and permission audits. Dangerous actions have confirmation flags of fourteen types, DDL and DML blocking in SQL Lab and protection of system roles. Login uses JWT with auto-refresh and CSRF, the transports are streamable-http, SSE and stdio, and host and port are set with --host and --port.
Who it is for. Analysts and BI admins who run Superset and want to manage dashboards, datasets and access through a conversation with an agent.
Good fit when
- You need a dashboard with a set of charts created from a description and published right away
- Role permissions and dataset access need an audit and bulk edits
- The agent should run a query in SQL Lab and show the result
- For moving between environments dashboards and datasets are exported and imported as an archive
- Native filters should be set up the same way on several dashboards
Not a fit when
- Your Superset is older than the tested one: the server targets 6.0.1 and other versions are not guaranteed
- The agent must not manage users and roles: then provide an account with narrow rights
- For a one-off database query a plain SQL client is enough, and 130 tools would only fill the context
Example request
Create a Superset dashboard on the sales dataset with revenue charts by month and by region and show the link without publishing it.MCP
- Transport
- http, sse, stdio
- Authentication
- API key
Environment variables
SUPERSET_BASE_URLrequired- Apache Superset instance URL
SUPERSET_USERNAMErequired- Superset username
SUPERSET_PASSWORDrequired, secret- Superset password
SUPERSET_MCP_TRANSPORT- Transport: streamable-http, sse or stdio
Limitations
The server is tested on Superset 6.0.1. You need the instance URL, a username and password and the db or ldap login provider. A browser session cookie through SUPERSET_SESSION_COOKIE is also allowed as a fallback for instances without regular login, so guard the value like a password. The README header says 128 plus tools and the comparison table says 137, the figures in the description differ. Confirmation flags and DDL and DML blocking reduce risk but do not replace narrowing the account rights.
How to disable. Run claude mcp remove superset or remove the block from the client config and stop the uvx mcp-superset process. For a Superset account created for the agent revoke the password and roles.
FAQ
Which Superset version is required?
The README comparison table lists version 6.0.1. Test other versions on a staging instance.
How does the server guard against dangerous operations?
Confirmation flags of fourteen types require explicit consent for destructive actions. DDL and DML are blocked in SQL Lab and system roles are protected from changes.
How do I connect to Superset with SSO?
Besides username and password there is the SUPERSET_SESSION_COOKIE mode: the cookie value is taken from the browser and the name is set by SUPERSET_SESSION_COOKIE_NAME if it is not session. The mode takes precedence over username and password.
Which transports are available?
Streamable HTTP by default, SSE and stdio. The SUPERSET_MCP_HOST, SUPERSET_MCP_PORT and SUPERSET_MCP_TRANSPORT variables or the --host and --port flags set the address.
How does it differ from other Superset MCP servers?
The README compares it with three other servers: more tools, security management with RLS and groups, dashboard filters and checks before dangerous actions. The author wrote the comparison.
Discussion
No questions or reviews yet.
Related
MCP serversAn agent queries GreptimeDB metrics, logs and traces with SQL, TQL and RANGE, with write protection and data masking
MySQL MCP Server Pro
mysql_mcp_server_pro
A MySQL MCP server that runs SQL under access roles, finds tables by comments and analyzes locks, indexes and query plans
One MCP server for SQLite, SQL Server, PostgreSQL and MySQL: read and change data, edit schemas and export to CSV and JSON
A Python MCP server for MySQL: listing tables, reading data, running SQL and inspecting schema through a controlled interface
Official Tableau MCP server: the agent finds data sources, sends queries to them and opens dashboards and Pulse metrics
Dremio MCP server: an agent browses tables, looks for patterns in the data and analyzes cluster workload.
Comparison with similar tools
Cards that share the main search query, and how they differ.
| Tool | Official | Authentication | Repository stars | Main difference |
|---|---|---|---|---|
| mcp-superset: MCP server for Apache Superset (this card) | no | API key | 65 | |
| Grafana MCP Server | yes | API key | 3,663 | Grafana panels and metrics, a different BI system |
| Prometheus MCP Server | no | not required | 525 | queries to Prometheus metrics, without dashboards and datasets |
README in short
The README has a comparison table with other Superset servers, a feature list, installation through pip, uv and uvx, environment variables, login methods and command line flags. Tools are split into groups.