wode-db-schema-pattern
CommunityDesign Wode PostgreSQL schemas correctly.
Software Engineering#schema design#postgresql#multi-tenant#naming conventions#ulid#uuidv7#jsonb modeling
Authorwenerme
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill prevents inconsistent PostgreSQL schema designs by enforcing a strict, repeatable pattern for Wode table structure, naming, identifiers, and multi-tenant isolation.
Core Features & Use Cases
- Schema design guardrails: Enforces required naming rules, allowed data types, and consistent field suffix conventions.
- ID and tenancy standards: Requires composite primary keys (tid, id), K-sortable random IDs (ULID/UUIDv7), and tenant-scoped uniqueness.
- Flexible data modeling: Standardizes how to separate
attributes,properties,extensions, andmetadatafor client vs server usage. - Polymorphic association consistency: Requires
_id/_typesuffixes and discriminator enum conventions.
Quick Start
Ask for a new PostgreSQL table schema for a Wode resource and specify that it must follow the wode-db-schema-pattern rules for identifiers, tenancy, and field templates.
Dependency Matrix
Required Modules
None requiredComponents
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: wode-db-schema-pattern Download link: https://github.com/wenerme/ai/archive/main.zip#wode-db-schema-pattern Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.