Spark SQL MCP Server

Name: Spark SQL MCP Server
Author: io.github.aidancorrell

io.github.aidancorrell/spark-sql-mcp-server

Repository Registry

What is the Spark SQL MCP server?

Query Spark SQL clusters via Thrift/HiveServer2. Works with Spark, EMR, Hive, Impala.

How to install Spark SQL

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

SPARK_HOST
required
Hostname of the Spark Thrift Server
SPARK_PORT
Port of the Spark Thrift Server (default: 10000)
SPARK_DATABASE
Default database to use
SPARK_AUTH
Authentication method: NONE, LDAP, KERBEROS, CUSTOM, or NOSASL
SPARK_USERNAME
Username for LDAP authentication
SPARK_PASSWORD
secret
Password for LDAP authentication
SPARK_KERBEROS_SERVICE_NAME
Kerberos service name (default: hive)

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "spark-sql-mcp-server": {
      "command": "uvx",
      "args": [
        "spark-sql-mcp-server"
      ],
      "env": {
        "SPARK_HOST": "<YOUR_SPARK_HOST>",
        "SPARK_PORT": "<YOUR_SPARK_PORT>",
        "SPARK_DATABASE": "<YOUR_SPARK_DATABASE>",
        "SPARK_AUTH": "<YOUR_SPARK_AUTH>",
        "SPARK_USERNAME": "<YOUR_SPARK_USERNAME>",
        "SPARK_PASSWORD": "<YOUR_SPARK_PASSWORD>",
        "SPARK_KERBEROS_SERVICE_NAME": "<YOUR_SPARK_KERBEROS_SERVICE_NAME>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "spark-sql-mcp-server": {
      "command": "uvx",
      "args": [
        "spark-sql-mcp-server"
      ],
      "env": {
        "SPARK_HOST": "<YOUR_SPARK_HOST>",
        "SPARK_PORT": "<YOUR_SPARK_PORT>",
        "SPARK_DATABASE": "<YOUR_SPARK_DATABASE>",
        "SPARK_AUTH": "<YOUR_SPARK_AUTH>",
        "SPARK_USERNAME": "<YOUR_SPARK_USERNAME>",
        "SPARK_PASSWORD": "<YOUR_SPARK_PASSWORD>",
        "SPARK_KERBEROS_SERVICE_NAME": "<YOUR_SPARK_KERBEROS_SERVICE_NAME>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "spark-sql-mcp-server": {
      "command": "uvx",
      "args": [
        "spark-sql-mcp-server"
      ],
      "env": {
        "SPARK_HOST": "<YOUR_SPARK_HOST>",
        "SPARK_PORT": "<YOUR_SPARK_PORT>",
        "SPARK_DATABASE": "<YOUR_SPARK_DATABASE>",
        "SPARK_AUTH": "<YOUR_SPARK_AUTH>",
        "SPARK_USERNAME": "<YOUR_SPARK_USERNAME>",
        "SPARK_PASSWORD": "<YOUR_SPARK_PASSWORD>",
        "SPARK_KERBEROS_SERVICE_NAME": "<YOUR_SPARK_KERBEROS_SERVICE_NAME>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "spark-sql-mcp-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "spark-sql-mcp-server"
      ],
      "env": {
        "SPARK_HOST": "<YOUR_SPARK_HOST>",
        "SPARK_PORT": "<YOUR_SPARK_PORT>",
        "SPARK_DATABASE": "<YOUR_SPARK_DATABASE>",
        "SPARK_AUTH": "<YOUR_SPARK_AUTH>",
        "SPARK_USERNAME": "<YOUR_SPARK_USERNAME>",
        "SPARK_PASSWORD": "<YOUR_SPARK_PASSWORD>",
        "SPARK_KERBEROS_SERVICE_NAME": "<YOUR_SPARK_KERBEROS_SERVICE_NAME>"
      }
    }
  }
}

Claude Code

claude mcp add spark-sql-mcp-server --env SPARK_HOST=<YOUR_SPARK_HOST> --env SPARK_PORT=<YOUR_SPARK_PORT> --env SPARK_DATABASE=<YOUR_SPARK_DATABASE> --env SPARK_AUTH=<YOUR_SPARK_AUTH> --env SPARK_USERNAME=<YOUR_SPARK_USERNAME> --env SPARK_PASSWORD=<YOUR_SPARK_PASSWORD> --env SPARK_KERBEROS_SERVICE_NAME=<YOUR_SPARK_KERBEROS_SERVICE_NAME> -- uvx spark-sql-mcp-server