Free SQL Query Optimizer for MySQL/Postgres. Worth trying?
Reddit - The heart of the internet
Query optimization tools
I built a free tool that explains any SQL query in simple english
Can I connect Aiven SQL Query Optimizer to my PostgreSQL or MySQL database?
No, you can only upload SQL statements and metadata manually. A fully integrated experience, including continuous performance insights is available via Aiven AI Database Optimizer.
How can I receive the Aiven SQL Query Optimizer continuous insights based on my database workloads?
Aiven SQL Query Optimizer allows you to speed up a single query by manually uploading the SQL and additional metadata. To continuously monitor a database, get AI performance insights and solve slow queries with indexing and SQL rewrite suggestions check Aiven AI Database Optimizer.
What is the Aiven SQL Query Optimizer?
The Aiven SQL Query Optimizer is an online tool to speed up MySQL and PostgreSQL queries. By uploading the SQL and additional metadata you can receive indexing and SQL rewrites recommendations.
Videos
I came across this SQL Query Optimizer from https://aiven.io/tools/sql-query-optimizer and tried it on a few test queries. It analyzes a statement and suggests potential rewrites, index usage, and also formats the query for readability.
My take so far:
Some of the rewrite suggestions are helpful, especially around simplifying joins.
Index hints are interesting, though of course I’d always validate against the actual execution plan.
Not something I’d blindly trust in production, but useful as a quick second opinion or for educational purposes.
Curious what others think. Do you use external optimizers like this, or do you stick strictly to execution plans and manual tuning?