superset-mcp
Provides full access to Apache Superset instances, enabling AI assistants to manage dashboards, charts, datasets, databases, and execute SQL queries through Superset's API.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@superset-mcpshow me the top 5 dashboards by view count"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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-mcp2. Configure credentials
cp .env.example .envEdit .env:
SUPERSET_URL=http://your-superset-host:8088
SUPERSET_USERNAME=your-username
SUPERSET_PASSWORD=your-password3. Test it works
uv run superset-mcpYou 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-mcpClaude 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 all dashboards (with optional search) |
| Get a dashboard by ID or slug |
| Get all charts in a dashboard |
| Get all datasets used by a dashboard |
| Create a new dashboard |
| Update title, layout, metadata |
| Publish a draft dashboard |
| Duplicate a dashboard |
| Delete a dashboard |
Charts
Tool | Description |
| List all charts (with optional search) |
| Get a chart by ID or UUID |
| Fetch the latest data for a chart |
| Create a new chart |
| Update chart properties |
| Delete a chart |
Datasets
Tool | Description |
| List all datasets |
| Get a dataset by ID or UUID |
| Create from a table or SQL query |
| Get existing or create new |
| Sync columns from source table |
| Update dataset properties |
| See which charts/dashboards use it |
| Delete a dataset |
Databases
Tool | Description |
| List all database connections |
| Get a database connection by ID |
| List schemas in a database |
| List tables in a schema |
| Get column info for a table |
| Get a SELECT * template for a table |
SQL
Tool | Description |
| Run a SQL query and get results |
| Pretty-print a SQL query |
| Estimate query cost (if supported) |
| List saved SQL queries |
| 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"
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