Better PostgreSQL databases for support teams.
What it does
Guides the design, tuning, and administration of PostgreSQL databases for customer support systems.
When to use it
Use when working on support ticketing, user management, reporting, audit trails, SLA monitoring, knowledge bases, or communication logs.
How to use it
It changes how the agent designs and maintains customer support databases, supplying SQL examples and administration practices.
What you provide
- An existing project
Uses
Good to know
- cannot be undone: /backup/postgres; PostgreSQL; postgresql.conf; pg_hba.conf
- a credential is hard-coded: app_user password; replicator password
What you need · 5
Requires access to a PostgreSQL 12+ installation; the README also supplies installation instructions.
Uses the PostgreSQL terminal to connect to the database and execute administration commands.
Access · 5
This skill
/backup/postgres
Deletes backups older than seven days (irreversible)
PostgreSQL
Starts a PostgreSQL standby server
Deletes old database audit logs (irreversible)