WIP: MCP Server Superset

What is WIP: MCP Server Superset?

WIP: MCP Server Superset is a Model Context Protocol (MCP) server built on the Apache Superset REST API. It allows large language models to perform basic database queries, such as querying databases, tables, fields, and executing SQL.

How to use WIP: MCP Server Superset?

Use npx -y https://github.com/LiusCraft/superset-mcp-server and set the environment variables SUPERSET_URL, SUPERSET_USERNAME, SUPERSET_PASSWORD. Authentication is via LDAP. Alternatively, clone the repo, install dependencies with npm install, then run npm run build followed by npm start for production.

Key features of WIP: MCP Server Superset

• Query databases via Apache Superset
• Query tables from connected databases
• Query fields (columns) of tables
• Execute SQL statements through the MCP interface

Use cases of WIP: MCP Server Superset

• Allow an LLM to explore available databases in Superset
• Let an LLM retrieve table schemas for analysis
• Enable natural-language-driven SQL query execution on Superset
• Integrate Superset data access into AI-powered workflows

FAQ from WIP: MCP Server Superset

What does WIP: MCP Server Superset do?

It acts as an MCP server that exposes Apache Superset’s database query capabilities to large language models, enabling them to list databases, tables, fields, and execute SQL.

What are the runtime requirements?

Node.js version 14.0.0 or higher is required.

How does authentication work?

Authentication uses LDAP. You must provide SUPERSET_URL, SUPERSET_USERNAME, and SUPERSET_PASSWORD as environment variables.

How do I start the server?

For production, run npm run build and then npm start. For testing, use npm run src/examples/superset-example.ts or npm run inspector for debugging.

Is this project ready for production?

The README indicates it is a work in progress (WIP). The server is functional but may still be under development.