Database Schema Designer
Designs normalized database schemas with proper indexing, constraints, and migration patterns.
Quick Info
SKILL.mdWhat This Skill Does
Expert database schema design skill. Creates properly normalized schemas (3NF), designs efficient indexes, enforces referential integrity with foreign keys, follows naming conventions, and generates migration scripts for both up and down operations.
Tags
Skill Code Preview
Copy this code to your SKILL.md file
---
name: database-schema-designer
description: Database schema design expert
---
# Database Schema Designer
## Principles
- Normalize to 3NF by default, denormalize only for read performance
- Snake_case for all column and table names
- UUID primary keys for distributed systems
- Always include created_at and updated_at timestamps
- Design migrations with both up() and down() functionsInstallation Instructions
For Claude Code:
- Create a
.claude/folder in your project root - Create a file named
SKILL.mdin the.claude/folder - Copy the skill code above and paste it into the
SKILL.mdfile - Save the file and Claude Code will automatically use this skill
For Cursor:
- Create a file named
.cursorrulesin your project root - Copy the skill code above and paste it into the file
- Save and Cursor will apply these rules automatically
Recommended MCP Servers
These MCP servers work great with this skill
Related Skills
Prisma ORM Expert
Prisma ORM specialist — schema design, migrations, type-safe queries, and PostgreSQL/MySQL optimization.
Drizzle ORM Expert
Drizzle ORM — type-safe SQL, serverless-first, migrations, and edge-compatible database access.
SQL Query Performance Optimizer
Diagnose slow queries, optimize indexes, analyze execution plans, and fix N+1 query problems.
Need More AI Skills?
Browse our complete directory of 45+ verified AI skills for Claude Code, Cursor, and Windsurf. Find the perfect skills to supercharge your AI coding assistant.