PyPI

Configure the Superset MCP server on a PyPI installation. Both Superset and the MCP server read the same superset_config.py.

Prerequisites

Complete the PyPI installation guide first — you should already have a virtual environment, superset_config.py, and Superset running via run_superset.sh.

1. Install fastmcp

Activate the Python environment you created during installation, then install the MCP dependency:

source /app/superset/superset_env/bin/activate
pip install "fastmcp>=3.2.4,<4.0"

2. Configure MCP in superset_config.py

Add the following to superset_config.py:

MCP_SERVICE_HOST = "0.0.0.0"
MCP_SERVICE_PORT = 5008
MCP_DEV_USERNAME = "admin"  # development only

Production deployments

For non-dev environments, disable MCP_DEV_USERNAME and use HS256 with shared secret instead.

3. Create a startup script

Make sure Superset is already running with run_superset.sh. In a separate terminal, start the MCP server.

Create run_superset_mcp.sh:

nano run_superset_mcp.sh

Paste the following:

#!/bin/bash
export SUPERSET_CONFIG_PATH=/app/superset/superset_config.py
source /app/superset/superset_env/bin/activate
superset mcp run --host 0.0.0.0 --port 5008

Grant execute permission and run it:

chmod +x run_superset_mcp.sh
./run_superset_mcp.sh

4. Verify the connection

The MCP endpoint is available at:

http://<your-server-ip>:5008/mcp

If the server starts without errors, connect an AI client — see Claude or Cursor for next steps.

Development only

MCP_DEV_USERNAME impersonates a fixed Superset user without token validation. Never use this setting in production.