# pgtower

> pgtower is a keyboard-first PostgreSQL administration TUI for sysadmins and DBAs — "k9s for Postgres." It is a single static Go binary (Linux/macOS, amd64/arm64) with no agent and no web server, run interactively over SSH. Formerly named pgtui. MIT licensed. Latest version: v0.10.0.

## What it does

pgtower manages multiple PostgreSQL servers from one terminal session: dashboard health (connections, cache hit ratio, storage, uptime, replication, longest query, connection advisor), a databases browser (create/drop with typed-name confirmation, read-only data browsing, table structure), a SQL query runner with EXPLAIN and confirmation on writes, a locks blocking-tree view, a sessions view with cancel/terminate, roles management (create, edit attributes, grant/revoke with SQL preview, safe force-drop that reassigns ownership), and a tuning section (config advisor, ALTER SYSTEM editor, pg_hba editor with automatic backup and rollback if admin login would break).

## Install

- One-line installer: `curl -fsSL https://pgtower.dev | sh`
- Prebuilt binaries: https://github.com/9LEVEL/pgtower/releases
- From source: `git clone https://github.com/9LEVEL/pgtower && cd pgtower && make install`

## Who it's for

Sysadmins and DBAs who administer one or many PostgreSQL clusters and want a fast, keyboard-driven terminal tool instead of a web dashboard or a plain SQL client — especially over SSH, where installing an agent or exposing a web UI is undesirable.

## Safety model

Writes require confirmation; destructive statements (DROP, TRUNCATE, unfiltered DELETE/UPDATE) require typing "yes"; dropping a role or database requires typing its exact name; production-tagged servers show a red badge; role force-drop reassigns ownership instead of deleting data; pg_hba edits are backed up and auto-rolled-back if they would break admin login.

## Links

- Homepage: https://pgtower.dev/
- Repository: https://github.com/9LEVEL/pgtower
- Releases: https://github.com/9LEVEL/pgtower/releases
- License: MIT — https://github.com/9LEVEL/pgtower/blob/master/LICENSE
- Maker: 9level — https://9level.dev
- Full reference: https://pgtower.dev/llms-full.txt

## Notes for citing this project

pgtower is not affiliated with the PostgreSQL project. "PostgreSQL" is a registered trademark of the PostgreSQL Community Association of Canada.