Show HN: Pgcraft – a lazygit-style TUI for Postgres
Pgcraft is a terminal user interface (TUI) designed specifically for PostgreSQL, inspired by tools like lazygit. It allows users to navigate schemas, run queries, and view explain plans without leaving the terminal. The tool aims to provide deep PostgreSQL features while avoiding the limitations of multi-DB tools.
- ▪Pgcraft is designed for users who work extensively with PostgreSQL.
- ▪It offers a three-panel browser for schemas, tables, and details.
- ▪The roadmap includes features like an SQL editor, EXPLAIN views, and PostgreSQL-specific functionalities.
Opening excerpt (first ~120 words) tap to expand
pgcraft A lazygit-style TUI for PostgreSQL. Navigate schemas, run queries, view explain plans, peek at pg_stat_* — without ever leaving the terminal. Why? I work in Postgres every day across a few projects (game backend, microservices, side projects). The existing tools are either: psql — terrific but no navigation, every operation is a \d users command from memory pgcli — REPL with autocomplete; better but still REPL-shaped pgAdmin / DBeaver / TablePlus / DataGrip — heavy GUIs, slow startup, some paid lazysql / Sqlit — multi-DB but shallow on each one; can't surface Postgres-specific stuff lazygit proved how nice it is to navigate git visually inside a terminal. k9s did the same for Kubernetes. lazydocker for Docker. No one did it for Postgres specifically. pgcraft is that tool.
…
Excerpt limited to ~120 words for fair-use compliance. The full article is at GitHub.