skills.rest
fabioc-aloha
fabioc-alohaCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

Database Design

Design normalized relational and NoSQL database schemas with indexing strategies.

1|1|Updated Nov 20, 2025
Search Tags:#SQL#database#NoSQL#optimization#schema#migration#data modeling
One-click install
npx skills add https://github.com/fabioc-aloha/AIRS_Data_Analysis --skill database-design-fabioc-aloha
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Design
Source: https://github.com/fabioc-aloha/AIRS_Data_Analysis/tree/main/.github/skills/database-design
Command: npx skills add https://github.com/fabioc-aloha/AIRS_Data_Analysis --skill database-design-fabioc-aloha

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill addresses the challenge of creating efficient, scalable, and maintainable database schemas that align with application needs and performance requirements.

Core Features & Use Cases

  • Schema Design: Guidance on normalization, denormalization, and data modeling patterns.
  • Database Selection: Decision matrices and common choices for SQL and NoSQL databases.
  • Query Optimization: Techniques for improving query speed through indexing and understanding execution plans.
  • Migration Strategies: Best practices for safe and zero-downtime schema changes.
  • Use Case: Design a normalized PostgreSQL schema for a new e-commerce platform, including considerations for indexing and potential denormalization for reporting.

Quick Start

Design a normalized 3NF schema for an e-commerce platform with customers, orders, and products.

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 data integrity and performance?▼

Database schema design for data integrity involves applying normalization to reduce redundancy and indexing strategies to improve query performance. This Skill provides comprehensive guidance on structuring relational and NoSQL databases to align with application needs and scalability requirements.

When should I use normalization versus denormalization in data modeling?▼

Normalization is used to ensure data integrity by eliminating redundancy, while denormalization improves read performance by adding redundancy. This Skill guides you through data modeling patterns to balance integrity and performance based on your specific query requirements.

How do I optimize SQL queries and improve database indexing?▼

SQL query optimization involves analyzing execution plans and applying proper indexing strategies to speed up data retrieval. This Skill covers techniques for improving query speed and managing connections effectively in modern applications.

What is the best way to handle zero-downtime database migration?▼

Zero-downtime database migration requires best practices for safe schema changes without disrupting application availability. This Skill provides migration strategies to ensure smooth transitions when updating your database structure.

How do I choose between SQL and NoSQL databases for my application?▼

Choosing between SQL and NoSQL databases depends on your data structure, scalability needs, and query patterns. This Skill offers decision matrices and common choices to help you select the right database type for your use case.

Related Skills

Explore More Software Engineering Skills→
HechaoYannetHechaoYannet

create-architecture

Generate a master architecture document from GDDs, ADRs, and governance constraints.

Community
Advanced
jrajasekerajrajasekera
1

sqlite-optimization

Optimizes SQLite performance through WAL mode, PRAGMA configuration, indexing, and query tuning.

Community
Intermediate
giosuetedeschi-specgiosuetedeschi-spec

neon-postgres

Configure Neon serverless Postgres connection pooling and ORM driver integration.

Community
Intermediate
afsjrafsjr

reversa-data-master

Generate ERD and markdown documentation from legacy database artifacts.

Community
Advanced