LogoClawIndex
CasesSkillsAbout
LogoClawIndex

postgresql - Design PostgreSQL database schemas

Designs PostgreSQL-specific schemas using appropriate data types, constraints, indexes, performance patterns, and advanced features.

Tags

Updated: 2026-10-03
PostgreSQLdatabase schemadata modelingindexingconstraintsdatabase performance

Capabilities

Capture entities and access patternsChoose types and constraintsAdd indexes for query pathsValidate indexes with EXPLAIN

Typical Inputs

Entity definitionsQuery access patternsScale targets

Typical Outputs

Schema design guidanceData type recommendationsConstraint definitions

What this skill does

  • Capture entities and access patterns
  • Choose types and constraints
  • Add indexes for query paths
  • Validate indexes with EXPLAIN
  • Plan partitioning and RLS
  • Review migration impact
  • Apply schema changes safely

Inputs

  • Entity definitions
  • Query access patterns
  • Scale targets
  • Retention requirements
  • Access control requirements
  • Migration context

Outputs

  • Schema design guidance
  • Data type recommendations
  • Constraint definitions
  • Indexing recommendations
  • Partitioning and RLS plans
  • Migration safety guidance

Requirements

    Source

    • Spec: SKILL.md

    ClawIndex

    OpenClaw Skills & Use Case Index

    ClawIndex is an ecosystem-driven index of OpenClaw skills and real-world use cases.

    Index

    Skills·
    Cases

    Meta

    About·
    Disclaimer·
    Email·
    GitHub
    © 2026 ClawIndex All Rights Reserved.