This skill provides specialized guidance for writing, reviewing, and modifying SQL targeting PostgreSQL 16–18. It enforces modern standards by favoring identity columns over legacy serial types, ensuring timezone awareness with timestamptz, and implementing advanced features like JSONB, row-level security (RLS), and zero-downtime migration patterns. It helps developers avoid common pitfalls like SQL injection, inefficient pagination, and improper row-level locking, ensuring database schemas are performant, scalable, and secure.
主要功能
01Performance optimization for CTEs and keyset pagination
02Zero-downtime migration patterns and DDL lock management
03Secure implementation of Row Level Security (RLS) and transactions
04Modern schema design using identity columns and UUID v7
050 GitHub stars
06Advanced indexing strategies including partial and covering indexes
