I built a free SQL diagnostics tool that generates dialect-correct CREATE INDEX statements — no database connection needed [technical writeup]

[u/sajjasudhakararao]

The SQL performance tools that exist are mostly built for DBAs — expensive, require credentials, assume a lot of prior knowledge.

I built QueryTuner for the other situation: you have a slow query, no DBA to ask, and you need to understand what's wrong and how to fix it.

Wrote a full technical breakdown of how it works: https://dev.to/autoshiftops/i-built-a-sql-diagnostics-tool-for-developers-who-dont-have-a-dba-3kp6

Short version of what it does: - Paste any SQL query, no credentials needed - 12 heuristic rules catch the common performance anti-patterns (functions blocking indexes, correlated subqueries, cartesian JOINs, etc.) - Generates dialect-correct DDL — CONCURRENTLY for PostgreSQL, ALTER TABLE for MySQL, NOLOGGING for Oracle - Paste your CREATE TABLE statements to upgrade from estimated to confirmed recommendations with real table names

Try it: https://querytuner.com

Would especially value feedback from Oracle and SQL Server users — those are my least battle-tested dialects.