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

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

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

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