Vim/Neovim — Managing Databases

Managing databases and running SQL statements, all within Vim/Neovim.

Photo by Caspar Camille Rubin on Unsplash

Overview

In my previous article, I walked through with you how to manage multiple projects within Vim/Neovim. In this article let’s extend this to see how to manage multiple databases.

Vim/Neovim — Managing Multiple Projects

Setup

I am going to use PostgreSQL and MySQL as examples. For this to work, on the client machine you will need to install the database clients.

• For PostgreSQL, you will need libpq. Depending on your operating system, you can follow the instructions here to install PostgreSQL client.
• For MySQL, you need MySQL client. You can install the component using the MySQL installer. Alternatively, depending on your operating system, you can use brew install mysql-client (MacOS)or apt-get install mysql-client (Linux).

Other databases are also supported. More on this later.

If you want to use Docker for MySQL and PostgreSQL for testing, you can refer to this…