Use VIM as a Database Manager — DB CLI TUI

If you have used VsCode or IntelliJ plugins to manage your database, you might wonder if there is anything similar in vim.

The answer is simple: YES.

The popular tpope, who has created the a long number of popular plugins, has created a vim database interface

GitHub - tpope/vim-dadbod: dadbod.vim: Modern database interface for Vim

And on top of that kristijanhusak created a UI for VIM.

Although you can create your own adapter, as for now the supported databases are:

• Big Query, ClickHouse, Impala, jq, MongoDB, MySQL, MariaDB, Oracle, osquery, PostgreSQL, Presto, Redis, SQL Server, SQLite

As an extra, for autocompletion you can include another plugin from kristijanhusak

GitHub - kristijanhusak/vim-dadbod-completion: Database autocompletion powered by…

Setup

To install these plugins using git, you can use the two most popular options. The new plugin manager pack or another popular plugin manager vim-plug.

• Using pack