Database Reliability

Automate PostgreSQL replication, failover, pooling, and backup management.

4|1|Updated Dec 17, 2025

Search Tags:#monitoring #database #postgresql #backup #reliability #high availability #failover

Ready to run

npx skills add https://github.com/lapc506/flutter-agentic-boilerplate --skill database-reliability-lapc506

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Database Reliability
Source: https://github.com/lapc506/flutter-agentic-boilerplate/tree/main/skills/system-reliability-engineering/database-reliability
Command: npx skills add https://github.com/lapc506/flutter-agentic-boilerplate --skill database-reliability-lapc506

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the critical need for robust database systems by providing comprehensive strategies and tools to ensure high availability, prevent data loss, and maintain optimal performance.

Core Features & Use Cases

High Availability: Implement replication and automatic failover mechanisms to minimize downtime.
Data Protection: Configure reliable backup and recovery strategies to safeguard against data corruption or loss.
Performance Optimization: Utilize connection pooling and monitoring to ensure efficient database resource utilization.
Use Case: For an e-commerce platform, this skill can set up PostgreSQL replication with Patroni for failover, configure daily backups using a Python script, and implement PgBouncer for efficient connection management, ensuring the database remains available even during peak loads or hardware failures.

Quick Start

Implement database replication and failover for PostgreSQL using the database reliability skill.

Frequently Asked Questions about Database Reliability

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I set up PostgreSQL replication and automatic failover?▼

To set up PostgreSQL replication and automatic failover, this skill automates configuration using Patroni, ensuring high availability and minimizing downtime during hardware failures. It provides scripts to manage cluster topology and automated leader election.

What is the best way to configure PostgreSQL backups for production systems?▼

The best way to configure PostgreSQL backups for production systems is using the robust restore strategies provided via Python scripts. This approach safeguards against data corruption or loss by automating daily backup routines and ensuring reliable recovery points.

Can I use PgBouncer for connection pooling with my existing PostgreSQL database?▼

Yes, you can use PgBouncer for connection pooling with your existing PostgreSQL database. This skill configures PgBouncer to ensure efficient database resource utilization and maintain optimal performance, particularly for platforms handling peak traffic loads.

How do I monitor database reliability and set up alerts in Prometheus?▼

You monitor database reliability and set up alerts in Prometheus using the included monitoring configurations and alert rules. This integration tracks replication status and resource utilization, alerting you to potential uptime or integrity issues before system degradation.

Do I need Python to run the database reliability scripts?▼

Yes, you need Python to execute the database reliability scripts. The skill relies on Python scripts to automate daily backup routines and manage robust restore strategies for your PostgreSQL production environment.

When do I need to implement high availability for PostgreSQL?▼

You need to implement high availability for PostgreSQL when your production system requires minimal downtime and continuous data access. This is critical for e-commerce platforms where hardware failures or peak traffic loads must not disrupt database uptime and integrity.