Postgres Patterns
affaan-m/eccWorking with PostgreSQL databases can be tricky. This quick reference helps you write better SQL queries and design faster schemas. It covers indexing, row level security, and other best practices from Supabase. Use it when you need to tune performance or set up connection pooling.
Developers who write migrations or troubleshoot slow queries will find this guide useful. It includes cheat sheets for index types, data types, and common patterns like UPSERT and cursor pagination. It also shows how to detect anti-patterns like unindexed foreign keys.
Following these patterns keeps your database secure and efficient. The guide is built on real world experience from the Supabase team. It is a handy tool for anyone building applications with PostgreSQL.
Add Postgres Patterns skill to your workflow
Global
mkdir -p ~/.claude/skills/postgres-patternsProject
mkdir -p .claude/skills/postgres-patternsSource Repository
More Databases Claude Code Skills
Supabase Postgres Best Practicessupabase/agent-skills
Follow Supabase's expert guidelines for faster Postgres queries and smarter schema design
Firebase Data Connectfirebase/agent-skills
Build secure PostgreSQL backends with Firebase using GraphQL schemas and type-safe SDKs
Convex Migration Helperget-convex/agent-skills
Plan and run safe Convex schema migrations without downtime or data loss
Firebase Firestorefirebase/agent-skills
Master Cloud Firestore setup, queries, full-text search, security rules, and indexes
Neon Postgresneondatabase/agent-skills
Set up and manage Neon Serverless Postgres with ease and speed
Firebase Firestore Standardfirebase/agent-skills
Set up and secure Cloud Firestore with clear provisioning rules and SDK guides
Firebase Firestore Enterprise Native Modefirebase/agent-skills
Master Firestore Enterprise Native Mode provisioning data modeling security rules and SDK usage
Postgresql Table Designwshobson/agents
Design PostgreSQL tables with best practices for performance and reliability