New Skill: Postgres Best Practices from Supabase

We’ve added a new development skill to the directory: Postgres Best Practices from Supabase. This skill helps AI coding agents generate high-quality, production-ready database code by providing structured guidance across critical Postgres topics.

Why This Matters

AI coding assistants can write SQL quickly, but without proper guidance they often generate code with common production pitfalls: missing indexes, RLS bypasses, table-locking migrations, and connection pool exhaustion. This skill addresses those issues directly.

Eight Categories Organized by Impact

The skill contains approximately 30 rules across eight categories, prioritized by their impact on production systems:

Critical Priority

• Query Performance - Write efficient queries and avoid full table scans
• Connection Management - Proper pooling and resource limits
• Security and RLS - Row-level security policies done right

High Priority

• Schema Design - Table structure, data types, and normalization

Medium-High Priority

• Concurrency and Locking - Transaction isolation and deadlock prevention

Medium Priority

• Data Access Patterns - Pagination, bulk operations, and efficient data retrieval

Lower Priority

• Monitoring and Diagnostics - Query analysis and debugging techniques
• Advanced Features - CTEs, window functions, and Postgres extensions

How Rules Are Structured

Each rule follows a consistent format:

1. Title - Clear name for the rule
2. Impact Level - Priority classification
3. Explanation - Why this matters
4. Code Examples - Incorrect vs. correct implementations

This format makes it easy for AI agents to understand both the problem and the solution.

Use Cases

This skill is useful when you need to:

• Optimize slow queries - Get guidance on proper indexing and query structure
• Review schemas - Check table designs for performance issues
• Implement RLS - Write secure row-level security policies
• Handle migrations - Avoid table locks and downtime
• Scale connections - Configure pooling correctly

Works with Supabase MCP

The skill pairs well with Supabase’s MCP server, giving agents both database access capabilities and best practice guidance. You get the tools to execute queries plus the knowledge to write them correctly.

Get Started

Browse the Postgres Best Practices skill in the directory. For detailed documentation, visit the GitHub repository or read the full Supabase blog post.