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

Posted by hn1986 on Monday August 12, 2024 @04:09PM
from the ask-hn dept.

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 | on HN )

Re:Ask HN: What are some AI utilities that can help with SQL... by yamumsafknho on Monday August 12, 2024 @07:42PM (#41230612)

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

[ Parent | on HN ]

Re:Ask HN: What are some AI utilities that can help with SQL... by hn1986 on Tuesday August 13, 2024 @12:28PM (#41236941)

Thank you, this looks very good with the 1M context window. Does it use any data (schema, etc) for training?

[ Parent | on HN ]

Re:Ask HN: What are some AI utilities that can help with SQL... by aitooltrek on Monday August 12, 2024 @09:04PM (#41231150)

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

[ Parent | on HN ]

Re:Ask HN: What are some AI utilities that can help with SQL... by mikewarot on Tuesday August 13, 2024 @02:46AM (#41232938)

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

[ Parent | on HN ]

Re:Ask HN: What are some AI utilities that can help with SQL... by jryan49 on Tuesday August 13, 2024 @09:37AM (#41235336)

postgres.new

[ Parent | on HN ]

Re:Ask HN: What are some AI utilities that can help with SQL... by thorin on Friday August 16, 2024 @05:16AM (#41264652)

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?

[ Parent | on HN ]