skills.rest
Dhumitech
DhumitechCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Design relational database schemas and select ORMs with migration planning.

1|Updated Sep 11, 2025
Search Tags:#indexing#migrations#performance-tuning#schema-design#database-design#orm-selection#sql-vs-nosql
One-click install
npx skills add https://github.com/Dhumitech/DHUMI-AI-RESOURCE --skill database-design-dhumitech
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/Dhumitech/DHUMI-AI-RESOURCE/tree/main/AI-Engineer-planner-Skills/02-data/database-design
Command: npx skills add https://github.com/Dhumitech/DHUMI-AI-RESOURCE --skill database-design-dhumitech

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

The Skill helps teams design scalable, maintainable database schemas and choose appropriate ORMs and SQL/NoSQL strategies, reducing over-engineering and misaligned data models.

Core Features & Use Cases

  • Provides clear guidance on database and ORM selection based on context and deployment constraints.
  • Outlines key design considerations: normalization, PKs, relationships, indexing, and migrations.
  • Use Case: When starting a new relational project, use this Skill to decide between PostgreSQL, MySQL, or alternatives and select an ORM, then plan a safe migrations path.

Quick Start

Identify project data requirements and select a database and ORM aligned with the context, then outline a migration plan.

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 scalable database schema for a new project?▼

Schema design for SQL vs NoSQL depends on your deployment constraints. SQL suits structured relational data with normalization, while NoSQL fits flexible, high-volume data models.

What is the best way to choose an ORM for my relational database?▼

Database indexing strategies improve query performance by enabling efficient data retrieval. Proper indexing targets specific query patterns and reduces full table scans during database operations.

Can I use this approach for both SQL and NoSQL database migrations?▼

To plan safe database migrations, you outline a migration path that aligns with your schema design. This prevents data loss and maintains application stability during deployment.

When do I need database normalization in schema design?▼

Yes, this approach handles both SQL and NoSQL migrations. It specifies safe migration practices and deployment considerations to ensure scalable architectures across different database ecosystems.

Related Skills

Explore More Software Engineering Skills→
HechaoYannetHechaoYannet

create-architecture

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

Community
Advanced
CwuztoCwuzto

database-schema-design

Design and optimize SQL and NoSQL database schemas for PostgreSQL, MySQL, and MongoDB.

Community
Advanced
isharoverwhiteisharoverwhite
13

sqlalchemy-orm

Implement SQLAlchemy 2.0 ORM models for Python database operations.

Community
Intermediate
NabilThangeNabilThange
1

database-design

Guide database design decisions for schema, indexing, ORM, and migrations.

Community
Advanced