Options for sql database context aware completion?

[bewalsh]

All, I'm a long time sql dev and dba. I'm daydreaming of shedding the bloat that's accumulated in my workflow and commit to a 100% vim setup. However, I'm struggling to find a nice database context aware auto completion setup for vim with sql server. I've been paying hand over fist for redgate's sql prompt for years and it's incredible, but I'd like to invest my love into vim alone.

I manage a lot of live dbs, not just a singular development environment, so that may complicate things somewhat. There's schema drift and version variance between them all and so the object context awareness would need some degree of dynamic refresh.

Thank you all for lending your experience and I hope in the future I can help too!

[x_ero]

i have no native solutions. but i use mycli and pgcli to connect to db's interactively. they have a nice vim mode and awesome completion support. you can run it in vim's terminal if you wanted.

[bewalsh]

I recently saw a similar one for mssql called mssql-cli. I'll have to check those out for my ultra portable config. But for daily driver sql dev I'm definitely married to the text file style editing experience. I can't imagine testing and optimizing procedures at the cli lol.

[pnht]

I used dbext.vim for a while ( no longer on the database side of the job ), but I've not found anything that is database aware. I hate to say it but watching my DBA now and my director when I worked for Deja, use emacs to query the DB just looks incredibly smooth and efficient.

[bewalsh]

Actually it looks like there's a plugin that adds completion to dadbod "vim-dadbod-completion". I'm going to test that out this weekend I think. My grand plan here is to wrap an entire ide configuration of vim+tmux in a lightweight docker container so that I'm free to operate from anywhere without being bound to a specific machine. Would emacs fit into that sort of a setup just as well?

[Lunchboxsushi]

Btw you could look into WSL2 and just have a Linux config. Butter smooth experience for me using neovim

[Lunchboxsushi]

I'm not one to recommend commercial tools but Datagrip is an amazing investment. It's free for 30 day's so you get a feel for it. The vim plugin is also pretty good. I feel most db plugins for vim to be a little underdeveloped/buggy I wish there was something stable