Projects

AI agent · SQL · Internal tool · 2025–present

AI SQL Troubleshooter

An AI tool that reviews thousands of lines of SQL and proposes fixes in minutes.

Builder & owner, directed with AI

Minutes
to review thousands of lines of SQL
Anyone
on the team can ship a fix, not just experts

Built for a business-intelligence team, this AI-assisted tool reads large SQL codebases, flags likely errors, and writes corrections with plain-language explanations. It lowers the expertise a fix requires from expert to confident, so the work stops piling up on a few people.

Problem

Debugging long, unfamiliar SQL is slow, and it lands on a handful of people who know the codebase. Everyone else waits on them, so every broken query became a queue behind two or three experts. The bottleneck was not the SQL. It was that only a few people could safely touch it.

Approach

I wanted to widen the door without lowering the standard. The tool had to do more than spot a problem. It had to explain the fix clearly enough that a non-expert could apply it and trust the result.

So I built an AI-assisted reviewer that reads thousands of lines of SQL, points to the likely errors, and proposes concrete corrections with the reasoning attached. The reasoning is the point: a fix you cannot understand is one you cannot ship with confidence.

What I built

A reviewer that ingests a large SQL codebase, surfaces the probable errors, and returns specific corrections alongside an explanation of what was wrong and why the change fixes it. I built it for the team's real codebases and keep refining it against the cases that come up in practice, so the output stays useful rather than theoretical.

Key decisions & trade-offs

I built it around explanation, not just detection. Flagging an error is easy; the value is in returning a correction a non-expert can read, understand, and apply safely. Every choice about how results are presented followed from that bar.

Outcomes

  • Reviews thousands of lines of SQL and returns corrections in minutes.
  • Moved a key bottleneck off a few experts: a confident non-expert can now ship a fix safely.

Built with LLM platforms · SQL

Scope Internal tool · AI-assisted development