skills.rest
hyukudan
hyukudanCOMMUNITY
Explore all skills by this author →
Website𝕏@kireistudiosGitHub

database-design

Guide database schema design for SQL and NoSQL systems.

1|Updated Jan 6, 2026
Search Tags:#performance#schema design#database#postgresql#sql#nosql#mongodb
One-click install
npx skills add https://github.com/hyukudan/ai-skills --skill database-design-hyukudan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/hyukudan/ai-skills/tree/main/examples/skills/database-design
Command: npx skills add https://github.com/hyukudan/ai-skills --skill database-design-hyukudan

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides comprehensive guidance on designing efficient and scalable database schemas for both SQL and NoSQL databases, helping you avoid common pitfalls and build a solid data foundation.

Core Features & Use Cases

  • Normalization & Denormalization: Understand principles for organizing data effectively.
  • Indexing Strategies: Learn how to optimize query performance.
  • SQL & NoSQL Patterns: Explore specific design patterns for relational and document databases.
  • Scaling & Migration: Get advice on planning for growth and safe data transitions.
  • Use Case: You are starting a new web application and need to design the user and post tables. This Skill will guide you through creating normalized tables, defining relationships, and setting up appropriate indexes for optimal performance.

Quick Start

Provide guidance on designing a PostgreSQL database schema for a social media application, focusing on user and post data.

Frequently Asked Questions about database-design

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

FAQPage Schema
How do I design a database schema for a new web application?▼

Database schema design involves normalizing data to eliminate redundancy, defining relationships between tables, and establishing indexing strategies to optimize query performance for your specific application requirements.

What is the difference between normalization and denormalization in SQL databases?▼

Normalization organizes data to reduce redundancy and improve integrity, while denormalization intentionally introduces redundancy to improve read performance. Choosing the right SQL pattern depends on your specific query patterns and scaling needs.

How do I optimize PostgreSQL indexes for better query performance?▼

Optimizing PostgreSQL indexes requires analyzing query patterns and applying appropriate indexing strategies. This guidance includes specific code examples and best practices for setting up indexes that maximize query performance.

When should I use NoSQL like MongoDB instead of a relational database?▼

Choose NoSQL like MongoDB when your application requires flexible schema design patterns for document-based data, whereas relational databases like PostgreSQL are better suited for structured data requiring strict normalization and complex relationships.

What's the best way to plan a database migration without downtime?▼

Planning a database migration requires assessing scaling patterns and applying safe data transition techniques. This guidance covers migration planning strategies to ensure data integrity and minimize downtime during schema changes.

Does this database design guidance cover both PostgreSQL and MongoDB?▼

Yes, this guidance covers both SQL and NoSQL databases. It includes specific design patterns and best practices for relational databases like PostgreSQL and MySQL, as well as document databases like MongoDB and Redis.

Related Skills

Explore More Software Engineering Skills→
musujmusuj

phase-1-schema

Define project terminology, entities, relationships, and data structures.

Community
Intermediate
george11642george11642
2

db-supabase

Execute SQL, apply migrations, and deploy edge functions via Supabase MCP tools.

Community
Intermediate
CJ-1981CJ-1981

moai-domain-database

Design and optimize PostgreSQL, MongoDB, Redis, and Oracle database schemas and queries.

Community
Advanced
HeldinhowHeldinhow
4

database-migrations

Manage database schema changes through version-controlled migration scripts.

Community
Intermediate