Show HN: New approach to SQL optimization that works (mostly) (sqlai.ai)

I've been messing around with getting AI to reliably optimize complex SQL queries without constantly making errors. A prompt like: “You are a skilled SQL expert tasked with optimizing this: SELECT *...” doesn't get you far.

That's why I've chosen to divide the optimization process (step-by-step approach):

- AI suggests concrete optimization improvements - The user selects the desired optimization improvement - AI rewrites the SQL query according to the optimization improvement

This approach has several advantages:

- The user has full control over which optimization improvements are implemented - AI can handle relatively complex SQL queries without making errors

Screencast: https://files.sqlai.ai/optimize-sql-query.mp4

Try it out: https://www.sqlai.ai/app/optimize-sql