How to Use the Apache Superset MCP in VS Code Copilot

Q: How do I run database queries on Apache Superset using VS Code Copilot?

You ask VS Code Copilot to run a query, and it calls the executesqlquery tool with your database ID. The raw results are returned directly into your Copilot Chat window.

Q: Can VS Code Copilot help my team document our Apache Superset dashboards?

Yes, Copilot can use getdashboarddetails and listdashboards to inspect your BI layout. It can then generate markdown documentation or schema maps directly in your workspace.

Q: Can I find specific charts using this server in VS Code?

Yes, the listcharts tool lets Copilot search your entire chart inventory. You can find specific chart IDs and then use getchartdetails to inspect their underlying SQL over MCP.

Run database queries and inspect Apache Superset dashboards directly from VS Code Copilot.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Apache Superset MCP to VS Code Copilot

Create your Vinkius account to connect Apache Superset to VS Code Copilot and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup Apache Superset with VS Code Copilot

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Inspect Superset dashboard layouts in VS Code

The `get_dashboard_details` tool fetches the component structure and chart IDs from your active Superset dashboards. VS Code Copilot reads this layout to help your team document or rebuild internal reports. By using `list_dashboards`, your team can search for specific reports without leaving the editor. This keeps your developers focused on their workspace instead of switching back and forth to a browser.

Execute database queries from Copilot Chat

The `execute_sql_query` tool runs custom SQL commands directly against your Superset database connections. VS Code Copilot sends the query and displays the raw rows in your chat panel for instant analysis. This tool lets you run quick checks on production or staging data without opening a separate database client. You can immediately ask Copilot to write a script that processes the returned dataset.

Discover datasets and charts for team projects

The `list_datasets` tool lists all available datasets configured in your Apache Superset workspace. VS Code Copilot uses this index to help developers find the correct tables for their features. When combined with `list_charts`, the toolset gives Copilot complete visibility into your BI assets. Your team can quickly identify existing charts and avoid creating duplicate queries with this MCP Server.

Setup guide

Set up Apache Superset MCP in VS Code Copilot

Prerequisites

VS Code 1.99 or later with GitHub Copilot extension
Active Vinkius subscription with a valid endpoint token

1

Open MCP configuration

Open the Command Palette (Cmd+Shift+P / Ctrl+Shift+P) and run "MCP: Add Server". Select HTTP (Streamable) as the server type. VS Code will create .vscode/mcp.json in your workspace.
2

Add the Apache Superset MCP

Paste the JSON snippet shown on the right into your .vscode/mcp.json. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Switch to Agent mode

Open Copilot Chat (Cmd+Shift+I / Ctrl+Shift+I) and switch to Agent mode using the dropdown. MCP tools are only available in Agent mode — they do not appear in Edit or Ask modes.
4

Verify the connection

In the Copilot Chat input, type # to list available tools. You should see the Apache Superset tools listed. Try asking: "List my recent Apache Superset transactions" and Copilot will invoke them automatically.

.vscode/mcp.json

{
  "mcpServers": {
    "apache-superset-mcp": {
      "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    }
  }
}

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Apache Superset. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect Apache Superset now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about Apache Superset MCP in VS Code Copilot

You ask VS Code Copilot to run a query, and it calls the `execute_sql_query` tool with your database ID. The raw results are returned directly into your Copilot Chat window.

Yes, Copilot can use `get_dashboard_details` and `list_dashboards` to inspect your BI layout. It can then generate markdown documentation or schema maps directly in your workspace.

No, Copilot routes queries through your Superset instance via the MCP Server. Developers only need access to the server, which uses the central database connections already configured in Superset.

Yes, the `list_charts` tool lets Copilot search your entire chart inventory. You can find specific chart IDs and then use `get_chart_details` to inspect their underlying SQL over MCP.

Yes, all communication between VS Code Copilot and your Superset instance is routed through your local environment or secure team proxy. Your SQL queries, dataset schemas, and chart configurations are processed in memory and are not stored by the MCP Server.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript