Operate the database reliably: pool connections with sane limits, choose the isolation level deliberately (knowing its anomalies), keep transactions short, route replica reads carefully, and test restores — a backup is only real if you've restored it.
Scanned 9/23/2026
Skills Directorynpx -y skills add mcorbett51090/RavenClaude --skill db-reliability --agent claude-codeInstalls into .claude/skills of the current project.
Are you the author of Db Reliability?
Add the live security badge to your README — it updates automatically with every re-scan.
[](https://www.skillsdirectory.com/skills/mcorbett51090-db-reliability)More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.
---
name: db-reliability
description: "Operate the database reliably: pool connections with sane limits, choose the isolation level deliberately (knowing its anomalies), keep transactions short, route replica reads carefully, and test restores — a backup is only real if you've restored it."
---
# Database Reliability
## Pool connections
A pooler (PgBouncer/built-in) with sized limits — an app opening a connection per request exhausts the DB under load.
## Isolation
Read Committed / Repeatable Read / Serializable each permit different anomalies (non-repeatable read, phantom, write skew). **Choose**, and handle what you allow.
## Short transactions
Long txns hold locks, block vacuum, bloat. Keep the critical section minimal.
## Recovery
Replicas are eventually consistent (route read-after-write carefully). **Test the restore** + PITR if RPO demands. A backup you've never restored is a hope.
Is this your skill, or is something wrong with this listing? Request removal or report an issue. Author removals are honored within 72 hours.
No comments yet. Be the first to comment!
