postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
Best for Database schema designWorks with GitHubLow risk
⌘source
- author
@affaan-m- language
- JavaScript
★159kstars
25kforks
Apr 17, 2026
✦overview.md
Key Features
- ·Index selection cheat sheet for common query patterns
- ·Data type recommendations for IDs, strings, timestamps, and money
- ·Composite index ordering guidance (equality columns first)
- ·Row Level Security implementation patterns
- ·Connection pooling setup guidance
Use Cases
- →Designing new database schemas with appropriate data types
- →Troubleshooting slow queries by selecting correct indexes
- →Implementing Row Level Security for multi-tenant applications
- →Setting up connection pooling for production applications
- →Writing SQL migrations following PostgreSQL best practices
Best for
- ✓Database schema design
- ✓Query performance optimization
- ✓Production PostgreSQL deployments
Not ideal for
- !Non-PostgreSQL databases
- !Complete beginners to SQL
FAQs
name
postgres-patterns
description
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
origin:ECC
PostgreSQL Patterns
Quick reference for PostgreSQL best practices. For detailed guidance, use the database-reviewer 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 |
|---|---|---|
WHERE col = value | B-tree (default) | CREATE INDEX idx ON t (col) |
WHERE col > value | B-tree | CREATE INDEX idx ON t (col) |
WHERE a = x AND b > y | Composite | CREATE INDEX idx ON t (a, b) |
WHERE jsonb @> '{}' | GIN | CREATE INDEX idx ON t USING gin (col) |
WHERE tsv @@ query | GIN | CREATE INDEX idx ON t USING gin (col) |
| Time-series ranges | BRIN | CREATE INDEX idx ON t USING brin (col) |
Data Type Quick Reference
| Use Case | Correct Type | Avoid |
|---|---|---|
| IDs | bigint | int, random UUID |
| Strings | text | varchar(255) |
| Timestamps | timestamptz | timestamp |
| Money | numeric(10,2) | float |
| Flags | boolean | varchar, int |
Common Patterns
$install
1-click copynpx skills add affaan-m/everything-claude-code --skill postgres-patternsSafety assessment
★
Clarity score
How clear and easy to understand the SKILL.md instructions are, rated from 1 to 5.
4/ 5
very goodClear and well structured, with only minor parts that might need a second read.
◎
Actionability score
How directly an agent can act on the SKILL.md instructions, rated from 1 to 5.
3/ 5
mediumPartially actionable with several concrete steps, but still missing important details.