postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing
by affaan-mFree
Description
postgres-patterns is an agent skill from the ECC collection by affaan-m, listed on skills.sh. It is a quick reference of PostgreSQL practice for query optimisation, schema design, indexing and security, based on Supabase's best practices. It includes an index cheat sheet and covers Row Level Security, connection pooling, and troubleshooting slow queries. For detailed guidance the skill points to a separate database-reviewer agent. It applies when an agent is writing SQL queries or migrations, designing schemas, investigating slow queries, implementing Row Level Security, or setting up connection pooling. Because it is a SKILL.md file of instructions, the agent loads it for those tasks and applies the same conventions. It is free and open source, and the skills.sh listing shows all three security audits passing.…
Highlights
- Query optimisation and schema design
- Index cheat sheet
- Row Level Security
- Connection pooling
Ratings & Reviews
No ratings yet
Be the first to rate postgres-patterns.
People also visit
postgres-patterns FAQ
What does the postgres-patterns skill do?
It gives an agent a quick reference of PostgreSQL practice for queries, schemas, indexes, Row Level Security and connection pooling.
Where is it based?
The listing says it draws on Supabase best practices.
Is there a deeper reference?
For detailed guidance, the skill points to the database-reviewer agent.
How do I install it?
Run: npx skills add https://github.com/affaan-m/ecc --skill postgres-patterns
Is it free?
Yes. It is free and open source.
Are there security findings?
The skills.sh listing shows Gen Agent Trust Hub, Socket and Snyk all passing.
What are the best postgres-patterns alternatives?
Popular alternatives to postgres-patterns include database-migrations, mysql-patterns and query-writing. See all postgres-patterns alternatives