✅ Display detailed information about a specific table.

✅ Show schema definitions for all tables in the database.

✅ List all tables present in the database.

✅ Automatically load database connection URL from .env file.

more coming soon...

I'm not a big fan of tools like pgAdmin or MySQL Workbench. They are great tools, but they just provide more information than I need. I prefer using the CLIs that each database provides, but installing sqlite3, psql, and learning all the commands is a bit too much work for me 😅.

I wanted something simpler and easy to extend, so I decided to create my own tool to get information from my database without leaving my terminal.

The project is inspired by artisan (from Laravel) and wrangler (from Cloudflare).

For one time use of the command, run the following command:

npx dbsh

To install the command globally, run the following command:

npm install -g dbsh
dbsh

Here's what you can expect in future releases:

• Support for more databases.
• An option to read the database connection URL from a configuration file, like .env. (released in v0.2.0)
• Include additional information such as indexes and foreign key definitions in the table command.

Published under the MIT license