GDP MCP Tools

MCP (Model Context Protocol) server for Grubhub Data Platform operations. 40+ tools across 18 service categories. Works with Claude Code, VS Code, Cursor, JetBrains, or any MCP-compatible client.

Quick Start (5 minutes)

1. Clone and set up virtual environment

# Ask your team lead for the repo URL, or use:
git clone https://github.com/asuar16/gdp-mcp-tools.git
cd gdp-mcp-tools

# macOS / Linux
python3 -m venv venv
source venv/bin/activate
pip install -r requirements.txt

# Windows (PowerShell)
python -m venv venv
.\venv\Scripts\Activate.ps1
pip install -r requirements.txt

2. Configure credentials

cp .env.example src/.env

Edit src/.env with your credentials. See Credentials below.

3. Configure your MCP client

Add to .mcp.json in any repo where you want these tools:

macOS / Linux:

{
  "mcpServers": {
    "gdp-tools": {
      "type": "stdio",
      "command": "/absolute/path/to/gdp-mcp-tools/venv/bin/python",
      "args": ["/absolute/path/to/gdp-mcp-tools/src/server.py"]
    }
  }
}

Windows:

{
  "mcpServers": {
    "gdp-tools": {
      "type": "stdio",
      "command": "C:\\path\\to\\gdp-mcp-tools\\venv\\Scripts\\python.exe",
      "args": ["C:\\path\\to\\gdp-mcp-tools\\src\\server.py"]
    }
  }
}

4. Connect VPN and start using

All tools require VPN. Connect first, then use any MCP client.

---

Using from Any Repo

Already have gdp-mcp-tools set up? Here's how to add it to a new repo in 1 minute:

Step 1: Get your paths

cd ~/path/to/gdp-mcp-tools
echo "Python: $(pwd)/venv/bin/python"
echo "Server: $(pwd)/src/server.py"

Step 2: Create .mcp.json in your new repo

cd ~/path/to/your-new-repo

cat > .mcp.json << 'EOF'
{
  "mcpServers": {
    "gdp-tools": {
      "type": "stdio",
      "command": "/absolute/path/to/gdp-mcp-tools/venv/bin/python",
      "args": ["/absolute/path/to/gdp-mcp-tools/src/server.py"]
    }
  }
}
EOF

Replace the paths with your actual paths from Step 1.

Step 3: Start your AI coding session

Claude Code:

cd ~/path/to/your-new-repo
claude
# GDP tools will auto-connect. Try: "check vpn status"

VS Code / Cursor:

Open the repo folder -> MCP tools appear in Copilot/AI sidebar

Gemini CLI:

cd ~/path/to/your-new-repo
gemini
# Tools auto-load from .gemini/settings.json

Antigravity:

Open project -> Tools auto-load from mcp_config.json

That's it. The .mcp.json tells any MCP client where to find the server. No installation needed in the new repo -- everything runs from gdp-mcp-tools/.

Example: Adding to events-mart, ods_data, or any repo

{
  "mcpServers": {
    "gdp-tools": {
      "type": "stdio",
      "command": "/Users/yourname/gdp-mcp-tools/venv/bin/python",
      "args": ["/Users/yourname/gdp-mcp-tools/src/server.py"]
    }
  }
}

Works from any repo -- events-mart, ods_data, or even non-GDP projects.

---

Client Setup

Claude Code (CLI / Desktop / Web)

Add .mcp.json to your project root:

{
  "mcpServers": {
    "gdp-tools": {
      "type": "stdio",
      "command": "/absolute/path/to/gdp-mcp-tools/venv/bin/python",
      "args": ["/absolute/path/to/gdp-mcp-tools/src/server.py"]
    }
  }
}

VS Code / Cursor

Add to .vscode/settings.json:

{
  "mcp.servers": {
    "gdp-tools": {
      "type": "stdio",
      "command": "/absolute/path/to/gdp-mcp-tools/venv/bin/python",
      "args": ["/absolute/path/to/gdp-mcp-tools/src/server.py"]
    }
  }
}

Google Antigravity

Add to ~/.gemini/antigravity/mcp_config.json (or project-level .gemini/settings.json):

macOS / Linux:

{
  "mcpServers": {
    "gdp-tools": {
      "command": "/absolute/path/to/gdp-mcp-tools/venv/bin/python",
      "args": ["/absolute/path/to/gdp-mcp-tools/src/server.py"]
    }
  }
}

Windows:

{
  "mcpServers": {
    "gdp-tools": {
      "command": "C:\\path\\to\\gdp-mcp-tools\\venv\\Scripts\\python.exe",
      "args": ["C:\\path\\to\\gdp-mcp-tools\\src\\server.py"]
    }
  }
}

To reload after config change: use Manage MCP Servers > View raw config in Antigravity UI, or restart.

Gemini CLI

Add to ~/.gemini/settings.json (global) or .gemini/settings.json (project-level):

macOS / Linux:

{
  "mcpServers": {
    "gdp-tools": {
      "command": "/absolute/path/to/gdp-mcp-tools/venv/bin/python",
      "args": ["/absolute/path/to/gdp-mcp-tools/src/server.py"]
    }
  }
}

Windows:

{
  "mcpServers": {
    "gdp-tools": {
      "command": "C:\\path\\to\\gdp-mcp-tools\\venv\\Scripts\\python.exe",
      "args": ["C:\\path\\to\\gdp-mcp-tools\\src\\server.py"]
    }
  }
}

To reload: run /mcp reload in Gemini CLI, or restart.

JetBrains (IntelliJ / PyCharm)

Settings > Tools > MCP Servers > Add:

• Name: gdp-tools
• Command: /absolute/path/to/gdp-mcp-tools/venv/bin/python
• Args: /absolute/path/to/gdp-mcp-tools/src/server.py

Any MCP Client (stdio transport)

/path/to/gdp-mcp-tools/venv/bin/python /path/to/gdp-mcp-tools/src/server.py

Reads JSON-RPC from stdin, writes responses to stdout, logs to stderr.

---

Credentials

Copy .env.example to src/.env and fill in:

Credential	Required	How to Get
USERNAME	Yes	Your LDAP username (auto-detected from $USER if not set)
JENKINS_TOKEN	Yes	Jenkins > Profile > Configure > API Token
OKTA_PASSWORD	Yes	Your Okta login password
PRESTO_PASSWORD	Yes	Trino cluster password (ask team lead)
JIRA_PERSONAL_TOKEN	Yes	Jira > Profile > Personal Access Tokens
JIRA_USERNAME	Yes	Your @grubhub.com email
GITHUB_TOKEN	Optional	GitHub > Settings > Developer Settings > PAT (repo + read:org, SSO for GrubhubProd)
REDASH_API_KEY	Optional	dev-redash.gdp.data.grubhub.com > Profile > API Key
SLACK_MCP_XOXC_TOKEN	Optional	Slack browser DevTools > Network > Copy from request
DD_API_KEY	Optional	DataDog > Org Settings > API Keys
PAGERDUTY_USER_API_KEY	Optional	PagerDuty > User Settings > API Token
DATAHUB_TOKEN	Optional	DataHub UI > Settings > Access Tokens

---

Tool Catalog

Data Platform (13 tools)

Tool	Description
sync_table	Sync prod table to dev
jenkins_deploy_branch	Deploy Git branch to dev
jenkins_deploy	Deploy version to prod
jenkins_integrate	Integrate PR
jenkins_start_cluster / stop_cluster	EMR cluster management
jenkins_validate_schedule	Validate schedule.json
azkaban_run_flow	Execute Azkaban flow
azkaban_monitor	Monitor execution until complete
azkaban_status	Check execution status
azkaban_cancel	Cancel running execution
azkaban_flows	List flows in project
azkaban_list_executions	List recent executions
trino_query	Execute SQL on dev/preprod/prod

Observability (7 tools)

Tool	Description
list_emr_clusters / describe_emr_cluster	EMR cluster info
spark_app_details / spark_stage_details	Spark History Server
get_flow_logs	Azkaban execution logs via SSH
vpn_connect / vpn_status / vpn_disconnect	F5 VPN management
s3_list_partitions / s3_list_batch_ids	S3 data inspection

Analytics (7 tools)

Tool	Description
pv_failure_summary	PV framework failure analysis
pv_analyze_metric	Deep-dive metric investigation
pv_investigate_root_cause	Root cause tracing
pv_generate_report	HTML report generation
backfill_plan / backfill_fire / backfill_list_jobs	Backfill management
calculate_sync_plan / check_sync_status	Smart sync planning

Collaboration (10 tools)

Tool	Description
jira_search / jira_get_issue / jira_create_issue	Jira issues
jira_transition_issue / jira_add_comment	Jira workflow
slack_post / slack_read_message / slack_read_thread / slack_search	Slack
github_list_prs / github_read_pr / github_comment_pr / github_update_pr	GitHub PRs
get_pr_discussions	PR discussion threads

Data Catalog (7 tools)

Tool	Description
datahub_search / datahub_get_dataset	DataHub metadata
datahub_get_lineage / datahub_get_column_lineage	DataHub lineage
datahub_whoami	DataHub auth check
redash_run_query / redash_create_query / redash_update_query	Redash queries
redash_create_visualization / redash_clone_query	Redash viz
create_branded_google_doc / convert_md_to_branded_html	Google Docs

---

File Structure

gdp-mcp-tools/
  README.md                 # This file
  TOOLS.md                  # Detailed tool reference
  requirements.txt          # Python dependencies
  .env.example              # Credential template (copy to src/.env)
  .mcp.json.example         # MCP client config template
  .gitignore

  src/
    server.py               # FastMCP entry point (stdio transport)
    auth.py                 # Shared auth (Jenkins, Azkaban, Trino, Jira)
    .env                    # Your credentials (gitignored, never committed)
    tools/
      jenkins_tools.py      # Deploy, sync, integrate, cluster ops
      scheduler_tools.py    # Azkaban flows, monitor, cancel
      trino_tools.py        # SQL queries (dev/preprod/prod)
      emr_tools.py          # EMR cluster list/describe
      s3_tools.py           # S3 partition listing
      backfill_tools.py     # Backfill planning + execution
      sync_plan_tools.py    # Smart sync planning
      spark_tools.py        # Spark History Server
      flowlogs_tools.py     # Azkaban log retrieval via SSH
      pv_tools.py           # PV failure analysis
      vpn_tools.py          # VPN connect/disconnect/status
      jira_tools.py         # Jira issue management
      slack_tools.py        # Slack messaging
      github_tools.py       # GitHub PR operations
      pr_tools.py           # PR discussion threads
      google_doc_tools.py   # Branded Google Doc creation
      datahub_tools.py      # DataHub lineage/search
      redash_tools.py       # Redash query/viz management

  scripts/                  # Utility scripts (not MCP tools)
    datadog_wrapper.sh      # DataDog MCP wrapper
    pagerduty_wrapper.sh    # PagerDuty MCP wrapper
    google_workspace_wrapper.sh
    create_redash_queries.py

  config/
    config.json             # Tool configuration

---

Troubleshooting

Problem	Fix
ModuleNotFoundError: No module named 'mcp'	pip install mcp[cli] in the venv
PRESTO_HOST must be set	Check src/.env exists with correct values
Connection timed out	Connect VPN first (vpn_connect tool or manual)
Azkaban login failed	Check OKTA_PASSWORD is current
Jenkins 401	Regenerate JENKINS_TOKEN
Jira 401	Regenerate JIRA_PERSONAL_TOKEN
DNS resolution failed	VPN dropped, reconnect
Tools not showing in client	Restart MCP client. Check .mcp.json paths are absolute.
Windows path issues	Use \\ in JSON paths, or forward slashes /