Database Design
Database schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases. Use for designing schemas, writing migrations, or optimizing queries.
Install
npx skills add MoizIbnYousaf/ai-agent-skills --skill database-designgit clone --depth 1 https://github.com/MoizIbnYousaf/ai-agent-skills.git /tmp/ai-agent-skills
mkdir -p ~/.claude/skills
cp -r /tmp/ai-agent-skills/skills/database-design ~/.claude/skills/database-designPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Database Design ## Schema Design Principles ### Normalization Guidelines ```sql -- 1NF: Atomic values, no repeating groups -- 2NF: No partial dependencies on composite keys -- 3NF: No transitive dependencies -- Users table (normalized) CREATE TABLE users ( id SERIAL PRIMARY KEY, email VARCHAR(255) UNIQUE NOT NULL, created_at TIMESTAMPTZ DEFAULT NOW() ); -- Addresses table (separate entity) CREATE TABLE addresses ( id SERIAL PRIMARY KEY, user_id INTEGER REFERENCES users(id) ON DELETE CASCADE, street VARCHAR(255), city VARCHAR(100), country VARCHAR(100), is_primary BOOLEAN DEFAULT false ); ``` ### Denormalization for Performance ```sql -- When read performance matters more than write consistency CREATE TABLE order_summaries ( id SERIAL PRIMARY KEY, order_id INTEGER REFERENCES orders(id), customer_name VARCHAR(255), -- Denormalized from customers total_amount DECIMAL(10,2), item_count INTEGER, last_updated TIMESTAMPTZ DEFAULT NOW() ); ``` ## Index Design ### Common Index Patterns
Details
- Skill name
database-design- Repository
- MoizIbnYousaf/ai-agent-skills
- Path
skills/database-design/SKILL.md- License
- MIT
- Repo updated
- 21 September 2026
- Listed in
- heilcheng/awesome-agent-skills
FAQ
What does the Database Design skill do?
Database schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases. Use for designing schemas, writing migrations, or optimizing queries.
How do I install the Database Design skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add MoizIbnYousaf/ai-agent-skills --skill database-design. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Database Design popular?
It lives in MoizIbnYousaf/ai-agent-skills, which has 1,160 GitHub stars and 137 forks, and is included in 1 curated skill list.
Related skills
Content Research Writer
1.2kMoizIbnYousaf/ai-agent-skills
Conducts research, adds citations, and improves writing quality. Research topics thoroughly and produce well-cited content.
Changelog Generator
1.2kMoizIbnYousaf/ai-agent-skills
Automatically creates user-facing changelogs from git commits by analyzing commit history, categorizing changes, and transforming technical commits into clear, customer-friendly release notes. Turns hours of manual changelog writing into minutes of automated generation.
Ask Questions If Underspecified
1.2kMoizIbnYousaf/ai-agent-skills
Clarify requirements before implementing. Do not use automatically, only when invoked explicitly.
Database Admin
2krmyndharis/antigravity-skills
Expert database administrator specializing in modern cloud databases, automation, and reliability engineering. Masters AWS/Azure/GCP database services, Infrastructure as Code, high availability, disaster recovery, performance optimization, and compliance. Handles multi-cloud strategies, container databases, and cost optimization. Use for database architecture, operations, or reliability engineering.
Dd Symdb
1kDataDog/pup
Symbol Database - search service symbols, find probe-able methods.
Database Architect
2krmyndharis/antigravity-skills
Expert database architect specializing in data layer design from scratch, technology selection, schema modeling, and scalable database architectures. Masters SQL/NoSQL/TimeSeries database selection, normalization strategies, migration planning, and performance-first design. Handles both greenfield architectures and re-architecture of existing systems. Use for database architecture, technology selection, or data modeling decisions.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.