skills.rest
JEO-tech-ai
JEO-tech-aiCOMMUNITY
Explore all skills by this author →
GitHub

database-schema-design

Design SQL and NoSQL database schemas with normalization and indexing.

8|Updated Mar 9, 2026
Search Tags:#database#postgresql#migration#mysql#mongodb#schema-design
One-click install
npx skills add https://github.com/JEO-tech-ai/oh-my-unity3d --skill database-schema-design-jeo-tech-ai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-design
Source: https://github.com/JEO-tech-ai/oh-my-unity3d/tree/main/.unity-skills/database-schema-design
Command: npx skills add https://github.com/JEO-tech-ai/oh-my-unity3d --skill database-schema-design-jeo-tech-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Design and optimize database schemas for SQL and NoSQL databases to ensure data integrity, scalability, and smooth migrations across evolving product requirements.

Core Features & Use Cases

  • Entity-relationship modeling with normalization up to 3NF to prevent data anomalies.
  • Design indexing strategies, constraints, and migration scripts to maintain performance and integrity.
  • Real-world usage: craft schemas for applications like e-commerce, analytics, or content-heavy platforms, with safe schema evolution.
  • Example: Plan a schema for a shopping app with Users, Products, Orders, and OrderItems.

Quick Start

Design a PostgreSQL schema for an e-commerce app with Users, Products, Orders, and OrderItems.

Frequently Asked Questions about database-schema-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 PostgreSQL application?▼

Design a database schema by defining entity-relationships, applying normalization up to 3NF to prevent anomalies, and creating indexing strategies and constraints for performance and data integrity.

What's the best way to refactor a MySQL schema without breaking existing data?▼

Refactor a MySQL schema by generating safe migration scripts that ensure smooth schema evolution and maintain data integrity across changing product requirements during the transition.

Can I use this for NoSQL schema design in MongoDB?▼

Yes, you can design robust and scalable schemas for NoSQL systems like MongoDB, ensuring data integrity and performance tuning alongside traditional SQL databases like PostgreSQL and MySQL.

When do I need database normalization up to 3NF?▼

You need database normalization up to 3NF during initial schema design or refactoring to prevent data anomalies, ensure data integrity, and structure entity-relationship modeling correctly.

Does this database schema design process include indexing strategy and constraints?▼

Yes, the database schema design process includes developing indexing strategies and defining constraints to maintain query performance and data integrity across SQL and NoSQL environments.

Related Skills

Explore More Software Engineering Skills→
musujmusuj

phase-1-schema

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

Community
Intermediate
yuhle-qugyuhle-qug

database-expert

Analyze and optimize database performance across PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
HeldinhowHeldinhow
4

database-migrations

Manage database schema changes through version-controlled migration scripts.

Community
Intermediate