dba-postgres

What problem does it solve?

This Skill streamlines complex PostgreSQL database tasks, ensuring efficient schema design, robust migrations, and optimized query performance for PostgreSQL 16 and later.

Core Features & Use Cases

• Schema Design & Migrations: Create and manage database schemas and Flyway migrations.
• Performance Tuning: Optimize queries using EXPLAIN ANALYZE and implement effective indexing strategies.
• Advanced Features: Leverage partitioning, extensions (like pgvector, PostGIS), and Row Level Security (RLS).
• Use Case: Design a new users table with UUID primary keys, TIMESTAMPTZ for registration dates, and a GIN index on a JSONB column for user preferences, generating the corresponding Flyway migration script.

Quick Start

Use the dba-postgres skill to create a Flyway migration script for a new products table with columns for id, name, description, and price.