skills.rest
dtsong
dtsongCOMMUNITY
Explore all skills by this author →
GitHub

Schema Design

Design relational database schemas with normalization, indexes, and migration-ready SQL.

1|1|Updated Feb 21, 2026
Search Tags:#indexing#schema design#database#migration#sql#normalization
One-click install
npx skills add https://github.com/dtsong/claude-code-windows-setup --skill schema-design-dtsong
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Schema Design
Source: https://github.com/dtsong/claude-code-windows-setup/tree/main/skills/council/architect/schema-design
Command: npx skills add https://github.com/dtsong/claude-code-windows-setup --skill schema-design-dtsong

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the process of designing robust, normalized, and indexed database schemas, ensuring they are ready for immediate implementation and future migrations.

Core Features & Use Cases

  • Database Schema Design: Create relational database schemas with normalization and indexing strategies.
  • Migration Planning: Generate migration-ready SQL scripts for database changes.
  • Use Case: Design a new schema for a social media platform, including user profiles, posts, comments, and relationships, complete with optimized indexes and migration scripts.

Quick Start

Design a new database schema for a blog application, including tables for posts, authors, and comments.

Frequently Asked Questions about Schema Design

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a migration-ready database schema with proper SQL normalization?▼

To design a migration-ready database schema, define relational entities, attributes, and relationships using SQL normalization, then generate migration-ready scripts with optimized indexing strategies.

What's the best way to plan database migrations for an existing schema?▼

Plan database migrations for an existing schema by analyzing current query patterns and access control to generate normalized SQL scripts that apply structural changes and row-level security policies.

How does indexing strategy affect database schema design?▼

Indexing strategy affects database schema design by optimizing query patterns and access paths, ensuring that migration-ready SQL scripts include efficient indexes tailored to relational entities and attributes.

Can I include row-level security policies when designing a new database schema?▼

Yes, you can include row-level security policies when designing a new database schema by defining access control rules and integrating them into the migration-ready SQL scripts.

Do I need to analyze query patterns before normalizing a database schema?▼

Yes, analyzing query patterns is necessary before normalizing a database schema to ensure the relational entities, attributes, and indexing strategies align with actual data access requirements.

Related Skills

Explore More Software Engineering Skills→
guardiatechnologyguardiatechnology

kata-schema-design

Design relational or NoSQL database schemas with ER diagrams and constraints.

Official
Advanced
jtucker9jtucker9

memstack-development-database-architect

Design PostgreSQL/Supabase schemas with RLS policies and migration SQL.

Community
Advanced
GDSDNGDSDN
3

db-domain-modeling

Design relational database schemas and generate SQL migration files.

Community
Advanced
williamzujkowskiwilliamzujkowski
6

Database Schema Designer

Design normalized database schemas, ER diagrams, and migration plans from business requirements.

Community
Intermediate