Which integrations are available for this server?

Provides tools for managing Apache Superset datasets, metrics, calculated columns, charts, dashboards, and SQL queries, enabling full CRUD operations and configuration.

How do I use superset-mcp?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@superset-mcp list all datasets in the sales database" 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

by Winding2020

Overview Schema Related Servers Score Discussions

TypeScript

Remote

Superset MCP Server

A Model Context Protocol (MCP) server for managing Apache Superset datasets, metrics, and SQL queries.

📖 中文文档

🚀 Features

Dataset Management: Full CRUD operations for Superset datasets
Metrics Management: Create, update, and manage dataset metrics
Calculated Columns: Create and manage calculated columns for datasets
Chart Management: View and modify chart visualization parameters and filters
Dashboard Operations: Access dashboard information, charts, and filters
SQL Query Execution: Execute SQL queries directly through Superset
Database Integration: List and manage database connections
Resource Access: Browse datasets, databases, and metrics through MCP resources

Related MCP server: SQL MCP Server

📋 Prerequisites

Node.js 18+
Access to an Apache Superset instance
Valid Superset credentials (username/password or access token)

🛠️ Installation

Using with Cursor or Claude Desktop

1. Add to MCP Configuration

Add the following configuration to your MCP settings file:

{
  "mcpServers": {
    "superset-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "superset-mcp"
      ],
      "env": {
        "SUPERSET_BASE_URL": "",
        "SUPERSET_USERNAME": "",
        "SUPERSET_PASSWORD": ""
      }
    }
  }
}

2. Environment Variables

Configure your Superset connection by updating the env section in the MCP configuration:

"env": {
  "SUPERSET_BASE_URL": "your-superset-url",
  "SUPERSET_USERNAME": "your_username",
  "SUPERSET_PASSWORD": "your_password",
}

Alternative: Using Access Token

"env": {
  "SUPERSET_BASE_URL": "your-superset-url",
  "SUPERSET_ACCESS_TOKEN": "your_access_token"
}

🔧 Available Tools

Dataset Operations

Tool	Description
`list_datasets`	Get paginated list of all datasets with filtering and sorting
`get_dataset`	Get detailed information for a specific dataset
`create_dataset`	Create a new dataset (physical or virtual with SQL)
`update_dataset`	Update existing dataset properties
`delete_dataset`	Delete a dataset
`refresh_dataset_schema`	Refresh dataset schema from source database
`find_and_replace_in_sql`	Find and replace text in virtual dataset SQL

Metrics Operations

Tool	Description
`get_dataset_metrics`	Get all metrics for a dataset
`create_dataset_metric`	Create a new metric with SQL expression
`update_dataset_metric`	Update existing metric properties
`delete_dataset_metric`	Delete a metric

Calculated Columns Operations

Tool	Description
`get_dataset_columns`	Get column information (including calculated columns)
`create_calculated_column`	Create a new calculated column with SQL expression
`update_calculated_column`	Update existing calculated column
`delete_calculated_column`	Delete a calculated column

Chart Operations

Tool	Description
`list_charts`	Get paginated list of all charts with filtering and sorting
`create_chart`	Create a new chart; for most viz types you should first call `get_chart_params` to obtain the correct params schema
`get_chart_params`	Get required parameters format for chart visualization types
`get_current_chart_config`	Get current chart configuration details (viz params, relationships, ownership, query context)
`update_chart`	Update chart properties including metadata, datasource, and visualization parameters
`get_chart_filters`	Get current data filters applied to a chart
`set_chart_filters`	Set data filters for a chart (permanently updates the chart)

Dashboard Operations

Tool	Description
`list_dashboards`	Get paginated list of all dashboards with filtering and sorting
`get_dashboard_charts`	Get all charts in a specific dashboard with their information
`get_dashboard_filters`	Get dashboard's filter configuration (native filters, global filters)
`get_dashboard_chart_query_context`	Get complete query context for a chart in dashboard (dataset ID, used metrics with SQL expressions, calculated columns, applied filters)
`get_dashboard_config`	Get dashboard details and embedded configuration
`update_dashboard_config`	Update dashboard properties and/or embedded configuration
`add_chart_to_dashboard`	Add an existing chart to a dashboard and place it in the layout
`remove_chart_from_dashboard`	Remove a chart from a dashboard and clean up its layout

SQL Operations

Tool	Description
`execute_sql`	Execute SQL queries with result limiting and data display

Database Operations

Tool	Description
`list_databases`	Get all configured database connections

📚 Resources

Access read-only overviews through MCP resources:

superset://datasets - Overview of all datasets
superset://databases - List of database connections

Prompt examples

Use these natural prompts with your MCP-enabled assistant; it will pick the right tools and arguments.

List datasets
- "Show the first 10 datasets, most recently changed first. Only include id and table_name."
Create a chart
- "Create a simple table chart called 'Sample Table' using dataset 12."
Update a chart
- "Change chart 42 to a bar chart grouped by country and using SUM(value)."
Dashboard query context
- "On the 'sales-kpi' dashboard, show the full query context for chart 101."
Run SQL
- "On database 3, fetch the 10 most recently created users, returning only id and name."

This server cannot be installed

license - permissive license

quality - not tested

maintenance

How are these scores calculated?

Maintenance

–Maintainers

1dResponse time

–Release cycle

–Releases (12mo)

Commit activity

Issues opened vs closed

Resources

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly
Lightport: Open-Sourcing Glama's AI Gateway
By punkpeye on April 27, 2026.
OpenAI
open source
Tool Definition Quality Score (TDQS)
By punkpeye on April 3, 2026.
mcp

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/Winding2020/superset-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server