skills.rest
MGriot
MGriotCOMMUNITY
Explore all skills by this author →
GitHub

database-schema-designer

Design SQL and NoSQL database schemas with keys, indexes, and migrations.

Updated Jan 31, 2026
Search Tags:#design#SQL#database#NoSQL#migrations#schema#normalization
One-click install
npx skills add https://github.com/MGriot/.gemini --skill database-schema-designer-mgriot
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-designer
Source: https://github.com/MGriot/.gemini/tree/main/skills/database-schema-designer
Command: npx skills add https://github.com/MGriot/.gemini --skill database-schema-designer-mgriot

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides a structured approach to designing robust, scalable database schemas for SQL and NoSQL systems, reducing structural errors and deployment risk.

Core Features & Use Cases

  • Normalize schemas to 3NF for SQL databases and define embedding/reference strategies for NoSQL.
  • Provide migration templates and constraints guidance to ensure data integrity and maintainability.
  • Use cases include designing a new e-commerce catalog, auditing existing schemas for performance, and planning zero-downtime migrations.

Quick Start

Describe your data model and requirements, for example: design a schema for an e-commerce platform with users, products, and orders. The skill will output a complete SQL/NoSQL schema with keys, indexes, and reversible migrations.

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 with proper normalization and constraints?▼

Database schema design applies normalization to 3NF for SQL systems and defines embedding strategies for NoSQL. It enforces keys, constraints, and data-type accuracy to ensure structural integrity and maintainability across transactional and analytical workloads.

What is the best way to plan zero-downtime database migrations for an evolving schema?▼

Database migrations are handled using reversible migration templates. These templates ensure data integrity and maintainability when evolving existing schemas, allowing you to apply structural changes without deployment risk.

Does this schema design approach work for both SQL and NoSQL data models?▼

Yes, schema design supports both SQL and NoSQL systems. It normalizes SQL schemas to 3NF while defining specific embedding and reference strategies for NoSQL databases to optimize performance and data integrity.

How do I audit an existing database schema for performance and indexing strategies?▼

Auditing a database schema involves evaluating data models to ensure performance and maintainability. The process checks data-type accuracy, indexing strategies, and normalization levels to identify structural errors and improve query efficiency.

When do I need to define embedding versus reference strategies for NoSQL schemas?▼

NoSQL schema design requires defining embedding or reference strategies when structuring data for specific workloads. This approach ensures data integrity and performance by determining how related data is stored and accessed within the database.

Can I generate a complete e-commerce database schema with keys and indexes?▼

Generating a complete database schema for e-commerce involves outputting structures with keys, indexes, and constraints. You provide the data model requirements, and the system produces a full schema design tailored to your platform.

Related Skills

Explore More Software Engineering Skills→
photoszztphotoszzt

tla-refinement-proofs

Verify TLA+ specification refinement using TLC model checking.

Community
Intermediate
layeddielayeddie
1

migration-patterns

Plan and execute zero-downtime Elixir/Phoenix database migrations with reversible rollbacks.

Community
Advanced
ZateZate
9

database-patterns

Provide database-pattern guidance for schema design, indexing, query optimization, and migration practices.

Community
Intermediate
nahisahonahisaho
3

scientific-metabolic-atlas

Query Metabolic Atlas REST API for metabolic reactions, metabolites, and compartments.

Community
Advanced