Spark SQL

Databases Python v0.1.2

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

View source ↗ Generate config for multiple servers More servers

Install

Pin version registry version 0.1.2

Python
uvx spark-sql-mcp-server

Python
uvx spark-sql-mcp-server@0.1.2

Setup by client

Pick your client — the config below is generated for this server (local stdio). Copy respects the “Pin version” switch above.

claude_desktop_config.json

{
  "mcpServers": {
    "spark-sql-mcp-server": {
      "command": "uvx",
      "args": [
        "spark-sql-mcp-server"
      ],
      "env": {
        "SPARK_HOST": "<YOUR_SPARK_HOST>",
        "SPARK_PASSWORD": "<YOUR_SPARK_PASSWORD>"
      }
    }
  }
}

{
  "mcpServers": {
    "spark-sql-mcp-server": {
      "command": "uvx",
      "args": [
        "spark-sql-mcp-server@0.1.2"
      ],
      "env": {
        "SPARK_HOST": "<YOUR_SPARK_HOST>",
        "SPARK_PASSWORD": "<YOUR_SPARK_PASSWORD>"
      }
    }
  }
}

Format verified against the official Claude Desktop docs ↗.

terminal

claude mcp add --env SPARK_HOST=<YOUR_SPARK_HOST> --env SPARK_PASSWORD=<YOUR_SPARK_PASSWORD> spark-sql-mcp-server -- uvx spark-sql-mcp-server

claude mcp add --env SPARK_HOST=<YOUR_SPARK_HOST> --env SPARK_PASSWORD=<YOUR_SPARK_PASSWORD> spark-sql-mcp-server -- uvx spark-sql-mcp-server@0.1.2

Format verified against the official Claude Code docs ↗.

.cursor/mcp.json

{
  "mcpServers": {
    "spark-sql-mcp-server": {
      "command": "uvx",
      "args": [
        "spark-sql-mcp-server"
      ],
      "env": {
        "SPARK_HOST": "<YOUR_SPARK_HOST>",
        "SPARK_PASSWORD": "<YOUR_SPARK_PASSWORD>"
      }
    }
  }
}

{
  "mcpServers": {
    "spark-sql-mcp-server": {
      "command": "uvx",
      "args": [
        "spark-sql-mcp-server@0.1.2"
      ],
      "env": {
        "SPARK_HOST": "<YOUR_SPARK_HOST>",
        "SPARK_PASSWORD": "<YOUR_SPARK_PASSWORD>"
      }
    }
  }
}

Format verified against the official Cursor docs ↗.

.vscode/mcp.json

{
  "servers": {
    "spark-sql-mcp-server": {
      "command": "uvx",
      "args": [
        "spark-sql-mcp-server"
      ],
      "env": {
        "SPARK_HOST": "<YOUR_SPARK_HOST>",
        "SPARK_PASSWORD": "<YOUR_SPARK_PASSWORD>"
      }
    }
  }
}

{
  "servers": {
    "spark-sql-mcp-server": {
      "command": "uvx",
      "args": [
        "spark-sql-mcp-server@0.1.2"
      ],
      "env": {
        "SPARK_HOST": "<YOUR_SPARK_HOST>",
        "SPARK_PASSWORD": "<YOUR_SPARK_PASSWORD>"
      }
    }
  }
}

Format verified against the official VS Code docs ↗.

mcp_config.json

{
  "mcpServers": {
    "spark-sql-mcp-server": {
      "command": "uvx",
      "args": [
        "spark-sql-mcp-server"
      ],
      "env": {
        "SPARK_HOST": "<YOUR_SPARK_HOST>",
        "SPARK_PASSWORD": "<YOUR_SPARK_PASSWORD>"
      }
    }
  }
}

{
  "mcpServers": {
    "spark-sql-mcp-server": {
      "command": "uvx",
      "args": [
        "spark-sql-mcp-server@0.1.2"
      ],
      "env": {
        "SPARK_HOST": "<YOUR_SPARK_HOST>",
        "SPARK_PASSWORD": "<YOUR_SPARK_PASSWORD>"
      }
    }
  }
}

Format verified against the official Windsurf docs ↗.

Environment variables

Defined in the server's official registry manifest. Required secrets are shown as <YOUR_…> placeholders in the configs above.

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)

GitHub

⭐ 1 stars · 最近更新于 231 天前 · MIT license

About this server

Distributed as Python, listed under Databases. Review our MCP security guide before granting access to real data.

Frequently asked questions

How do I install Spark SQL?

Run the install command shown above, then paste the config for your client (Claude Desktop, Claude Code, Cursor, VS Code or Windsurf) into its MCP settings and restart the client.

Is Spark SQL free to use?

The MCP server itself is free to install. The source is public on https://github.com/aidancorrell/spark-sql-mcp-server. Any third-party service it calls may require its own API key and account.

Which clients support Spark SQL?

Any MCP-compatible client can use it, including Claude Desktop, Claude Code, Cursor, VS Code, Windsurf and custom agents.

Add this badge

Publish this server? Link back with a badge on your README or site — copy either snippet.

Markdown

[![Listed on MCPNav](https://mcpnav.net/badge/spark-sql-mcp-server.svg)](https://mcpnav.net/server/spark-sql-mcp-server/)

HTML

<a href="https://mcpnav.net/server/spark-sql-mcp-server/"><img src="https://mcpnav.net/badge/spark-sql-mcp-server.svg" alt="Listed on MCPNav" height="20"></a>