
Database Schema Designer
This handles the full lifecycle of database design, from initial schema generation to migration scripts. Feed it your data model (users, products, orders) and you get normalized SQL or NoSQL schemas with proper foreign keys, indexes, and constraints. The normalization guides are thorough, walking through 1NF to 3NF with before/after examples. It includes a solid anti-patterns section that catches common mistakes like using FLOAT for money or missing FK indexes. The verification checklist is legitimately useful for code reviews. Best for greenfield projects or major refactors where you want to avoid the usual schema debt, though it assumes you can articulate your access patterns upfront.
- skills.sh installs
- 489
- GitHub stars
- 33.2K
- last updated
- Aug 21, 2026
Install
$ npx -y skills add davila7/claude-code-templates --skill database-schema-designer --agent claude-codeInstalls into .claude/skills of the current project.
Files
Database Schema Designer
Design production-ready database schemas with best practices built-in.
Quick Start
Just describe your data model:
design a schema for an e-commerce platform with users, products, orders
You'll get a complete SQL schema like:
CREATE TABLE users (
id BIGINT AUTO_INCREMENT PRIMARY KEY,
email VARCHAR(255) UNIQUE NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE orders (
id BIGINT AUTO_INCREMENT PRIMARY KEY,
user_id BIGINT NOT NULL REFERENCES users(id),
total DECIMAL(10,2) NOT NULL,
INDEX idx_orders_user (user_id)
);
What to include in your request:
- Entities (users, products, orders)
- Key relationships (users have orders, orders have items)
- Scale hints (high-traffic, millions of records)
- Database preference (SQL/NoSQL) - defaults to SQL if not specified
Triggers
Sponsors
Details
- Repository
- github.com/davila7/claude-code-templates
- Categories
- Backend & APIs, Debugging, Design & UI/UX, Databases
- First seen
- Jun 3, 2026
More from davila7/claude-code-templates
All 618- Typescript Expert489
- Api Patterns486
- Skill Creator484
- Supabase Postgres Best Practices481
- File Organizer480
- Research Engineer478
- Llama Cpp475
- App Builder474
- Security Review471
- Api Security Best Practices466
- Senior Secops466
- Long Context465
- Autogpt Agents464
- Parallel Agents463
- Serving Llms Vllm461
- Llamaindex460
- Code Review457
- Computer Use Agents455
- Powershell Windows454
- React Useeffect454
- Backend Patterns452
- Find Bugs447
- Langgraph447
- Agent Md Refactor446