Superset MCP Integration
@aptro
About Superset MCP Integration
connect to 50+ data stores via superset mcp server. Can use with open ai agent sdk, Claude app, cursor, windsurf
Config
Add this server to your MCP-compatible client using the configuration below.
{
"darkMode": "light",
"scale": 0,
"locale": "en-US",
"mcpServers": {
"superset-mcp": {
"command": "cmd",
"args": [
"/c",
"npx",
"-y",
"@smithery/cli@latest",
"run",
"@aptro/superset-mcp",
"--key",
"83cb7c57-dd21-4b5c-a442-dd4b91d2cce4",
"--config",
"\"{\\\"supersetBaseUrl\\\":\\\"https://superset.supover.com/\\\"}\""
],
"env": {
"SUPERSET_USERNAME": "admin",
"SUPERSET_PASSWORD": "thien123"
}
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is Superset MCP Integration?
MCP server for interacting with Apache Superset, enabling AI agents to connect to and control a Superset instance programmatically.
How to use Superset MCP Integration?
Install via Smithery (npx -y @smithery/cli install @aptro/superset-mcp --client claude) or manually: set up Superset (tested with version 4.1.1) using Docker, clone the repo, create a .env file with SUPERSET_BASE_URL, SUPERSET_USERNAME, and SUPERSET_PASSWORD, install dependencies with uv pip install ., then run mcp install main.py for Claude Desktop.
Key features of Superset MCP Integration
- Dashboard CRUD operations (list, get, create, update, delete)
- Chart creation, update, and deletion
- Database connection management and SQL validation
- Dataset listing, retrieval, and creation
- SQL Lab query execution and formatting
- Tag management for organizing content
Use cases of Superset MCP Integration
- Manage dashboards and charts via natural language requests to Claude
- Execute, format, and estimate cost of SQL queries through Claude
- Create and update database connections programmatically
- List and inspect datasets, tables, schemas, and catalogs
- Organize content by tagging dashboards, charts, and other objects
FAQ from Superset MCP Integration
How do I install the Superset MCP Integration?
Install automatically via Smithery or manually: start Superset (version 4.1.1) with Docker, configure .env with your Superset credentials, install dependencies with uv pip install ., then run mcp install main.py for Claude Desktop.
What MCP tools are available?
Over 60 tools covering authentication, dashboards, charts, databases, datasets, SQL Lab, queries, saved queries, user info, activity, system, tags, exploration, and advanced data types.
How are credentials stored and handled?
Superset credentials are stored only in your local .env file, and the access token is stored in .superset_token in the project directory. No credentials are transmitted to Claude or any third parties.
What version of Superset is supported?
The integration is tested with Superset version 4.1.1.
How can I troubleshoot authentication issues?
Verify your credentials in the .env file, ensure Superset is running and accessible at the URL specified, and check that the port used by the MCP server is not being used by another application.
Frequently asked questions
How do I install the Superset MCP Integration?
Install automatically via Smithery or manually: start Superset (version 4.1.1) with Docker, configure `.env` with your Superset credentials, install dependencies with `uv pip install .`, then run `mcp install main.py` for Claude Desktop.
What MCP tools are available?
Over 60 tools covering authentication, dashboards, charts, databases, datasets, SQL Lab, queries, saved queries, user info, activity, system, tags, exploration, and advanced data types.
How are credentials stored and handled?
Superset credentials are stored only in your local `.env` file, and the access token is stored in `.superset_token` in the project directory. No credentials are transmitted to Claude or any third parties.
What version of Superset is supported?
The integration is tested with Superset version 4.1.1.
How can I troubleshoot authentication issues?
Verify your credentials in the `.env` file, ensure Superset is running and accessible at the URL specified, and check that the port used by the MCP server is not being used by another application.
Basic information
More AI & Agents MCP servers
MCP Server - Remote MacOs Use
baryhuangThe only general AI agent that does NOT requires extra API key, giving you full control on your local and remote MacOs from Claude Desktop App
Just Prompt - A lightweight MCP server for LLM providers
dislerjust-prompt is an MCP server that provides a unified interface to top LLM providers (OpenAI, Anthropic, Google Gemini, Groq, DeepSeek, and Ollama)
Shell and Coding agent for Claude and other mcp clients
rusiaamanShell and coding agent on mcp clients
Web Agent Protocol
OTA-Tech-AI🌐Web Agent Protocol (WAP) - Record and replay user interactions in the browser with MCP support
Solon Ai
opensolonJava AI application development framework (supports LLM-tool,skill; RAG; MCP; Agent-ReAct,Team-Agent). Compatible with java8 ~ java25. It can also be embedded in SpringBoot, jFinal, Vert.x, Quarkus, and other frameworks.
Comments