NikolayS/postgres_dba
The missing set of useful tools for Postgres DBAs and all engineers observed · 2026-08-28
Health v2 · maintenance only
77/100
- Activity 98
- Release rhythm 37
- Longevity 100
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 3402
- days_rel: 204
- days_push: 15
- n_releases_24m: 1
Adoption not part of the score
1284 stars · 145 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
A set of 34 SQL-based diagnostic reports for PostgreSQL that run directly inside psql with no agents or external dependencies. It covers bloat estimation, index health, lock trees, vacuum monitoring, query analysis, and corruption checks.
Use cases
- diagnose postgres table and index bloat
- find unused or redundant indexes in postgresql
- monitor autovacuum progress and queue
- analyze slow queries with pg_stat_statements
- check postgres indexes for corruption
- inspect lock trees and blocking queries
- estimate database and table sizes
When to choose
- you administer PostgreSQL and want quick diagnostics inside psql without installing agents or daemons
- you need production-safe health checks like bloat estimation and index analysis
- you want lightweight SQL-only tooling with no external dependencies
When to avoid
- you need continuous monitoring with dashboards, alerting, and history (use pgwatch, Prometheus, or pganalyze)
- you require support for databases other than PostgreSQL
- you want a GUI-based database administration tool
Facets
cli-tool · maturity active
database monitoring developer-tools cli databases developer-tools performance cli windows postgresql psql dba diagnostics sql-reports database-administration linux macos
1 source
- readme: https://github.com/NikolayS/postgres_dba · fetched 2026-08-28 · af68d6cda192
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| NikolayS/postgres_dba | main | 77 |
For agents
markdown · JSON · MCP: product_card(name="NikolayS/postgres_dba")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem