postgres-standards

What problem does it solve?

This Skill helps you manage and optimize your PostgreSQL database, ensuring efficient migrations, schema design, query performance, and index strategies.

Core Features & Use Cases

• Schema Management: Design and change database schemas with proper rollback strategies.
• Migration Practices: Write and review migrations with rollback capabilities and safe migration patterns.
• Query Optimization: Improve query performance by adding indexes to critical fields and avoiding long-running locks.
• Use Case: When you need to create a new table with specific constraints, ensure migrations can be rolled back, or optimize a complex query for better performance.

Quick Start

Run the migration and add an index to the 'user_name' field for optimized query performance.