backend-data-layer
CommunityDesign scalable DB schemas with access patterns.
Authorlookatitude
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Data modeling for a single bounded domain often leads to mismatches between storage shape and access patterns. This skill provides a structured approach to define tables, columns, keys, and indexes that match expected queries and allow scalable evolution.
Core Features & Use Cases
- Design the persistent shape of a bounded domain: specify tables, columns, PKs, FKs, and constraints aligned to access patterns.
- Indexing strategy: craft indexes supporting top queries, pagination, and performance guarantees.
- Migration-aware planning: include notes for evolution and future migrations while preserving compatibility.
Quick Start
Propose a schema for a bounded domain named X and output the SQL DDL and indexing plan.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 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: backend-data-layer Download link: https://github.com/lookatitude/guild/archive/main.zip#backend-data-layer 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.