PostgreSQL Database Architect

Name: PostgreSQL Database Architect
Availability: InStock
Author: williamzujkowski

Community

Design high-performance PostgreSQL architectures.

Software Engineering #postgresql #partitioning #replication #performance-tuning #schema-design #high-availability #database-architecture

Authorwilliamzujkowski

Version1.0.0

Installs0

System Documentation

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.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 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 Database Architect
Download link: https://github.com/williamzujkowski/cognitive-toolworks/archive/main.zip#postgresql-database-architect

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.

View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.