postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices. Use when designing PostgreSQL schemas, indexes, or RLS policies, or when a query is too slow.
- installs 8w
- 1,821
- 30-day movement
- starts with the next reading
- Related entries
- 9
- Connections
- 0
A SKILL.md agent skill that provides PostgreSQL best practices covering query optimization, schema design, indexing, and security, based on Supabase practices. It includes a quick reference with index and data-type cheat sheets, composite index ordering, anti-pattern detection, and a configuration template.
Reach for it when designing PostgreSQL schemas, indexes, or RLS policies, or when a query is too slow and you want established patterns loaded into the agent's context.
Use it to
- Design PostgreSQL schemas and indexes
- Write SQL queries or migrations
- Troubleshoot slow queries
- Implement Row Level Security policies
- Set up connection pooling
For Developers writing PostgreSQL SQL, migrations, or RLS policies
- Host repository
- affaan-m/ECC
- Installs, lifetime
- 3,300
- Installs, 8 weeks
- 1,821
- Host stars
- 261k
- Host language
- JavaScript