Skip to main content
Glama
Sign In
ARAVINDHRAJA123

sql-review-agent

by ARAVINDHRAJA123
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Remote

SQL Review Agent

An agentic AI system that reviews BigQuery SQL queries before you run them — catching performance issues, estimating cost, and suggesting rewrites.

What it does

Paste a BigQuery SQL query and the agent:

  1. Static analysis — instantly flags SELECT *, missing partition filters, cartesian joins

  2. Schema fetch — reads partition keys, clustering fields, and row counts from BigQuery

  3. Cost estimate — dry-runs the query to get bytes scanned without executing it

  4. Rewrite — returns improved SQL with a plain-English explanation

  5. Severity rating — none / low / medium / high / critical

Related MCP server: bigquery-mcp

Architecture

The agent is modelled as a LangGraph state machine:

Agent graph

  • call_llm — sends messages + tools to Claude/Gemini

  • run_tools — dispatches get_table_schema, dry_run_sql, write_report

  • route — conditional edge: loop back if tool calls remain, stop when write_report is called

Three trigger modes

Mode

How

CLI

python agent.py --sql "SELECT * FROM ..."

Web UI

python server.py → open localhost:5001

MCP

Any MCP-compatible client (Claude Code, Cursor, Zed, OpenClaw)

Setup

git clone https://github.com/ARAVINDHRAJA123/sql-review-agent.git
cd sql-review-agent
python3 -m venv venv && source venv/bin/activate
pip install -r requirements.txt

export GCP_PROJECT=your-project
export BQ_LOCATION=asia-south1
export GEMINI_API_KEY=your-key     # free tier: aistudio.google.com
# or: export ANTHROPIC_API_KEY=your-key

gcloud auth application-default login

MCP (Claude Code)

claude mcp add -s user sql-review -- \
  /path/to/venv/bin/python /path/to/mcp_server.py

Tools available in any MCP client:

  • review_sql — full agentic review (LLM + BQ)

  • quick_check — instant static analysis, no LLM needed

CLI usage

python agent.py --sql "SELECT * FROM \`project.dataset.table\`"
python agent.py --file query.sql --verbose

Web UI

Web UI

python server.py
# open http://localhost:5001

Tests

pytest
pytest tests/test_tools.py -v

Project structure

sql-review-agent/
├── agent.py          ← raw tool-use loop (Claude + Gemini)
├── graph_agent.py    ← LangGraph state machine (drop-in replacement)
├── mcp_server.py     ← FastMCP server (review_sql + quick_check tools)
├── server.py         ← Flask web UI + JSON API
├── tools/
│   ├── bq_tools.py   ← dry_run, schema, metadata, read-only guard
│   └── sql_tools.py  ← static analysis, table extraction
├── tests/
│   ├── test_tools.py ← 24 unit tests
│   └── test_agent.py ← 7 unit tests
└── docs/
    ├── architecture_graph.svg  ← state machine diagram
    └── web_ui.png              ← Flask UI screenshot

Stack

Python · BigQuery · Claude API · Gemini API · LangGraph · FastMCP · Flask · pytest

This server cannot be deployed

Shareable, User-Owned Context BackendPeople, applications, and agents read, write, and coordinate together in one context lake. Reach it over MCP, a CLI, a Python SDK, or REST.fulcradynamics.comAd

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • BigQuery Validator

    caron14
    A
    license
    B
    quality
    B
    maintenance
    Enables validation and dry-run analysis of BigQuery SQL queries without execution. Provides cost estimates, schema previews, and syntax validation for BigQuery queries.
    9
    30 PyPI
    1
    MIT

  • bigquery-mcp

    aicayzer
    A
    license
    Not graded
    quality
    D
    maintenance
    MCP server for secure BigQuery access across multiple Google Cloud projects, enabling querying, schema exploration, and data analysis with SQL validation and read-only controls.
    2
    MIT