pgsh: PostgreSQL Development Tool
pgsh is a powerful command-line tool designed to simplify PostgreSQL database management for local development. It streamlines the process of handling database migrations, switching contexts, and managing connection strings through a user-friendly interface, enabling developers to focus more on coding and less on database configuration.
Features
Easily manage database connections using environment variables in a .env file.
Supports two connection modes: URL and split for flexible configuration.
Facilitates database branching, allowing you to clone, create, switch, and destroy databases effortlessly.
Provides a user-friendly migration management interface, integrated with Knex.js.
Includes commands for dumping and restoring databases, ensuring data portability.