skills.rest
duylinhdang1998
duylinhdang1998COMMUNITY
Explore all skills by this author →
WebsiteGitHub

postgresql

Design and optimize PostgreSQL databases for high-performance production systems.

Updated Apr 16, 2026
Search Tags:#performance#indexing#postgresql#migrations#sql#replication#database-design
One-click install
npx skills add https://github.com/duylinhdang1998/claude-template-agent --skill postgresql-duylinhdang1998
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgresql
Source: https://github.com/duylinhdang1998/claude-template-agent/tree/main/plugins/vfm-agent-company/skills/postgresql
Command: npx skills add https://github.com/duylinhdang1998/claude-template-agent --skill postgresql-duylinhdang1998

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL expertise to design scalable schemas, optimize complex queries, and tune databases for high-throughput workloads.

Core Features & Use Cases

  • Design relational schemas with appropriate data types, constraints, and normalization.
  • Optimize queries using EXPLAIN ANALYZE, indexing strategies (B-tree, GIN), and proper transactional patterns.
  • Ensure reliability with replication, migrations, connection pooling, and maintenance tasks.

Quick Start

Install and configure PostgreSQL for a production-ready deployment with a basic schema and index set.

Frequently Asked Questions about postgresql

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

FAQPage Schema
How do I optimize PostgreSQL queries for high-throughput workloads?▼

Optimize PostgreSQL queries using EXPLAIN ANALYZE to identify bottlenecks. Apply indexing strategies like B-tree for standard lookups and GIN for JSONB or array support, ensuring high-throughput workloads run efficiently.

What is the best way to design scalable PostgreSQL schemas?▼

Design scalable PostgreSQL schemas by selecting appropriate data types, enforcing constraints, and applying normalization. This relational schema design ensures ACID compliance while handling complex data structures like JSONB and arrays.

How does PostgreSQL replication work for production reliability?▼

PostgreSQL replication ensures production reliability by duplicating data across nodes. Combined with connection pooling and proper transactional patterns, it maintains high availability and ensures reliability under heavy traffic.

When do I need GIN indexes in PostgreSQL?▼

You need GIN indexes in PostgreSQL when querying complex data types like JSONB or arrays. They optimize full-text search and array containment queries, which standard B-tree indexes cannot handle efficiently.

How do I execute database migrations without downtime?▼

Execute PostgreSQL migrations without downtime using practical migration strategies that alter schemas while maintaining transactional patterns. This ensures continuous availability during maintenance tasks in production systems.

Related Skills

Explore More Software Engineering Skills→
sitharaj88sitharaj88
1

db-postgres

Generate PostgreSQL schemas, queries, indexes, and replication configurations.

Community
Advanced
pohlai88pohlai88

postgresql-database-engineering

Optimize PostgreSQL performance with indexing, partitioning, and replication strategies.

Community
Advanced
TruCol270TruCol270
1

kotlin-exposed-patterns

Implement Kotlin Exposed ORM patterns for DSL queries, DAO usage, and transactions.

Community
Advanced
v1bh0rv1bh0r

nw-database-technology-selection

Select database technology by evaluating RDBMS versus NoSQL trade-offs.

Community
Advanced