OptimizeQL — AI-powered SQL query optimizer

Go library and CLI to parse PostgreSQL EXPLAIN (ANALYZE, FORMAT JSON) output and surface actionable performance findings

PostgreSQL slow query watcher, tails auto_explain log output and reports actionable findings using pgexplain

Local-first Postgres slow-query triage with Gemma 4 E4B. Plans never leave the machine. Built for the Gemma 4 Challenge.

CLI wrapper around pev2 for visualizing PostgreSQL EXPLAIN plans with live reload

2000x query speedup on 10M rows using BRIN indexes. Full EXPLAIN ANALYZE benchmarks. PostgreSQL 16.

Lint Postgres EXPLAIN ANALYZE plans for slow-query anti-patterns: seq scans on filtered big tables, hash joins spilling to disk, nested loops on too many outer rows, sort spilling, planner row-estimate skew. Reads JSON or text plans.

A fully normalized Hotel Booking System Database designed using PostgreSQL, following 3rd Normal Form (3NF) principles. This project demonstrates real-world database design, indexing, stored procedures, and query optimization.

Query profiler for pgx v5 — drop-in tracer that captures EXPLAIN (ANALYZE, FORMAT JSON) plans via inline SQL annotations and a pluggable Reporter interface