PostgreSQL Database Development

About

This skill empowers developers to build and maintain robust PostgreSQL databases by offering comprehensive architectural patterns and automation tools. It covers everything from initial schema normalization and SQLAlchemy model definition to complex Alembic migration workflows and advanced performance tuning. Whether you're implementing full-text search, managing semi-structured data with JSONB, or diagnosing slow queries using EXPLAIN ANALYZE, this skill provides the deep domain expertise and scripts necessary to ensure data integrity and optimal application performance.

Key Features

• Production-safe Alembic migration workflows and SQLAlchemy 2.0 patterns
• Implementation of specialized PostgreSQL features like JSONB and full-text search
• Advanced schema design and normalization patterns (1NF to 3NF)
• Automated diagnostic scripts for index health, query performance, and schema documentation
• Query optimization strategies using EXPLAIN ANALYZE and scan type analysis
• 0 GitHub stars

Use Cases

• Designing and implementing a new normalized database schema with audit trails
• Managing complex data migrations and modernizing legacy SQLAlchemy models
• Optimizing application performance by identifying slow queries and missing indexes