PostgreSQL Database Development

Overview

Master PostgreSQL database development with comprehensive guidance on schema design, migrations, ORM patterns, and advanced PostgreSQL features. This skill provides best practices, reference documentation, and automation scripts for building high-performance, well-structured PostgreSQL databases.

When to Use This Skill

Use this skill when working on:

• Database schema design and normalization
• Creating or reviewing Alembic migrations
• Defining SQLAlchemy models and relationships
• Optimizing slow queries or improving database performance
• Choosing and implementing index strategies
• Working with JSONB for semi-structured data
• Implementing full-text search functionality
• Analyzing database performance issues
• Setting up database projects from scratch