01 / DEVELOPER TOOL · INDEPENDENT PROJECT
QuerySense
PostgreSQL query diagnosis workbench.
PROJECT / 01
ENGINEERING NOTES
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