skills.rest
pohlai88
pohlai88COMMUNITY
Explore all skills by this author →
GitHub

database-schema-designer

Design SQL and NoSQL database schemas with normalization, keys, constraints, indexing, and reversible migrations.

Updated Apr 5, 2026
Search Tags:#design#SQL#database#NoSQL#migrations#schema#normalization
One-click install
npx skills add https://github.com/pohlai88/afenda-vite-react --skill database-schema-designer-pohlai88
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-designer
Source: https://github.com/pohlai88/afenda-vite-react/tree/main/.agents/skills/database-schema-designer
Command: npx skills add https://github.com/pohlai88/afenda-vite-react --skill database-schema-designer-pohlai88

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Designing robust, scalable database schemas across SQL and NoSQL stores to ensure data integrity and smooth migrations.

Core Features & Use Cases

  • Normalize data with 1NF–3NF guidance for SQL systems to eliminate redundancy and anomalies.
  • Define robust constraints, primary/foreign keys, data types, and indexing strategies to support reliable applications.
  • Plan and implement reversible migrations with zero-downtime approaches for evolving schemas in production environments.

Quick Start

Design a schema for an e-commerce platform with users, products, and orders.

Frequently Asked Questions about database-schema-designer

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

FAQPage Schema
How do I design a database schema for both SQL and NoSQL workloads?▼

Database schema design for SQL and NoSQL involves applying normalization for relational stores and defining constraints with indexing strategies for NoSQL to ensure data integrity and scalable performance.

What is the best way to normalize SQL database schemas to eliminate data redundancy?▼

Normalizing SQL database schemas requires applying 1NF through 3NF guidance to eliminate data redundancy and update anomalies while defining primary and foreign keys to maintain reliable application data.

How do I plan reversible database migrations with zero downtime?▼

Planning reversible database migrations with zero downtime involves creating schema evolution strategies that enforce data integrity constraints, supporting production environments by allowing safe rollbacks during schema transitions.

When do I need to apply normalization and indexing strategies during schema evolution?▼

You need to apply normalization and indexing strategies during project inception and schema evolution to maintain data integrity, ensuring scalable performance as database schemas require reversible migrations in production.

Does schema design work for NoSQL databases or only SQL systems?▼

Schema design works for both SQL and NoSQL databases, enforcing indexing strategies for NoSQL workloads while applying normalization and primary or foreign key constraints specifically for SQL systems.

Related Skills

Explore More Software Engineering Skills→
nashirabbashnashirabbash

database-schema-design

Design normalized SQL and NoSQL schemas with keys, indexes, and constraints.

Community
Advanced
UnlimitedxIQUnlimitedxIQ

database-migrations

Standardizes and safely executes database migrations across PostgreSQL, MySQL, and common ORMs.

Community
Advanced
vix-4800vix-4800
1

database-patterns

Review database schemas, migrations, and ORM query strategies for safe data evolution.

Community
Intermediate
officechbusinessservices-creatorofficechbusinessservices-creator

postgres-patterns

Identify PostgreSQL performance bottlenecks in queries, indexing, and schema design.

Community
Advanced