pg-schema-conventions

What problem does it solve?

This skill standardizes multi-tenant database design by enforcing PostgreSQL 18 naming conventions, data-type rules, and mandatory audit columns for every table, reducing drift and review time.

Core Features & Use Cases

• Enforces tenant schema naming using t_{8hex} prefixes.
• Mandates standard columns (id UUID, created_at, updated_at, created_by, updated_by, is_deleted, deleted_at, version).
• Specifies allowed and forbidden data types and constraints to avoid risky migrations.
• Enforces COMMENT ON conventions to document schemas and columns.
• Use cases include onboarding new tables, auditing existing schemas, and validating migrations for compliance across tenants.

Quick Start

Activate this skill at the start of any new table design or migration to enforce the platform's multi-tenant schema conventions.