3 ms·
Show HN: New approach to SQL optimization that works (mostly)
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 https://files.sqlai.ai/optimize-sql-query.mp4
Try it out: https://www.sqlai.ai/app/optimize-sql https://www.sqlai.ai/app/optimize-sql