postgres-core-schema-design - Design secure PostgreSQL schemas from the start
Guides PostgreSQL naming, identity columns, schema layouts, search_path hardening, public-schema security, and multi-tenant design decisions.
Tags
Updated: 2026-10-15Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Choose identity column strategies
- Apply snake_case naming
- Design multi-schema layouts
- Harden search_path resolution
- Evaluate tenant isolation models
- Audit SECURITY DEFINER functions
Inputs
- PostgreSQL version
- Database schema context
- Naming requirements
- Tenant count
- Isolation requirements
- SECURITY DEFINER function definitions
Outputs
- Schema design recommendations
- Identifier naming decisions
- Identity column recommendations
- Tenant layout recommendations
- search_path hardening guidance
- Public schema security guidance
Requirements
- Claude Code environment
- PostgreSQL 15, 16, or 17