Provides tools for managing Apache Superset datasets, metrics, calculated columns, charts, dashboards, and SQL queries, enabling full CRUD operations and configuration.
Click on "Deploy 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-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.
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
Related MCP server: SQL MCP Server
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 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"
}Tool | Description |
| Get paginated list of all datasets with filtering and sorting |
| Get detailed information for a specific dataset |
| Create a new dataset (physical or virtual with SQL) |
| Update existing dataset properties |
| Delete a dataset |
| Refresh dataset schema from source database |
| Find and replace text in virtual dataset SQL |
Tool | Description |
| Get all metrics for a dataset |
| Create a new metric with SQL expression |
| Update existing metric properties |
| Delete a metric |
Tool | Description |
| Get column information (including calculated columns) |
| Create a new calculated column with SQL expression |
| Update existing calculated column |
| Delete a calculated column |
Tool | Description |
| Get paginated list of all charts with filtering and sorting |
| Create a new chart; for most viz types you should first call |
| Get required parameters format for chart visualization types |
| Get current chart configuration details (viz params, relationships, ownership, query context) |
| Update chart properties including metadata, datasource, and visualization parameters |
| Get current data filters applied to a chart |
| Set data filters for a chart (permanently updates the chart) |
Tool | Description |
| Get paginated list of all dashboards with filtering and sorting |
| Get all charts in a specific dashboard with their information |
| Get dashboard's filter configuration (native filters, global filters) |
| Get complete query context for a chart in dashboard (dataset ID, used metrics with SQL expressions, calculated columns, applied filters) |
| Get dashboard details and embedded configuration |
| Update dashboard properties and/or embedded configuration |
| Add an existing chart to a dashboard and place it in the layout |
| Remove a chart from a dashboard and clean up its layout |
Tool | Description |
| Execute SQL queries with result limiting and data display |
Tool | Description |
| Get all configured database connections |
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.
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 deployed
MCP server for interacting with the Supabase platform
Model Context Protocol server for the Apideck Unified API. Connect any MCP-compatible agent framework to 100+ accounting systems, HRIS platforms, file storage providers, and more through one integration. More information https://www.apideck.com/mcp-server
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
A comprehensive Model Context Protocol (MCP) server that enables AI assistants to interact with yoβ¦
