Research & Data · Developer Tools

Superset MCP logo

Superset MCP

aptro/superset-mcp

MCP server for interacting with Apache Superset, enabling AI agents to connect to and control a Superset instance programmatically.

Install

npx -y @smithery/cli install @aptro/superset-mcp --client claude

Environment variables

SUPERSET_BASE_URLSUPERSET_USERNAMESUPERSET_PASSWORD
GitHub stars
27
Author
@aptro
Category
Research & Data, Developer Tools
License
MIT
Updated
Oct 6, 2026

Features

  • Execute queries: "Run this SQL query: SELECT COUNT(*) FROM orders"

  • Format SQL: "Format this SQL query: SELECT id,name,age FROM users WHERE age>21"

  • Estimate query cost: "Estimate the cost of this query: SELECT * FROM large_table"

  • Get saved queries: "Show me all my saved SQL queries"

  • Get query results: "Get the results of query with key 'abc123'"

Tools (40)

  • superset_auth_check_token_validity

    Check if the current access token is valid

  • superset_auth_refresh_token

    Refresh the access token

  • superset_auth_authenticate_user

    Authenticate with Superset

  • superset_dashboard_get_by_id

    Get a specific dashboard

  • superset_dashboard_create

    Create a new dashboard

  • superset_dashboard_update

    Update an existing dashboard

  • superset_dashboard_delete

    Delete a dashboard

  • superset_chart_get_by_id

    Get a specific chart

  • superset_chart_create

    Create a new chart

  • superset_chart_update

    Update an existing chart

  • superset_chart_delete

    Delete a chart

  • superset_database_get_by_id

    Get a specific database

  • superset_database_create

    Create a new database connection

  • superset_database_schemas

    Get schemas for a database

  • superset_database_test_connection

    Test a database connection

  • superset_database_update

    Update an existing database connection

  • superset_database_delete

    Delete a database connection

  • superset_database_get_catalogs

    Get catalogs for a database

  • superset_database_get_connection

    Get database connection information

  • superset_database_get_function_names

    Get function names supported by a database

  • superset_database_get_related_objects

    Get charts and dashboards associated with a database

  • superset_database_validate_sql

    Validate arbitrary SQL against a database

  • superset_database_validate_parameters

    Validate database connection parameters

  • superset_dataset_get_by_id

    Get a specific dataset

  • superset_dataset_create

    Create a new dataset

  • superset_sqllab_execute_query

    Execute a SQL query

  • superset_sqllab_format_sql

    Format a SQL query

  • superset_sqllab_get_results

    Get query results

  • superset_sqllab_estimate_query_cost

    Estimate query cost

  • superset_sqllab_export_query_results

    Export query results to CSV

  • superset_sqllab_get_bootstrap_data

    Get SQL Lab bootstrap data

  • superset_query_get_by_id

    Get a specific query

  • superset_query_stop

    Stop a running query

  • superset_saved_query_get_by_id

    Get a specific saved query

  • superset_saved_query_create

    Create a new saved query

  • superset_user_get_current

    Get current user info

  • superset_user_get_roles

    Get user roles

  • superset_activity_get_recent

    Get recent activity data

  • superset_menu_get

    Get menu data

  • superset_config_get_base_url

    Get the base URL of the Superset instance

Details on this page are taken from the project's README. Open README

Supported clients

Clients mentioned in this server's README:

View all
Claude Desktop logo

Claude Desktop

Desktop · Freemium · Proprietary

Anthropic's official Claude AI desktop application. Supports MCP servers to extend functionality.

WindowsMacOS

Related MCP servers

More servers
Firecrawl MCP Server logo

Firecrawl MCP Server

mendableai/firecrawl-mcp-server

2.8k

A Model Context Protocol (MCP) server that brings Firecrawl to MCP-compatible AI agents — search, scrape, and interact with the live web for clean, agent-ready context.

Research & Data
Exa Web Search logo

Exa Web Search

exa-labs/exa-mcp-server

1.4k

Connect AI agents to Exa for web search, content fetching, and multi-step research.

Research & Data
ArXiv logo

ArXiv

blazickjp/arxiv-mcp-server

1k

A local MCP server for agent literature work. The differentiator is original-LaTeX section reads, BibTeX from arXiv metadata, and topic watches. Papers stay on disk.

Research & Data
sail logo

sail

lakehq/sail

730

Sail is a drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads on a distributed, multimodal compute engine.

Research & Data

OpenAPI Proxy

janwilmake/openapi-mcp-server

554

A Model Context Protocol (MCP) server for Claude/Cursor that enables searching and exploring OpenAPI specifications through oapis.org.

Research & Data
Excel MCP Server logo

Excel MCP Server

haris-musa/excel-mcp-server

393

A Model Context Protocol server that lets AI assistants create, read and edit Excel workbooks. It needs no Microsoft Excel installation.

Research & Data