postgres-patterns - PostgreSQL Best Practices and Optimization Patterns
PostgreSQL database patterns based on Supabase best practices for query optimization, schema design, indexing and security
Tags
Updated: 2026-02-23Typical Inputs
Typical Outputs
What this skill does
- create database indexes
- design database schemas
- write SQL queries
- optimize slow queries
- implement row-level security
- setup connection pools
Inputs
- PostgreSQL database
- SQL queries
- database schema
Outputs
- optimized queries
- index recommendations
- security policies
Requirements
- PostgreSQL database access
