skills.rest
saajunaid
saajunaidCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Design database schemas, migrations, and optimization patterns for relational and NoSQL databases.

Updated Feb 20, 2026
Search Tags:#indexing#migration#sql#normalization#query-optimization#schema-design#database-design
One-click install
npx skills add https://github.com/saajunaid/junai --skill database-design-saajunaid
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/saajunaid/junai/tree/main/.github/skills/data/database-design
Command: npx skills add https://github.com/saajunaid/junai --skill database-design-saajunaid

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Designing and maintaining robust database schemas, migration plans, and performance optimizations to ensure data integrity and scalable data models across PostgreSQL, MySQL, and NoSQL databases.

Core Features & Use Cases

  • Schema design best practices, including normalization and denormalization strategies for OLTP and analytics workloads.
  • Safe migrations and upgrade patterns, including zero-downtime techniques and backfill strategies.
  • Use Case: Architect a scalable e-commerce catalog with stable schemas and fast query performance.

Quick Start

Analyze existing data requirements and outline a minimal, safe schema and a migration plan in plain language.

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 both OLTP and analytics workloads?▼

Schema design for mixed workloads involves applying normalization for OLTP integrity and strategic denormalization for analytics speed. This Skill outlines patterns to balance data integrity constraints with query performance tuning across relational and NoSQL databases.

What is the best way to plan zero-downtime database migrations?▼

Safe database migrations use zero-downtime techniques and backfill strategies to upgrade schemas without service interruption. This Skill generates migration plans that deploy schema changes securely while maintaining strong data integrity constraints.

How does indexing and query optimization work for SQL and NoSQL databases?▼

Indexing and query optimization improve data retrieval speed by structuring access patterns for SQL and NoSQL databases. This Skill provides best-practice performance tuning patterns to ensure scalable data models and fast query execution.

Does this database design approach support PostgreSQL and MySQL?▼

Yes, this database design approach supports PostgreSQL and MySQL, alongside NoSQL databases. It applies schema planning, normalization, and safe migration strategies across diverse data models to ensure robust data integrity.

When should I use denormalization in my schema design?▼

Use denormalization in schema design when optimizing analytics workloads that require fast query performance over strict data integrity. This Skill helps determine when to apply normalization versus denormalization strategies for your specific data model.

Related Skills

Explore More Software Engineering Skills→
1molchuan1molchuan
1

oh-my-ccg-init

Verify MCP, Codex, and Gemini endpoints and initialize RPI state.

Community
Intermediate
marcoamumarcoamu
1

PostgreSQL

Optimize PostgreSQL queries, indexes, and schemas for transactional and analytical workloads.

Community
Advanced
marquesfelipmarquesfelip

sql-injection-prevention

Identify and fix SQL injection vulnerabilities in data access layers.

Community
Advanced
devCharuzudevCharuzu

database-designer

Design database schemas with normalization checks and ERD generation.

Community
Advanced