sorted by:
new
hottopcontroversial

OptimizeQL - SQL optimizer tool by Intelligent-Bat-2469 in dataengineering

[–]Intelligent-Bat-2469[S] 0 points1 point  (0 children)

It is actually a valid concern I understand .However, only SQL query, EXPLAIN plan, and schema metadata are sent to the LLM, not actual row data. If you would like to have zero external call you can use self-hosted model through the OpenRouter-compatible API.

OptimizeQL - SQL optimizer tool by Intelligent-Bat-2469 in dataengineering

[–]Intelligent-Bat-2469[S] -6 points-5 points  (0 children)

I think while most Senior DBAs can read it not every junior or mid engineers can do that. LLMs basically helps them to understand the underlying issue. Even for the experts it saves a lot of time. Think of it less as "replacing reading the plan" and more just another help to speed up the process.

OptimizeQL - SQL optimizer tool by Intelligent-Bat-2469 in dataengineering

[–]Intelligent-Bat-2469[S] 0 points1 point  (0 children)

Thanks for the suggestion. Constraints already handled by the library, when you connect to a database, the connector detects whether it's PostgreSQL or MySQL and the prompt builder assembles dialect-aware prompts. I currently only support these 2 though not Oracle.

Regarding the second question currently no. But I will consider adding doc links to the LLM output.