Postgresql Table Design
wshobson/agentsPostgreSQL table design is a key skill for building fast and reliable databases. This guide covers how to choose data types, set up indexes, and apply constraints correctly. It helps you avoid common mistakes and get good performance from the start.
Developers and data architects will benefit from these best practices. You learn when to use BIGINT for IDs, why TEXT is better than VARCHAR for strings, and how to handle timestamps with time zones. The skill also explains PostgreSQL quirks like MVCC and vacuum so you can design for long‑term health.
Whether you are creating a new schema or reviewing an existing one, this skill gives you clear rules and real‑world examples. It makes your database easier to maintain and faster to query.
Add Postgresql Table Design skill to your workflow
Global
mkdir -p ~/.claude/skills/postgresql-table-designProject
mkdir -p .claude/skills/postgresql-table-designSource 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
Prisma Database Setupprisma/skills
Set up Prisma with any database PostgreSQL MySQL SQLite and MongoDB