MCP Superset — Claude Code MCP server: what it does, how to install
Integrates Apache Superset with AI coding tools through the Model Context Protocol. It enables agents to inspect datasets, run queries, edit dashboards, and manage permissions.
claude mcp add mcp-superset -e SUPERSET_BASE_URL=<SUPERSET_BASE_URL> -e SUPERSET_USERNAME=<SUPERSET_USERNAME> -e SUPERSET_PASSWORD=<SUPERSET_PASSWORD> -- uvx mcp-supersetWhat MCP Superset does
This server exposes 137 tools that hook into the Apache Superset REST interface. An assistant can edit dashboards, adjust charts, inspect database tables, and validate SQL queries. It handles schema refreshes alongside asset backups. Running it requires Python 3.12+.
Destructive actions include built-in safeguards. The SQL Lab tools block DDL and DML queries to prevent accidental modifications, while hazardous actions need explicit confirmation flags. Assistants can audit access matrices and assign Row Level Security (RLS) rules. Dataset permissions update automatically whenever someone gains dashboard access.
Communication works over stdio, SSE, or streamable HTTP. Standard setups use username and password credentials with automatic JWT refreshes. When an instance sits behind enterprise SSO or OAuth, REST password logins fail. In that setup, you have to extract a session cookie from your browser manually and restart the server once it expires.
What it helps with
- Inspect schemas, tables, and validate queries across connected databases
- Execute SQL Lab queries and download the output as CSV
- Configure Row Level Security rules and manage user roles
- Update dashboard layouts, manage native filters, and publish changes
Example prompts for the agent
- Show available datasets in Superset and refresh the schema for
orders. - Run a query in SQL Lab against database
analyticsand export the results to CSV. - Apply a date native filter to the dashboard with ID 14.
How to install MCP Superset
Platform CLI
claude mcp add mcp-superset -e SUPERSET_BASE_URL=<SUPERSET_BASE_URL> -e SUPERSET_USERNAME=<SUPERSET_USERNAME> -e SUPERSET_PASSWORD=<SUPERSET_PASSWORD> -- uvx mcp-supersetReplace <…> with your own values. uvx runs the command named after the package; if the README names another one, use uvx --from mcp-superset <command>
Platform CLI
codex mcp add mcp-superset --env SUPERSET_BASE_URL=<SUPERSET_BASE_URL> --env SUPERSET_USERNAME=<SUPERSET_USERNAME> --env SUPERSET_PASSWORD=<SUPERSET_PASSWORD> -- uvx mcp-supersetReplace <…> with your own values. uvx runs the command named after the package; if the README names another one, use uvx --from mcp-superset <command>
Config file
{
"mcpServers": {
"mcp-superset": {
"command": "uvx",
"args": [
"mcp-superset"
],
"env": {
"SUPERSET_BASE_URL": "<SUPERSET_BASE_URL>",
"SUPERSET_USERNAME": "<SUPERSET_USERNAME>",
"SUPERSET_PASSWORD": "<SUPERSET_PASSWORD>"
}
}
}
}Replace <…> with your own values. uvx runs the command named after the package; if the README names another one, use uvx --from mcp-superset <command>
Config file
{
"servers": {
"mcp-superset": {
"type": "stdio",
"command": "uvx",
"args": [
"mcp-superset"
],
"env": {
"SUPERSET_BASE_URL": "<SUPERSET_BASE_URL>",
"SUPERSET_USERNAME": "<SUPERSET_USERNAME>",
"SUPERSET_PASSWORD": "<SUPERSET_PASSWORD>"
}
}
}
}Replace <…> with your own values. uvx runs the command named after the package; if the README names another one, use uvx --from mcp-superset <command>
Platform CLI
gemini mcp add -e SUPERSET_BASE_URL=<SUPERSET_BASE_URL> -e SUPERSET_USERNAME=<SUPERSET_USERNAME> -e SUPERSET_PASSWORD=<SUPERSET_PASSWORD> mcp-superset uvx mcp-supersetReplace <…> with your own values. uvx runs the command named after the package; if the README names another one, use uvx --from mcp-superset <command>
Step by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about MCP Superset
How do I install MCP Superset in Claude Code?
Run this command in your terminal: `claude mcp add mcp-superset -e SUPERSET_BASE_URL=<SUPERSET_BASE_URL> -e SUPERSET_USERNAME=<SUPERSET_USERNAME> -e SUPERSET_PASSWORD=<SUPERSET_PASSWORD> -- uvx mcp-superset`. Replace the placeholders with your actual Superset URL, username, and password.
What does MCP Superset do?
It provides 137 tools to interface with Apache Superset. Your coding assistant can build charts, update dashboards, inspect database tables, run SQL Lab queries, and audit access permissions.
How do I authenticate if Superset uses SSO or OAuth?
Standard REST password logins do not work under SSO. Set the SUPERSET_SESSION_COOKIE environment variable with your active cookie from browser dev tools, and restart the MCP server whenever that session token expires.
