KK.KRISHNA KUMARSOFTWARE DEVELOPER
ALL WORK
01 / DEVELOPER TOOL · INDEPENDENT PROJECT

QuerySense

PostgreSQL query diagnosis workbench.

ROLEIndependent developer
STATUSLive prototype
STACKNext.js · TypeScript · PostgreSQL plans · Gemini API
PROJECT / 01
ENGINEERING NOTES

The problem

PostgreSQL plans expose useful evidence, but reading nested nodes, estimates, and bottlenecks takes practice. QuerySense gives developers a structured place to inspect that evidence before changing a query.

What I built

  • Parse submitted SQL and user supplied JSON EXPLAIN plans without requiring a database connection.
  • Surface plan nodes, likely bottlenecks, and candidate changes in a reviewable workspace.
  • Let users compare candidate queries and optionally request a Gemini review, keeping model output distinct from plan evidence.

Current boundaries

The app does not execute SQL, verify query equivalence, or benchmark a speedup. Recommendations remain hypotheses until tested against a real database.

NEXT PROJECTArtfolio