How to Use the Apache Superset MCP in Mastra AI

Build automated BI workflows in Mastra AI that execute SQL and manage dashboard data.

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 Mastra AI

Create your Vinkius account to connect Apache Superset to Mastra AI 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 Mastra AI

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Automate SQL Lab tasks in Mastra AI agents

Add `execute_sql_query` to your agent tools to handle data extraction tasks. If a query fails, your Mastra workflow can catch the error and retry it with different parameters. This turns your BI process into a repeatable pipeline. Your agent handles the logic of running the query, checking the results, and deciding the next step.

Monitor BI health with dashboard tools

Use `list_dashboards` and `get_dashboard_details` to build a monitoring agent. This agent can crawl your BI setup and flag missing datasets or broken charts. Your workflow keeps tabs on your environment. It acts as an automated auditor that reports back whenever a key metric drops below a threshold.

Map your data landscape automatically

Hook up `list_datasets` and `list_databases` to define your agent's knowledge base. Your agent learns what tables exist before it ever attempts to write a query. This prevents hallucinated SQL. The agent verifies the table schema and availability through the tool before it tries to pull any data.

Setup guide

Set up Apache Superset MCP in Mastra AI

Prerequisites

Node.js 18+ and a TypeScript project
@mastra/mcp + @mastra/core packages
Active Vinkius subscription with a valid endpoint token

1

Install dependencies
Run npm install @mastra/mcp @mastra/core plus your preferred model provider (e.g. @ai-sdk/openai).
2

Configure the MCPClient
Create an MCPClient with your Vinkius endpoint as a URL object. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com.
3

Discover and inject tools
Call mcpClient.listTools() and spread the result into your agent's tools object. All Apache Superset tools become native Mastra tools.
4

Run with any model
Swap openai("gpt-4o") for any AI SDK-compatible provider. Call agent.generate() and the agent routes tool calls through MCP automatically.

agent.ts

import { MCPClient } from "@mastra/mcp";
import { Agent } from "@mastra/core/agent";
import { openai } from "@ai-sdk/openai";

const mcpClient = new MCPClient({
  id: "apache-superset-mcp-client",
  servers: {
    "apache-superset-mcp": {
      url: new URL(
        "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
      ),
    },
  },
});

const agent = new Agent({
  name: "Apache Superset Agent",
  model: openai("gpt-4o"),
  instructions: "You have access to Apache Superset tools.",
  tools: {
    ...(await mcpClient.listTools()),
  },
});

const result = await agent.generate(
  "List recent Apache Superset transactions"
);
console.log(result.text);

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 Mastra AI

Initialize the MCP client in your agent configuration. Spread the tools into your agent definition so the workflow engine can call them during execution.

The current toolset focuses on read and query operations. You can use the agent to pull data and trigger downstream processes, but it does not modify dashboard configurations.

Mastra uses its built-in workflow engine to catch failures. You can define retry policies with exponential backoff if a query times out.

Yes, as long as the Vinkius server can reach your instance. The traffic stays within the secure sandbox environment.

The server keeps your credentials isolated in a secure vault. Mastra agents only receive the output of authorized queries, never the underlying connection secrets.

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