Database Schema Design Guide
botdocs install @botdocs/database-schema-design-guidedev workflowv1
Database Schema Design Guide
A methodology for specifying relational data models covering normalization, indexing, migration, and naming conventions.
Updated 10 days ago
─── paste into your agent
─── or use the CLI
Drops the skill into Claude, Cursor, Codex, or ChatGPT — auto-detects what you have installed.
0 installs
Database Schema Design Guide
A methodology for thinking about and specifying relational data models.
Naming Conventions
- Tables: plural, snake_case (
users,order_items) - Columns: singular, snake_case (
first_name,created_at) - Foreign keys:
[referenced_table_singular]_id(user_id,order_id) - Indexes:
idx_[table]_[columns](idx_users_email) - Constraints:
[type]_[table]_[detail](uq_users_email,fk_orders_user_id)
Normalization Decisions
─── preview
Sign in to read the full skill.
You're viewing a preview — sign in to see the rest of this skill and copy or install it.