Postgres Best Practices
neondatabase/postgres-skillsPostgres is a powerful database used by many applications. This guide covers the best ways to work with it. You will learn about schema design, indexing strategies, and query optimization.
These best practices help you build fast and reliable database systems. They also cover migrations and common pitfalls to avoid. Follow these rules to keep your database healthy.
Whether you are a developer or a database administrator, this skill is for you. Use it when writing SQL, designing tables, or setting up a Postgres database. You will save time and prevent problems.
Add Postgres Best Practices skill to your workflow
Global
mkdir -p ~/.claude/skills/postgres-best-practicesProject
mkdir -p .claude/skills/postgres-best-practicesSource 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