postgres-standards

To create a PostgreSQL migration that can be safely rolled back, you write schema changes paired with explicit rollback patterns. This Skill helps design database migrations with proper rollback strategies to ensure safe schema changes.

To optimize PostgreSQL query performance without long-running locks, you add indexes to critical fields and apply safe migration patterns. This Skill improves query performance by implementing targeted index strategies and avoiding locking issues.

The best way to design a PostgreSQL schema with constraints is to define table structures and rules while planning safe alterations. This Skill manages PostgreSQL schema design and changes to ensure proper database constraints.

Yes, you need psycopg2 to interact with your PostgreSQL database for migrations. This Skill requires the psycopg2 dependency to execute schema changes, manage rollbacks, and apply index strategies directly.

You need an index strategy for your PostgreSQL database when optimizing complex queries and improving overall performance. This Skill focuses on adding indexes to critical fields to enhance query performance and avoid long-running locks.