postgresql-architecture
CommunityDesign robust PostgreSQL architectures
Software Engineering#postgresql#partitioning#replication#schema-design#database-design#ha#multitenancy
Authorrandoneering
Version1.0.0
Installs0
System Documentation
What problem does it solve?
PostgreSQL architecture and design patterns are essential for building scalable, reliable data systems. This skill provides a structured approach to schema design, partitioning, high availability, multi-tenancy, and performance optimization.
Core Features & Use Cases
- Partitioning strategies (range, list, hash, multi-level) to enable pruning and lifecycle management.
- High availability architectures (streaming replication, Patroni, failover) for automated resilience.
- Multi-tenancy models (shared schema, separate schemas, separate databases) for SaaS scalability.
- Schema design patterns and data modeling best practices for robust systems.
Quick Start
Audit your data access patterns and implement a partitioning strategy, then apply HA, multi-tenancy, and pooling patterns.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: postgresql-architecture Download link: https://github.com/randoneering/nix-flake-mirror/archive/main.zip#postgresql-architecture Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.