HN Explorer

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

3 points by hn1986 ↗ HN
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 )

6 comments

[ 2.7 ms ] story [ 21.0 ms ] thread
yamumsafknho
i found supermaven helpful when i was writing row level security policies in postgres
hn1986
Thank you, this looks very good with the 1M context window. Does it use any data (schema, etc) for training?
aitooltrek
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

mikewarot
It's not AI. And it's old.... Microsoft Access has a really powerful query builder
thorin
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?