# dataegret/pg-utils

Useful PostgreSQL utilities

Repository: https://github.com/dataegret/pg-utils
Canonical: https://ross.abutalabs.com/products/pg-utils
Language: Shell
License: NOASSERTION
License Family: other
Last push: 2026-06-29T11:01:18+00:00

## Health v2 (maintenance only)
Score: 73/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 90, release rhythm 35, longevity 100
- inputs: {"age_days": 4530, "days_push": 65, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1218, forks 233 (observed 2026-08-28T04:04:01.559249+00:00)

## What it is
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
- artifact type: cli-tool
- maturity: active
- function: database, monitoring, developer-tools
- domain: databases, developer-tools, monitoring
- platform: cli
- tags: postgresql, dba, sql-scripts, database-administration, shell-scripts, linux, macos

## Member repositories
- dataegret/pg-utils (main) score 73

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:01.559249+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T06:17:03.289796+00:00, confidence not recorded.
  - readme: https://github.com/dataegret/pg-utils (fetched 2026-08-28T04:04:01.559249+00:00, sha 5767194447f8)
- Data as of 2026-08-30T08:39:29.467469+00:00.