Skills
.Work. You
Rest

postgres-schema

Official

PostgreSQL schema design, best practices.

Software Engineering#indexing#postgresql#migration#constraints#schema-design#data-types
Authoreco2-team
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill provides a concise blueprint for designing scalable PostgreSQL schemas, covering naming conventions, data types, constraints, indexing, and migration patterns to help teams build maintainable databases.

Core Features & Use Cases

  • Schema design principles: TIMESTAMPTZ usage, data type strategy, and normalization guidelines to ensure consistency.
  • Naming conventions and standard templates for schemas, tables, columns, PK/FK constraints, and indexes.
  • Migration patterns: versioned migrations, soft delete patterns, and audit-friendly timestamps.
  • Use Case: When designing a new domain (e.g., chat, users, orders), apply the guide to create coherent schemas quickly.

Quick Start

Define a new schema using the standard template and create the primary tables with appropriate PKs, FKs, and indexes.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: postgres-schema
Download link: https://github.com/eco2-team/backend/archive/main.zip#postgres-schema

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.