MCP.so
Sign In

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.

Comments

More AI & Agents MCP servers