Individual skill

database-designer

Design a database schema: tables, relationships, indexes, normalization, SQL vs NoSQL, migration plans. Use whenever the user asks how to structure their data, which database to pick, or before writing DDL.

engineering/skills/database-designer/SKILL.md

Read pinned source

Source commit 8f082544116fc0d014188e521ca40304cdfc86b0

What was checked

Matches the observed repository HEAD: Yes
Scanner rules are current: Yes
Repository scan complete: No
Skill scan complete: No
Observed behavior: Network or broad shell
Last checked: Nov 10, 2026

These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.

Install this skill

Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.

An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.

Repository context

Repository stars (not skill ratings): 29,647
Repository last updated: Nov 11, 2026
License: MIT

Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.

agentic-ai Repository topic
anthropic-claude Repository topic
claude-ai Repository topic
claude-code Repository topic
claude-skills Repository topic
claude-code-skills Repository topic
ai-coding-agent Repository topic
claude-code-plugins Repository topic
developer-tools Repository topic
openai-codex Repository topic
data Derived category
design Derived category
writing Derived category
data-databases Derived category

Files and excerpt

File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.

Browse files

README.mddoc · 11,966 bytes
SKILL.mdcore · 13,245 bytes
SKILL.mdcore · 13,245 bytes
SKILL.mdcore · 13,245 bytes
SKILL.mdcore · 13,245 bytes
SKILL.mdcore · 13,245 bytes
assets/sample_query_patterns.jsonasset · 9,244 bytes
assets/sample_schema.jsonasset · 9,365 bytes
assets/sample_schema.sqlasset · 8,301 bytes
expected_outputs/index_optimization_sample.txtdoc · 2,639 bytes
expected_outputs/migration_sample.txtdoc · 4,509 bytes
expected_outputs/schema_analysis_sample.txtdoc · 7,474 bytes
index_optimizer.pyruns · 38,896 bytes
migration_generator.pyruns · 50,373 bytes
references/database-design-reference.mddoc · 14,014 bytes
references/database_selection_decision_tree.mddoc · 16,344 bytes
references/index_strategy_patterns.mddoc · 11,831 bytes
references/normalization_guide.mddoc · 10,672 bytes
schema_analyzer.pyruns · 42,034 bytes

Read excerpt


# Database Designer - POWERFUL Tier Skill

## Overview

A comprehensive database design skill that provides expert-level analysis, optimization, and migration capabilities for modern database systems. This skill combines theoretical principles with practical tools to help architects and developers create scalable, performant, and maintainable database schemas.

## Core Competencies

### Schema Design & Analysis
- **Normalization Analysis**: Automated detection of normalization levels (1NF through BCNF)
- **Denormalization Strategy**: Smart recommendations for performance optimization
- **Data Type Optimization**: Identification of inappropriate types and size issues
- **Constraint Analysis**: Missing foreign keys, unique constraints, and null checks
- **Naming Convention Validation**: Consistent table and column naming patterns