superset-mcp

Winding2020/superset-mcp

3.3

If you are the rightful owner of superset-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

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

The Superset MCP Server is a specialized server designed to facilitate the management of Apache Superset datasets, metrics, and SQL queries through the Model Context Protocol (MCP). It provides a comprehensive suite of tools for dataset management, metrics creation and updating, SQL query execution, and database integration. The server is built to streamline the interaction with Superset, allowing users to perform CRUD operations on datasets, manage metrics, and execute SQL queries directly. It also supports browsing datasets, databases, and metrics through MCP resources, making it a powerful tool for data exploration and management. The server requires Node.js 18+ and access to an Apache Superset instance with valid credentials.

Features

  • Full CRUD operations for Superset datasets
  • Create, update, and manage dataset metrics
  • Execute SQL queries directly through Superset
  • List and manage database connections
  • Browse datasets, databases, and metrics through MCP resources

Usages

usage with Cursor or Claude Desktop

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

usage with Cursor or Claude Desktop with Access Token

{
  "mcpServers": {
    "superset-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "superset-mcp"
      ],
      "env": {
        "SUPERSET_BASE_URL": "your-superset-url",
        "SUPERSET_ACCESS_TOKEN": "your_access_token"
      }
    }
  }
}

Tools

  1. list_datasets

    Get paginated list of all datasets

  2. get_dataset

    Get detailed information for a specific dataset

  3. create_dataset

    Create a new dataset

  4. update_dataset

    Update existing dataset properties

  5. delete_dataset

    Delete a dataset

  6. refresh_dataset_schema

    Refresh dataset schema from source

  7. get_dataset_metrics

    Get all metrics for a dataset

  8. create_dataset_metric

    Create a new metric

  9. update_dataset_metric

    Update existing metric

  10. delete_dataset_metric

    Delete a metric

  11. get_dataset_columns

    Get column information (including calculated columns)

  12. create_calculated_column

    Create a new calculated column

  13. update_calculated_column

    Update existing calculated column

  14. delete_calculated_column

    Delete a calculated column

  15. execute_sql

    Execute SQL queries with result limiting

  16. list_databases

    Get all configured database connections

  17. list_charts

    Get paginated list of all charts with filtering and sorting

  18. get_chart_params

    Get visualization parameters of a chart

  19. update_chart_params

    Update chart visualization parameters

  20. get_chart_filters

    Get current data filters applied to a chart

  21. set_chart_filters

    Set data filters for a chart

  22. list_dashboards

    Get paginated list of all dashboards with filtering and sorting

  23. get_dashboard_charts

    Get all charts in a specific dashboard with their information

  24. get_dashboard_filters

    Get dashboard's filter configuration

  25. get_dashboard_chart_query_context

    Get complete query context for a chart in dashboard