4 ms·
Ask HN: What are some AI utilities that can help with SQL development?
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 )
- yamumsafknho 2y agoi found supermaven helpful when i was writing row level security policies in postgres
- hn1986 2y agoThank you, this looks very good with the 1M context window. Does it use any data (schema, etc) for training?
- aitooltrek 2y agoFor 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
- mikewarot 2y agoIt's not AI. And it's old.... Microsoft Access has a really powerful query builder
- jryan49 2y agopostgres.new
- thorin 2y agoIs 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?