skills.rest
Movchanets
MovchanetsCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Design database schemas for microservices applications with migration planning.

Updated May 5, 2026
Search Tags:#query optimization#indexing#schema design#database#migrations#microservices#orm
One-click install
npx skills add https://github.com/Movchanets/Microservices_Learning --skill database-design-movchanets
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/Movchanets/Microservices_Learning/tree/main/.agents/skills/database-design
Command: npx skills add https://github.com/Movchanets/Microservices_Learning --skill database-design-movchanets

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill helps you make sound database decisions instead of defaulting to one-size-fits-all patterns, reducing schema mistakes, performance issues, and painful migration surprises.

Core Features & Use Cases

  • Database Selection: Compare relational, serverless, embedded, and edge-friendly options based on deployment and workload.
  • Schema Design: Plan primary keys, relationships, timestamps, and normalization choices for maintainable data models.
  • Performance Guidance: Identify useful indexes, avoid N+1 issues, and improve query efficiency with practical optimization steps.
  • Safe Change Management: Apply zero-downtime migration patterns for adding, removing, and renaming schema elements.
  • Use Case: A team building a microservices platform can use this Skill to choose the right database approach, design service-owned schemas, and plan production-safe migrations.

Quick Start

Use the database-design skill to review your database requirements, recommend a suitable schema and indexing approach, and outline a safe migration plan for your project.

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 microservices?▼

Database selection for microservices compares relational, serverless, embedded, and edge-friendly options based on your specific deployment environment and workload requirements to ensure optimal architecture.

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

Query optimization for databases involves identifying useful indexes, avoiding N+1 issues, and applying practical performance tuning steps to improve query efficiency within your application.

How do I choose the right database for my workload?▼

Database selection for microservices compares relational, serverless, embedded, and edge-friendly options based on your specific deployment environment and workload requirements to ensure optimal architecture.

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

Zero-downtime database migrations apply safe change management patterns for adding, removing, and renaming schema elements without interrupting production traffic or causing painful migration surprises.

How do I fix N+1 query issues and improve database performance?▼

Query optimization for databases involves identifying useful indexes, avoiding N+1 issues, and applying practical performance tuning steps to improve query efficiency within your application.

Does schema design require awareness of distributed-system keys?▼

Schema design requires awareness of relational modeling, distributed-system keys, and normalization choices to plan primary keys and relationships for maintainable microservices data models.

Related Skills

Explore More Software Engineering Skills→
tchawla827tchawla827
1

database-designer

Design, optimize, and migrate database schemas with ERD generation and zero-downtime planning.

Community
Advanced
JCETools-PetraJCETools-Petra
16

sql-database

Analyze slow SQL queries and generate indexing and migration plans.

Community
Advanced
xenitV1xenitV1
132

database-design

Design relational schemas with normalization, indexing, and ORM choices.

Community
Basic
4lerman4lerman

sql-database-assistant

Generate SQL queries, introspect schemas, optimize performance, and create migration scripts.

Community
Advanced