What problem does it solve? Postgres databases often suffer from slow queries, connection exhaustion, missing indexes, and insecure configurations that are hard to diagnose without deep expertise. This Skill gives AI agents and developers a structured, prioritized rule set to write, review, and optimize Postgres queries, schemas, and configurations correctly the first time. ## Core Features & Use Cases - Prioritized Rule Categories: 8 categories ranked by impact, from critical query performance and connection management to advanced features like full-text search and JSONB indexing. - Error-First SQL Examples: Each rule shows an incorrect pattern with explanation, then the correct SQL with quantified impact metrics (e.g., 10-100x faster queries). - Supabase-Specific Guidance: Covers Row-Level Security policies, connection pooling modes, prepared statement handling, and auth-aware optimization patterns. - Use Case: When writing a migration that adds a foreign key, the agent consults the schema rules and automatically adds the required index on the FK column, avoiding slow JOINs and CASCADE operations. ## Quick Start Ask the agent to review your SQL query or schema design against Postgres best practices, for example: review this orders table schema and optimize my slow pagination query.
