What are some AI utilities that can help with SQL development?

Question

SQL is a more challenging problem compared to standard software development languages like C# or Python. Generally, it requires information on database schema. I've not found GitHub Copilot to help with my SQL development, doing worse than an IDE's built-in intellisense.Are there any mature (preferably private/local) AI tools that help with SQL?I've seen some things with DataGrip but doesn't feel quite there yet. (https://www.jetbrains.com/datagrip/whatsnew/2024-1/#:~:text=day%20trial%20available-,AI%20Assistant%3A%20option%20to%20attach%20schemas,-DataGrip%20only )

thorin · Accepted Answer

Is SQL really that difficult to write? SQL is quite a high level language, although it was pretty much the 1st thing I learnt after c and basic. I'm not sure how writing a prompt to do SQL which you then would have to test pretty extensively would be much easier, unless you were writing a lot of repetitive queries. In general having used sql for over 25 years, you don't have to write too many complex queries (although I have written a fair amount of ridiculously complicated ones). In fact it will be better if you think about taking out some of the complexity at the data modelling stage if you are able to get involved in that?

mikewarot · Answer

It's not AI. And it's old.... Microsoft Access has a really powerful query builder

aitooltrek · Answer

For me, I think the most useful development tool is Claude.Worth to mention, I was a paid user of chatGPT before - then I switch to Claude. The only thing I am not happy it is I hit limit of Claude usage easily

jryan49 · Answer

postgres.new

yamumsafknho · Answer

i found supermaven helpful when i was writing row level security policies in postgres