MCP server for querying Spark SQL via Thrift/HiveServer2 protocol
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add spark-sql --env SPARK_HOST='<SPARK_HOST>' --env SPARK_PASSWORD='<SPARK_PASSWORD>' -- uvx spark-sql-mcp-server~/.codex/config.toml
[mcp_servers.spark-sql]
command = "uvx"
args = ["spark-sql-mcp-server"]
env = { SPARK_HOST = "<SPARK_HOST>", SPARK_PASSWORD = "<SPARK_PASSWORD>" }
# codex mcp add spark-sql --env SPARK_HOST='<SPARK_HOST>' --env SPARK_PASSWORD='<SPARK_PASSWORD>' -- uvx spark-sql-mcp-server~/.cursor/mcp.json
{
"mcpServers": {
"spark-sql": {
"command": "uvx",
"args": [
"spark-sql-mcp-server"
],
"env": {
"SPARK_HOST": "<SPARK_HOST>",
"SPARK_PASSWORD": "<SPARK_PASSWORD>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"spark-sql": {
"type": "stdio",
"command": "uvx",
"args": [
"spark-sql-mcp-server"
],
"env": {
"SPARK_HOST": "<SPARK_HOST>",
"SPARK_PASSWORD": "<SPARK_PASSWORD>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"spark-sql": {
"command": "uvx",
"args": [
"spark-sql-mcp-server"
],
"env": {
"SPARK_HOST": "<SPARK_HOST>",
"SPARK_PASSWORD": "<SPARK_PASSWORD>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"spark-sql": {
"command": "uvx",
"args": [
"spark-sql-mcp-server"
],
"env": {
"SPARK_HOST": "<SPARK_HOST>",
"SPARK_PASSWORD": "<SPARK_PASSWORD>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"spark-sql": {
"command": "uvx",
"args": [
"spark-sql-mcp-server"
],
"env": {
"SPARK_HOST": "<SPARK_HOST>",
"SPARK_PASSWORD": "<SPARK_PASSWORD>"
}
}
}
}Environment variables
SPARK_HOSTSPARK_PASSWORD
Replace the placeholders with your own credentials and keep them out of version control.