skills.rest
williamzujkowski
williamzujkowskiCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

PostgreSQL Database Architect

Plan and optimize PostgreSQL architectures for OLTP and OLAP workloads.

6|Updated Oct 25, 2025
Search Tags:#postgresql#partitioning#replication#performance-tuning#schema-design#high-availability#database-architecture
One-click install
npx skills add https://github.com/williamzujkowski/cognitive-toolworks --skill postgresql-database-architect
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: PostgreSQL Database Architect
Source: https://github.com/williamzujkowski/cognitive-toolworks/tree/main/skills/database-postgres-architect
Command: npx skills add https://github.com/williamzujkowski/cognitive-toolworks --skill postgresql-database-architect

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Design and optimize PostgreSQL databases for performance, reliability, and scalability across OLTP and OLAP workloads.

Core Features & Use Cases

  • Schema design and normalization up to 3NF with indexing strategies and partitioning.
  • Performance tuning with table partitioning, indexing, and configuration guidelines.
  • HA and replication planning for high availability and disaster recovery.

Quick Start

Design a production-ready PostgreSQL architecture for a 100GB OLTP workload on a mid-range server.

Frequently Asked Questions about PostgreSQL Database Architect

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

FAQPage Schema
How do I design a PostgreSQL schema for high-performance OLTP workloads?▼

PostgreSQL performance tuning involves optimizing table partitioning, refining indexing strategies, and adjusting postgresql.conf settings. These adjustments improve query latency and resource utilization across database architectures.

How does PostgreSQL replication work for high availability planning?▼

PostgreSQL partitioning manages large tables by dividing data into smaller physical segments based on defined rules. This schema design technique enhances query performance and simplifies maintenance for large OLAP and OLTP workloads.

Can I use this PostgreSQL architecture approach for both cloud and on-premises deployments?▼

Yes, this PostgreSQL architecture planning applies to both cloud and on-premises environments. It accommodates multi-node configurations and scales effectively for mid-range servers handling substantial 100GB workloads.

What's the best way to plan PostgreSQL high availability and disaster recovery?▼

The best way to plan PostgreSQL high availability is configuring multi-node replication and disaster recovery strategies. This architecture design ensures continuous database uptime and reliable failover for critical workloads.

Related Skills

Explore More Software Engineering Skills→
hung-phanhung-phan

oltp-vs-olap

Analyze workload characteristics to select between OLTP and OLAP databases.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

managing-database-replication

Configure master-slave replication and automatic failover for PostgreSQL and MySQL deployments.

Community
Advanced
MarcoDavaMarcoDava
1

V3 MCP Optimization

Optimize Codex-flow v3 MCP server performance with connection pooling and load balancing.

Community
Advanced
MovchanetsMovchanets

database-admin

Plan and validate database administration workflows for cloud and self-managed environments.

Community
Advanced