dataegret/pg-utils
Useful PostgreSQL utilities observed · 2026-08-28
Health v2 · maintenance only
73/100
- Activity 90
- Release rhythm 35
- Longevity 100
Flags: no_releases no_license
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-02. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 4530
- days_rel: n/a
- days_push: 65
- n_releases_24m: 0
Adoption not part of the score
1218 stars · 233 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
A collection of useful SQL and shell utilities for PostgreSQL database administration by Data Egret. It includes scripts for auditing configuration, checking missing grants and indexes, and creating convenience views around pg_stat_activity and pg_stat_statements.
Use cases
- audit non-default PostgreSQL configuration parameters
- find tables missing unique constraints
- check for missing grants in a database
- monitor long-running queries with a better pg_stat_activity view
- analyze query CPU and IO time statistics
- find foreign keys with missing indexes
When to choose
- you administer PostgreSQL servers and want lightweight DBA scripts without installing extensions
- you need quick SQL-based health checks and audits of a database
- you want better visibility into query activity and statistics
When to avoid
- you need a full monitoring platform with dashboards and alerting
- you use a database other than PostgreSQL
- you want a GUI database management tool
Facets
cli-tool · maturity active
database monitoring developer-tools databases developer-tools monitoring cli postgresql dba sql-scripts database-administration shell-scripts linux macos
1 source
- readme: https://github.com/dataegret/pg-utils · fetched 2026-08-28 · 5767194447f8
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| dataegret/pg-utils | main | 73 |
For agents
markdown · JSON · MCP: product_card(name="dataegret/pg-utils")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem