postgres-patterns

What the skill teaches

A short PostgreSQL reference skill from the ECC collection, credited to the Supabase team's guidance. It gives an agent a cheat sheet that matches query patterns to index types, recommended data types, and patterns for query tuning, schema design, row-level security and connection pooling, plus anti-patterns to look for in queries and migrations. It is meant to be loaded when writing SQL or migrations, designing schemas or chasing slow queries, and it refers deeper reviews to a separate database-reviewer agent in the same collection. It is a single instruction file with no scripts.

Capabilities

Details