I wrote a tool to optimize SQL queries using LLM models. I sometimes struggle to find the root cause for the slow running queries and sending to LLM most of the time doesn't have good result. I think the reason is LLM doesnt have the context of our database, schemas, explain results .etc.
That is why I decided to write a tool that gathers all inform about our data and suggest meaningful improvements including adding indexes, materialized views, or simply rewriting the query itself. The tool supports only PostgreSQL and MySQL for now , but you can easily fork and add your own desired database.
You just need to add your LLM api key and database credentials. It is an open source tool so I highly appreciate the review and contribution if you would like.
Feel free to check it out : https://github.com/SubhanHakverdiyev/OptimizeQL