How to Use the Apache Superset MCP in Vercel AI SDK

Stream Apache Superset analytics directly into your Vercel AI SDK frontends for live data visualization.

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 Vercel AI SDK

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

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Run live SQL queries in your React components

Trigger `execute_sql_query` to fetch raw database results without leaving your app logic. Your frontend receives the data chunk by chunk, letting you populate charts the second the database responds. Stop waiting for full page loads. By binding this tool to your streamText calls, you show users the data as it arrives, making your dashboard feel instant.

Pull dashboard metadata for dynamic layouts

Use `list_dashboards` and `get_dashboard_details` to map out your BI structure on the fly. Your code parses the JSON response to render cards that match your actual Superset layout. Keep your UI in sync with your BI team. When they update a dashboard, your frontend pulls the latest definition automatically, preventing stale views.

Browse data sources from your edge functions

Call `list_datasets` and `list_databases` to see what information you have access to. This helps you build context-aware inputs where the user picks a table from a list you generated. Your edge functions hit the API directly. This keeps sensitive database credentials off your client-side code while still letting you query your warehouse.

Setup guide

Set up Apache Superset MCP in Vercel AI SDK

Prerequisites

Node.js 18+ and a TypeScript project
ai + @modelcontextprotocol/sdk packages
Active Vinkius subscription with a valid endpoint token

1

Install dependencies

Run npm install ai @modelcontextprotocol/sdk plus your preferred model provider (e.g. @ai-sdk/openai).
2

Create the Streamable HTTP transport

Use StreamableHTTPClientTransport with your Vinkius endpoint URL. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com.
3

Discover and use tools

Call mcpClient.tools() to auto-discover all Apache Superset tools. Pass them directly to generateText() or streamText() — no manual schema definitions needed.
4

Works with any model provider

Swap openai("gpt-4o") for any AI SDK provider — Anthropic, Google, Mistral. The MCP tools work identically across all supported models.

index.ts

import { experimental_createMCPClient as createMCPClient } from "ai";
import { StreamableHTTPClientTransport } from "@modelcontextprotocol/sdk/client/streamableHttp";
import { generateText } from "ai";
import { openai } from "@ai-sdk/openai";

const transport = new StreamableHTTPClientTransport(
  new URL("https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp")
);

const mcpClient = await createMCPClient({ transport });
const tools = await mcpClient.tools();

const { text } = await generateText({
  model: openai("gpt-4o"),
  tools,
  prompt: "List recent Apache Superset transactions",
});

console.log(text);
await mcpClient.close();

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 Vercel AI SDK

Install the MCP client package via npm and initialize it with your Vinkius endpoint. Pass the tools directly into your generateText call to start querying your data.

Yes, use the chart tools to pull the definition and data. You then map those results to your preferred graphing library in your component.

The SDK handles the stream and manages the connection state. You can show loading states or skeletons while the data arrives over the HTTP transport.

No, the server handles connections internally. You only provide the Superset URL and your auth token.

Vinkius runs the server in an ephemeral sandbox. Your database credentials never touch your local machine or the client-side browser.

Use it with your favorite AI tools

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