MCP Connector

Analyze Spark Job Performance with AI

Official Kubeflow MCP server exposing Apache Spark History Server data - 19 tools for job, stage, SQL, and bottleneck analysis.

Works with githubhelmpypi

Maintainer of this project? Claim this page to edit the listing.


91
Spark score
out of 100
Updated last month
Version cli/v0.3.0
Models
universal

Add to Favorites

Why it matters

Leverage AI to analyze Apache Spark job performance, identify bottlenecks, and gain intelligent insights from Spark History Server data. This connector enables deeper understanding and optimization of Spark workloads.

Outcomes

What it gets done

01

Query Spark job information and performance metrics via natural language.

02

Analyze and compare multiple Spark jobs to identify performance regressions.

03

Investigate job failures and stage-level performance issues with detailed error analysis.

04

Generate insights and timelines of resource usage for Spark applications.

Install

Add it to your toolbox

Run in your project directory:

curl -fsSL https://spark.entire.vc/get/vb-kubeflow-spark-history-mcp-server | bash

Capabilities

Tools your agent gets

list_applications

Get a list of all applications available on Spark History Server with optional filtering

get_application

Get detailed information about a specific Spark application including status and resource usage

list_jobs

Get a list of all jobs for a Spark application with optional filtering by status

list_slowest_jobs

Get the N slowest jobs for a Spark application excluding running jobs by default

list_stages

Get a list of all stages for a Spark application with optional filtering by status

list_slowest_stages

Get the N slowest stages for a Spark application excluding running stages by default

get_stage

Get information about a specific stage with optional attempt ID and summary metrics

get_stage_task_summary

Get statistical distributions of task metrics for a specific stage including execution time

+7 tools

Overview

Kubeflow Spark History MCP Server

Kubeflow Spark AI Toolkit's MCP server exposes 19 tools for investigating Apache Spark jobs, stages, executors, SQL executions, and bottlenecks, with a companion CLI for scripts. Use it for conversational Spark job investigation and performance comparison via AI agents; requires a running Spark History Server, and AWS tools need AWS credentials configured.

What it does

Kubeflow Spark AI Toolkit's MCP server connects AI agents to Apache Spark History Server for job analysis, performance monitoring, and failure investigation. It exposes 19 tools across application info, job/stage analysis, executor/resource analysis, environment/config inspection, SQL execution analysis, bottleneck detection, and comparative analysis between two applications, stages, or SQL executions. It also ships guided multi-step "prompts" (e.g. investigate_failure) runnable as a single command in Claude Code or Kiro CLI, and optional AWS-specific troubleshooting tools (aws_analyze_spark_workload, aws_spark_code_recommendation) that activate automatically when AWS credentials are configured.

A companion standalone Go CLI (shs) provides the same Spark History Server querying directly from the terminal or scripts, without MCP - useful for CI/CD or as a skill file for coding agents. Multiple Spark History Servers can be configured and targeted by name in a single setup (e.g. "get application X from the production server").

When to use - and when NOT to

Use the MCP server when you want an AI agent to conduct multi-step Spark investigations conversationally - "why is my ETL job running slower than yesterday?" resolves to get_job_bottlenecks + list_stages + compare_job_performance automatically. Use the shs CLI instead for scripts, CI/CD pipelines, or when you already know the exact command to run.

Do not expect AWS troubleshooting tools to be available without AWS credentials and region configured - they're opt-in and require IAM setup. The MCP server needs a running Spark History Server (default http://localhost:18080) to connect to.

Inputs and outputs

Tools take application IDs, job/stage/executor IDs, optional status/date filters, and sort order. Comparison tools take two application, stage, or SQL execution identifiers. Outputs are structured job/stage/executor metrics, SQL execution plans and performance metrics, environment/config dumps, bottleneck analyses, or diffs between two runs.

Capabilities

  • list_applications: list/detail applications with status, date, and attempt info
  • list_jobs, list_stages/get_stage/list_stage_task_failures: job and stage-level analysis
  • list_executors/get_executor_summary/get_resource_usage_timeline/get_executor_thread_dump: executor and resource analysis
  • get_environment: Spark config, JVM info, system properties, classpath
  • list_sql_executions/get_sql_execution/compare_sql_executions: SQL query analysis and comparison
  • get_job_bottlenecks: identify bottlenecks across stages, tasks, executors
  • compare_job_environments/compare_job_performance/compare_stages: diff two applications or stages
  • aws_analyze_spark_workload/aws_spark_code_recommendation (opt-in): AWS-specific root-cause analysis and fix recommendations

How to install

uvx --from mcp-apache-spark-history-server spark-mcp

For Claude Code:

claude mcp add --env SHS_MCP__TRANSPORT=stdio --env SHS_SERVERS__LOCAL__URL=http://localhost:18080 \
  --transport stdio spark-history -- uvx --from mcp-apache-spark-history-server spark-mcp

Requires Python 3.12+ and uv. Configure additional servers via a config file or SHS_SERVERS__*__URL environment variables.

Who it's for

Data engineers and platform teams running Apache Spark who want an AI agent to investigate slow jobs, failures, and performance regressions conversationally.

Source README

Kubeflow Spark AI Toolkit

CI
Python 3.12+
MCP
License
Kubeflow
Slack

Connect AI agents and engineers to Apache Spark History Server for intelligent job analysis, performance monitoring, and investigation



This project provides two interfaces to your Spark History Server data:

πŸ› οΈ SHS CLI (shs) ⚑ MCP Server
For Engineers, shell scripts, CI/CD, coding agents AI agents and MCP-compatible clients
Mental model "I know the command I want to run" "Agent, investigate this Spark app"
Install Single static binary - no dependencies Python 3.12+, uv
Get started CLI docs β†’ MCP docs β†’

πŸ“Ί See it in action:
Watch the demo video


πŸ› οΈ SHS CLI (shs) - For Engineers & Scripts

A standalone Go binary. Query your Spark History Server directly from the terminal, shell scripts, or CI/CD pipelines. Also works as a skill for coding agents like Claude Code and Kiro.

Install

# Auto-detect latest version, OS, and architecture
VERSION=$(curl -s https://api.github.com/repos/kubeflow/mcp-apache-spark-history-server/releases | grep -m1 '"tag_name": "cli/' | cut -d'"' -f4 | sed 's|cli/||')
OS=$(uname -s | tr '[:upper:]' '[:lower:]')
ARCH=$(uname -m)
[ "$ARCH" = "x86_64" ] && ARCH="amd64"
[ "$ARCH" = "aarch64" ] && ARCH="arm64"

curl -sSL "https://github.com/kubeflow/mcp-apache-spark-history-server/releases/download/cli%2F${VERSION}/shs-${VERSION}-${OS}-${ARCH}.tar.gz" | tar xz
sudo mv shs /usr/local/bin/

Quick Start

# Generate a config file
shs setup config > config.yaml   # then set your Spark History Server URL

# Explore applications
shs apps
shs jobs -a APP_ID --status failed
shs stages -a APP_ID --sort duration
shs compare apps --app-a APP1 --app-b APP2

# Use as a skill with Claude Code or Kiro
shs setup skill > ~/.claude/skills/spark-history.md

CLI documentation for full usage, or check out a real-world example of Claude Code comparing two TPC-DS 3TB benchmark runs.


⚑ MCP Server - For AI Agents

An MCP (Model Context Protocol) server that exposes Spark History Server data as tools for AI agents. Agents query your Spark infrastructure using natural language - the server handles tool selection, multi-server routing, and structured data retrieval.

Use the MCP server when you want an AI agent to conduct multi-step investigations, synthesize findings across tools, or answer natural-language questions about your Spark applications.

Install

# Run directly with uvx (no install needed)
uvx --from mcp-apache-spark-history-server spark-mcp

# Or install with pip
uv tool install mcp-apache-spark-history-server
spark-mcp

The package is published to PyPI.

Coding Agent Integration

Register the server with a single command. Both examples run it over stdio via uvx.
With no config file present, the server defaults to a Spark History Server at http://localhost:18080;
point it elsewhere with a config file or SHS_SERVERS__LOCAL__URL.

Claude Code (claude mcp add):

claude mcp add --env SHS_MCP__TRANSPORT=stdio --env SHS_SERVERS__LOCAL__URL=http://localhost:18080\
  --transport stdio spark-history \
  -- uvx --from mcp-apache-spark-history-server spark-mcp

Kiro CLI (kiro-cli mcp add):

kiro-cli mcp add --name spark-history --command uvx \
  --args --from --args mcp-apache-spark-history-server --args spark-mcp \
  --env SHS_MCP__TRANSPORT=stdio --env SHS_SERVERS__LOCAL__URL=http://localhost:18080

Verify in either client with claude mcp list / kiro-cli mcp list, then ask the agent to "list the available Spark applications."

The server also ships prompts - guided, multi-step workflows you run as a command. In Claude Code: /mcp__spark-history__investigate_failure <app_id>. In Kiro CLI: /prompts investigate_failure (or @investigate_failure). See Prompts for the full list and arguments.

Passing server flags and environment

The commands above have two layers: the client's own options and the arguments/environment forwarded to spark-mcp. spark-mcp itself takes a single flag, --config / -c; everything else is set through SHS_* environment variables.

To pass to spark-mcp… Claude Code Kiro CLI
A flag (e.g. --config) append after --: … spark-mcp --config /path/config.yaml add --args pairs: --args --config --args /path/config.yaml
An environment variable --env KEY=value (before --transport) --env KEY=value

For example, to point at a remote Spark History Server with an explicit config file:

# Claude Code
claude mcp add --env SHS_MCP__TRANSPORT=stdio --transport stdio spark-history \
  -- uvx --from mcp-apache-spark-history-server spark-mcp --config ~/.config/spark-mcp/config.yaml

# Kiro CLI
kiro-cli mcp add --name spark-history --command uvx \
  --args --from --args mcp-apache-spark-history-server --args spark-mcp \
  --args --config --args ~/.config/spark-mcp/config.yaml \
  --env SHS_MCP__TRANSPORT=stdio

Configure

Basic configuration below. Create a file named config.yaml:

servers:
  local:
    default: true
    url: "http://your-spark-history-server:18080"
    auth:            # optional
      username: "user"
      password: "pass"
    include_plan_description: false   # include SQL plans by default (default: false)
mcp:
  transport: "streamable-http"   # or: stdio
  port: "18888"
  debug: false
Config file location

The server looks for its config file in the following order and uses the first one it finds:

  1. The --config / -c flag (e.g. spark-mcp --config /path/to/config.yaml)
  2. The SHS_MCP_CONFIG environment variable
  3. ./config.yaml in the current working directory
  4. ~/.config/spark-mcp/config.yaml (honors $XDG_CONFIG_HOME when set)

If none exist, the server starts with built-in defaults that can be overridden by SHS_* environment variables. When a path is given explicitly via the flag or SHS_MCP_CONFIG but the file is missing, the server fails fast instead of falling back.

Tip for MCP clients: when the server is launched by an MCP client (Claude Desktop, Kiro, etc.), the working directory is not guaranteed, so a ./config.yaml may not be found. Prefer --config / SHS_MCP_CONFIG, or place the file at ~/.config/spark-mcp/config.yaml.

Configurations can be overriden with environment variables. Nesting levels are
separated by a double underscore (__), so field names and server names may
themselves contain single underscores (e.g. SHS_SERVERS__MY_SERVER__URL maps
to servers.my_server.url).

SHS_MCP__PORT          Port for MCP server (default: 18888)
SHS_MCP__TRANSPORT     Transport mode: streamable-http or stdio
SHS_MCP__DEBUG         Enable debug mode (default: false)
SHS_MCP__ADDRESS       Bind address (default: localhost)
SHS_SERVERS__*__URL     URL for a specific server
SHS_SERVERS__*__AUTH__USERNAME
SHS_SERVERS__*__AUTH__PASSWORD
SHS_SERVERS__*__AUTH__TOKEN
SHS_SERVERS__*__VERIFY_SSL
SHS_SERVERS__*__TIMEOUT
SHS_SERVERS__*__EMR_CLUSTER_ARN
SHS_SERVERS__*__INCLUDE_PLAN_DESCRIPTION

Multi-Server Setup

Configure multiple Spark History Servers and route queries to specific ones:

servers:
  production:
    default: true
    url: "http://prod-spark-history:18080"
    auth:
      username: "user"
      password: "pass"
  staging:
    url: "http://staging-spark-history:18080"

Agents can target a specific server per query:

"Get application <app_id> from the production server"

πŸ—οΈ Architecture

graph TB
    subgraph Clients
        A[πŸ€– AI Agent / LLM]
        B[πŸ‘©β€πŸ’» Engineer / Script / CI]
        C[πŸ”§ Coding Agent - Claude Code / Kiro]
    end

    subgraph "Kubeflow Spark AI Toolkit"
        D[⚑ MCP Server]
        E[πŸ› οΈ CLI - shs]
    end

    subgraph "Spark History Servers"
        F[πŸ”₯ Production]
        G[πŸ”₯ Staging / Dev]
    end

    A -->|MCP Protocol| D
    B -->|Terminal commands| E
    C -->|shs skill file| E

    D -->|REST API| F
    D -->|REST API| G
    E -->|REST API| F
    E -->|REST API| G

Connect an AI Agent

Agent Transport Guide
Claude Desktop stdio Setup β†’
Claude Code stdio or streamable-http Setup β†’
Kiro streamable-http Setup β†’
LangGraph streamable-http Setup β†’
Strands Agents streamable-http Setup β†’
Local / Inspector streamable-http Setup β†’

Available Tools (19)

Available Tools
Application Information
Tool Description
list_applications List applications with optional status, date, and limit filters; pass app_id for a single application's detail (status, resources, duration, attempts). Returned applications always include their attempts.
Job Analysis
Tool Description
list_jobs List jobs with status/job-id filtering and sorting (e.g. slowest by duration)
Stage Analysis
Tool Description
list_stages List stages with status filtering and sorting (e.g. slowest by duration)
get_stage Stage detail with attempt and task metric distributions
list_stage_task_failures Failed tasks of a stage with their error messages (exception/stack trace)
Executor & Resource Analysis
Tool Description
list_executors List executors with executor-id filtering and sorting (failed-tasks/duration/gc/id)
get_executor_summary Aggregate metrics across all executors
get_resource_usage_timeline Chronological executor add/remove with resource totals
get_executor_thread_dump JVM thread dump for a driver/executor, with state/name/blocked filters (running apps only)
Configuration & Environment
Tool Description
get_environment Spark config, JVM info, system properties, classpath; optional section filter to return a single part
SQL & Query Analysis
Tool Description
list_sql_executions List SQL executions as curated summaries, with status/description filters, sorting, and a default limit
get_sql_execution SQL execution header by default; opt-in plan, node metrics, job summaries, aggregated stage metrics, and stage list
compare_sql_executions Compare aggregated performance metrics (stages, tasks, shuffle, spill, GC) between two SQL executions; opt-in plan-structure diff
Performance & Bottleneck Analysis
Tool Description
get_job_bottlenecks Identify bottlenecks across stages, tasks, and executors
Comparative Analysis
Tool Description
compare_job_environments Diff Spark configs between two applications
compare_job_performance Diff performance metrics between two applications
compare_stages Compare two stages (optionally across applications): stage metrics and per-task p25/p50/p75/max quantiles
AWS Spark Troubleshooting (opt-in)
Tool Description
aws_analyze_spark_workload One-shot root cause analysis of failed/slow Spark workloads
aws_spark_code_recommendation Code fix recommendations for identified Spark issues

Automatically available when AWS credentials and region are configured. See IAM setup guide.

Example Agent Queries
  • "Why is my ETL job running slower than yesterday?" β†’ get_job_bottlenecks + list_stages + compare_job_performance
  • "What caused job 42 to fail?" β†’ list_jobs + get_stage
  • "Compare today's batch with yesterday's run" β†’ compare_job_performance + compare_job_environments
  • "Find my slowest SQL queries and explain why" β†’ list_sql_executions + get_sql_execution + compare_sql_executions

Prompts (2)

Beyond tools, the server exposes MCP prompts - reusable, multi-step investigation workflows that your agent runs as a single command. Each prompt expands into a guided sequence of tool calls (which the agent still executes one at a time), so you get a consistent, evidence-driven analysis without having to remember the right tool order.

Prompt Arguments Description
investigate_failure app_id (required), server (optional) Guided root-cause investigation for a failed Spark application - walks from the failed app down to the individual task exceptions.
compare_applications app_a (required), app_b (required), server (optional), context (optional) Layered, descriptive comparison of two applications (configuration β†’ app metrics β†’ SQL/jobs β†’ stages).

server is optional: when omitted, the prompt searches every configured server for the application(s). Pass server="<name>" only to target a specific server or disambiguate an id that exists on more than one.

Using prompts in Claude Code

MCP prompts surface as slash commands with the format /mcp__<server>__<prompt> (note the double underscores), where <server> is the name you registered the server under (spark-history in the examples above). Type / to discover them, then pass arguments space-separated after the command:

# Investigate a failed application
/mcp__spark-history__investigate_failure spark-cc4d615a5e6b4500b8eb1e9deb48cb4e

# Target a specific configured server
/mcp__spark-history__investigate_failure spark-cc4d615a5e6b4500b8eb1e9deb48cb4e production

# Compare two applications
/mcp__spark-history__compare_applications spark-app-A spark-app-B
Using prompts in Kiro CLI

List and run prompts with the /prompts command, or type @ then Tab to autocomplete. Run a prompt by name and supply its arguments:

# Open the prompt picker (shows prompts from all MCP servers)
/prompts

# Run a prompt directly
/prompts investigate_failure

# Or use the @ shortcut
@investigate_failure

Kiro CLI prompts you for arguments interactively when the prompt declares them, so you can run /prompts investigate_failure and provide app_id (and optionally server) when asked.


πŸ“Έ Screenshots

πŸ” Get Spark Application

⚑ Job Performance Comparison


πŸš€ Kubernetes Deployment

Deploy the MCP server using Helm:

helm install spark-history-mcp ./deploy/kubernetes/helm/mcp-apache-spark-history-server/

# Production configuration
helm install spark-history-mcp ./deploy/kubernetes/helm/mcp-apache-spark-history-server/ \
  --set replicaCount=3 \
  --set autoscaling.enabled=true

See deploy/kubernetes/helm/ for full configuration options.

When deployed in Kubernetes, connect Claude Desktop via mcp-remote:

kubectl port-forward svc/mcp-apache-spark-history-server 18888:18888

πŸ“” AWS Integration

  • AWS Glue - Connect to Glue Spark History Server
  • Amazon EMR - Use EMR Persistent UI for Spark analysis
  • AWS Spark Troubleshooting - One-shot root cause analysis and code fix recommendations for failed Spark workloads (EMR EC2, EMR Serverless). Automatically available when AWS credentials and region are configured. See IAM setup guide for required permissions.

πŸ”§ Development Setup

git clone https://github.com/kubeflow/mcp-apache-spark-history-server.git
cd mcp-apache-spark-history-server

# Install Task runner
brew install go-task   # macOS; see https://taskfile.dev/installation/ for others

# MCP Server
task install           # install Python dependencies
task start-spark-bg    # start Spark History Server with sample data
task start-mcp-bg      # start MCP server
task start-inspector-bg  # open MCP Inspector at http://localhost:6274
task stop-all

# CLI
cd skills/cli
task build             # build ./bin/shs
task test              # unit tests
task test-e2e          # e2e tests (starts/stops Docker SHS automatically)
task start-shs         # start SHS with CLI e2e sample data

🌍 Adopters

Using this project? Add your organization to ADOPTERS.md and help grow the community.

🀝 Contributing

See CONTRIBUTING.md for guidelines.

πŸ“„ License

Apache License 2.0 - see LICENSE.

πŸ“ Trademark Notice

Built for use with Apache Sparkβ„’ History Server. Not affiliated with or endorsed by the Apache Software Foundation.


Connect your Spark infrastructure to AI agents and engineers

πŸ› οΈ SHS CLI Β· ⚑ MCP Server Β· πŸ§ͺ Test Β· 🀝 Contribute

Built by the community, for the community πŸ’™

FAQ

Common questions

Discussion

Questions & comments Β· 0

Sign In Sign in to leave a comment.