PostgreSQL Patterns Quick reference for PostgreSQL best practices. For detailed guidance, use the agent. When to Activate - Writing SQL queries or migrations - Designing database schemas - Troubleshooting slow queries - Implementing Row Level Security - Setting up connection pooling Quick Reference Index Cheat Sheet | Query Pattern | Index Type | Example | |--------------|------------|---------| | | B-tree (default) | | | | B-tree | | | | Composite | | | | GIN | | | | GIN | | | Time-series ranges | BRIN | | Data Type Quick Reference | Use Case | Correct Type | Avoid | |----------|------------…