Superset MCP Server

Manage Apache Superset datasets, metrics, and SQL queries.

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

- 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

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

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": "" } } } }

Configure your Superset connection by updating theenvsection in the MCP configuration:

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

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

Access read-only overviews through MCP resources:

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

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

- "Show the first 10 datasets, most recently changed first. Only include id and table_name."

- "Create a simple table chart called 'Sample Table' using dataset 12."

- "Change chart 42 to a bar chart grouped by country and using SUM(value)."

- "On the 'sales-kpi' dashboard, show the full query context for chart 101."

- "On database 3, fetch the 10 most recently created users, returning only id and name."

Official MCP server for dbt (data build tool) providing integration with dbt Core/Cloud CLI, project metadata discovery, model information, and semantic layer querying capabilities.

Query and analyze data with MotherDuck and local DuckDB

A read-only MCP server for SAP BusinessObjects BI, powered by the CData JDBC Driver.

Connect your LLM to the Firebolt Data Warehouse for data querying and analysis.

API-first engine and MCP server that transforms declarative YAML model definitions into optimized SQL for Postgres, Snowflake, ClickHouse, Dremio, and Databricks

An MCP server for interacting with Apache Pinot, a real-time distributed OLAP datastore.

Execute queries and retrieve results using the Redash API.

Connects Claude Desktop to Tableau Server, enabling natural language interactions with your Tableau data and administrative capabilities.

Interact with Tableau Server using natural language to query data and perform administrative tasks.

Interact with Teradata databases for data queries and business intelligence.