QueryTuner

• 

  QueryTuner

Only 0.3% of developers are database administrators (Stack Overflow 2024). The SQL performance tools that exist were built for them.

QueryTuner is for everyone else.

Paste any SQL query. No database connection, no credentials, no installation. Get back:

• Severity-ranked findings with plain-English explanations
• Dialect-correct index DDL (CONCURRENTLY for PostgreSQL, ALTER TABLE for MySQL, NOLOGGING for Oracle, ONLINE=ON for SQL Server)
• A rewritten query with slow patterns fixed
• A security scan for injection-prone patterns
• A permanent shareable report URL

Paste your CREATE TABLE statements to upgrade from estimated to confirmed recommendations — QueryTuner cross-references your actual schema, verifies columns exist, suppresses suggestions for indexes already in your DDL, and generates copy-pasteable DDL with real table names.

Supports PostgreSQL, MySQL, Oracle, SQL Server, and SQLite.

How it's built:

• Backend: FastAPI (Python) on Render
• Frontend: React + Vite + Tailwind on Vercel
• AI: OpenAI gpt-4o-mini (recommended) + HuggingFace (alternative)
• Database: Supabase (PostgreSQL)
• Architecture: heuristic engine + optional LLM layer

The heuristic layer always runs. The LLM is additive — if it fails, you still get complete structured findings.

Try it: querytuner.com

Source: github.com/AutoShiftOps/querytuner

Built solo on 30 minutes a day.

Built With

• claude
• fastapi
• heuristic
• huggingface
• llm
• openai
• oracle
• postgresql
• python
• sql
• sqlite