• DATABASE
  • DATASET
  • SCHEMA
  • HUMAN

How to inventory data sources with your AI

Connect your AI to Superset to see what data is available. Your agent handles the scanning of your connections.

Ask AI about this page

Short answer

How can I list all my Superset databases and datasets?

Your AI uses specific tools to scan your Superset instance and return a list of every connected database and dataset. You'll get a clear map of your data environment.

The inventory results.

Where your data map lands.

Once connected, your AI organizes your Superset environment into these views.

DATABASE

Connection list

The AI identifies every database engine linked to Superset. You get a clean list of where your data lives.

DATASET

Available datasets

Your agent pulls a list of all registered datasets. This shows you which tables and views are ready for use.

SCHEMA

Structural overview

The AI maps the relationship between your databases and the datasets they host. This helps you understand your data hierarchy.

HUMAN

Manual verification

You decide which datasets are relevant for your specific tasks. The AI provides the list, but you control the actual data usage.

The workflow

What your AI does when the request arrives.

The AI moves through your Superset instance to build a real-time inventory.

  1. Scan connections

    The AI looks through your Superset instance to find every active database connection.

    list_databases

  2. Identify datasets

    After finding the databases, the agent looks for all datasets associated with those connections.

    list_datasets

  3. Map relationships

    The AI links specific datasets back to their parent databases to provide context.

    list_databaseslist_datasets

  4. Present inventory

    Your agent delivers a structured summary of the data landscape to your chat interface.

    list_datasets

Try it

Copy these to start.

Use these prompts to begin your inventory.

Starting points

These are opening lines. You can swap in specific database names or dataset types to get more targeted results.

Apache Superset Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_gwYe1NYA9B8gFp8lQ7hoG8Zq04EdrBNzR1eq1ypu/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — Apache Superset capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "apache-superset-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_gwYe1NYA9B8gFp8lQ7hoG8Zq04EdrBNzR1eq1ypu/mcp"
    }
  }
}
Copy into chat04

  • List all the databases connected to my Superset instance.

  • Show me all the datasets available in the production database.

  • Which datasets are currently available in Superset?

  • Give me a list of all databases and their associated datasets.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect Apache Superset once, then ask.

Just link your account once. Your credentials stay encrypted, and you can immediately start asking your AI about your data.

Connect Apache Superset to your AI

FAQ

How this task behaves.

  • 01

    Can the AI delete a database in Superset?

    No. The AI only has tools to list databases and datasets. It cannot modify or delete anything in your Superset instance.

  • 02

    Does the AI see my raw data rows?

    No. These tools only allow the AI to see metadata, such as database names and dataset names, not the actual data inside the tables.

  • 03

    Can I ask the AI to create a new dataset?

    No. The current tools are limited to listing existing databases and datasets.

  • 04

    How often does the AI refresh the list?

    The AI pulls a fresh list every time you ask. It does not rely on a cached version of your inventory.

  • 05

    Will the AI change my Superset permissions?

    No. The AI has no capability to change user roles or permissions within Superset.

  • More questions about Apache Superset? The Connector page answers them. See everything the Apache Superset Connector can do

Connect Apache Superset to Claude, Cursor, ChatGPT & more