pgsh
A CLI tool that enables Git-like branching for PostgreSQL databases to simplify local development workflows.
What is pgsh?
pgsh is a command-line tool that streamlines PostgreSQL database management during local development. It allows developers to branch, clone, and switch between database states effortlessly, reducing the pain of migrations and context switching by managing connection strings in .env files.
Developers working on PostgreSQL-backed applications who use environment-based configuration (like dotenv) and need to manage multiple database states locally, especially those using knex for migrations.
Developers choose pgsh for its Git-like branching workflow for databases, which simplifies context switching and feature isolation, and its seamless integration with knex migrations and .env-based configuration, adhering to Twelve-Factor App principles.
Overview
Branch your PostgreSQL Database like Git
Use Cases
Best For
- Managing multiple database branches for parallel feature development in PostgreSQL projects
- Simplifying database context switching during local development with automated .env updates
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
