Database Design

Database schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases. Use for designing schemas, writing migrations, or optimizing queries.

1,160 stars 137 forksDatabases

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add MoizIbnYousaf/ai-agent-skills --skill database-design
Manual install
git 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-design

Personal 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
Read the full skill on GitHub

Details

Skill name
database-design
Path
skills/database-design/SKILL.md
License
MIT
Repo updated
21 September 2026

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.2k

MoizIbnYousaf/ai-agent-skills

Conducts research, adds citations, and improves writing quality. Research topics thoroughly and produce well-cited content.

Writing & ContentIn 1 list137

Changelog Generator

1.2k

MoizIbnYousaf/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.

Git & Code ReviewIn 1 list137

Ask Questions If Underspecified

1.2k

MoizIbnYousaf/ai-agent-skills

Clarify requirements before implementing. Do not use automatically, only when invoked explicitly.

OtherIn 1 list137

Database Admin

2k

rmyndharis/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.

Databases295

Dd Symdb

1k

DataDog/pup

Symbol Database - search service symbols, find probe-able methods.

Databases139

Database Architect

2k

rmyndharis/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.

Databases295

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.