skills.rest
nakano1122
nakano1122COMMUNITY
Explore all skills by this author →
Website𝕏@cafkaf1122GitHub

db-design

Guide relational database schema design for RDBMS and ORM environments.

2|Updated Feb 15, 2026
Search Tags:#database design#indexing#schema design#sql#orm#normalization
One-click install
npx skills add https://github.com/nakano1122/dotfiles --skill db-design
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-design
Source: https://github.com/nakano1122/dotfiles/tree/main/dot_agents/skills/db-design
Command: npx skills add https://github.com/nakano1122/dotfiles --skill db-design

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a comprehensive guide to designing relational databases and their schemas, ensuring data integrity, performance, and maintainability. It tackles the complexity of translating requirements into efficient database structures.

Core Features & Use Cases

  • Database Design Workflow: Guides you through the entire process from entity extraction to migration.
  • Normalization Principles: Explains and applies normalization rules (1NF, 2NF, 3NF) to prevent data redundancy and anomalies.
  • Indexing Strategies: Details how to effectively use indexes for optimal query performance.
  • Relationship Management: Covers 1:1, 1:N, and N:M relationships and their implementation.
  • Use Case: When starting a new project, use this Skill to define the database schema, ensuring it's well-structured, normalized, and optimized for common query patterns.

Quick Start

Use the db-design skill to generate a database schema for a blog platform with posts, users, and comments.

Frequently Asked Questions about db-design

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

FAQPage Schema
How do I design a relational database schema for a new project?▼

To design a relational database schema, you must extract entities, apply normalization rules up to 3NF to prevent anomalies, define relationships, and establish indexing strategies for optimal query performance.

What is the best way to handle normalization and denormalization decisions during data model design?▼

Normalization decisions involve applying 1NF, 2NF, and 3NF principles to eliminate data redundancy, while denormalization intentionally reintroduces redundancy to optimize read performance for specific query patterns.

How do I manage database migrations when updating an existing table design?▼

Database migration management involves systematically applying schema changes to existing relational databases, ensuring data integrity and maintaining synchronization with ORM environments during structural transitions.

How does indexing strategy affect relational database query performance?▼

Indexing strategy improves relational database query performance by creating efficient data retrieval structures, allowing the RDBMS to locate specific records without scanning entire tables during complex SQL operations.

Can I use this database design approach with both RDBMS and ORM environments?▼

Yes, this database design approach explicitly supports both RDBMS and ORM environments, translating requirements into efficient relational database structures while ensuring compatibility with object-oriented application workflows.

How do I implement 1:1, 1:N, and N:M relationships in SQL schema design?▼

Implementing relationships in SQL schema design involves using foreign keys for 1:1 and 1:N connections, and junction tables for N:M relationships to maintain referential integrity across the database.

Related Skills

Explore More Software Engineering Skills→
dtsongdtsong
1

Schema Design

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

Community
Advanced
Nick777-PixelNick777-Pixel

drizzle

Generate TypeScript ORM migrations and models from Drizzle schema definitions for PostgreSQL projects.

Community
Intermediate
rodmena-limitedrodmena-limited
3

moai-domain-database

Provide database schema design, query optimization, and indexing strategies.

Official
Advanced
arbazkhan971arbazkhan971
26

schema

Translate data-domain needs into relational and NoSQL schema designs.

Community
Advanced