database-design

Guide schema, indexing, and migration decisions for scalable database design.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/WilliansHerrera/inventario-w --skill database-design-williansherrera
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/WilliansHerrera/inventario-w/tree/main/.agent/skills/database-design
Command: npx skills add https://github.com/WilliansHerrera/inventario-w --skill database-design-williansherrera

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill provides a principled approach to database design, guiding decision-making on schema design, indexing strategies, ORM selection, and deployment considerations to build scalable systems.

Core Features & Use Cases

  • Guided decision framework for selecting DBMS, ORM tools, and schema design patterns based on project constraints.
  • Best practices for normalization, indexing, migrations, and performance optimization.
  • Use Case: When starting a new app, use the framework to choose a suitable database, ORM, and indexing strategy that balance consistency, scalability, and cost.

Quick Start

Outline a database design plan for your current project constraints using the framework.

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 a new scalable application?

Design a database schema by applying a principled decision framework that balances normalization standards, consistency, and scalability against your specific project constraints. This approach guides schema design patterns, indexing strategies, and ORM selection tailored to your deployment context.

What's the best way to plan safe database migrations without downtime?

Plan safe database migrations by following best practices for deployment considerations and schema changes. This framework guides migration strategies that maintain data integrity and optimize performance across varied data needs during new application deployment or performance optimization tasks.

How do I choose the right indexing strategy for my database?

Choose the right indexing strategy by evaluating your deployment context, schema design, and performance optimization requirements. This framework provides best practices for indexing strategies that balance consistency and scalability alongside your chosen DBMS and ORM tools.

Do I need an ORM for serverless database deployment?

You need ORM selection for serverless database deployment to manage data access patterns and schema design effectively. This framework guides ORM tool decisions based on project constraints, ensuring your database design balances consistency, scalability, and cost.

How does normalization affect database performance optimization?

Normalization affects database performance optimization by structuring schema design to reduce data redundancy and improve consistency. This framework applies normalization standards alongside indexing strategies and migration best practices to build scalable, reliable systems.