skills.rest
tomasbasso
tomasbassoCOMMUNITY
Explore all skills by this author →
GitHub

arquitectura-esquemas-base-de-datos

Designs relational and non-relational database schemas with normalization, indexing, migration planning, and Mermaid ERD output.

Updated Apr 25, 2026
Search Tags:#design#indexing#database#migrations#schema#normalization#erd
One-click install
npx skills add https://github.com/tomasbasso/SistemaStockV2 --skill arquitectura-esquemas-base-de-datos
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: arquitectura-esquemas-base-de-datos
Source: https://github.com/tomasbasso/SistemaStockV2/tree/main/.agents/skills/arquitectura-esquemas-base-de-datos
Command: npx skills add https://github.com/tomasbasso/SistemaStockV2 --skill arquitectura-esquemas-base-de-datos

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Esta skill proporciona un marco estructurado para diseñar bases de datos robustas y escalables. Complementa las skills específicas de motores (como PostgreSQL) con principios universales de diseño.

Core Features & Use Cases

  • Entidades y Atributos: Identificar objetos del dominio y sus propiedades.
  • Relaciones y Normalización: Definir 1:1, 1:N, N:M y aplicar formas normales (1NF, 2NF, 3NF) para evitar redundancias.
  • Estrategia de Indexación, Restricciones y Triggers: Asegurar la integridad de datos a nivel de motor y facilitar la evolución del esquema.
  • Migraciones: Diseñar scripts de cambio que permitan evolucionar el esquema sin pérdida de datos.
  • Formato de Entrega: Sugerir siempre el esquema acompañado de un diagrama Mermaid ERD para validación visual.

Quick Start

Diseña un esquema de base de datos siguiendo el marco y genera un diagrama Mermaid ERD para validación.

Frequently Asked Questions about arquitectura-esquemas-base-de-datos

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a database schema and generate an ERD for validation?▼

Database schema design defines domain entities, attributes, and relationships, applying normalization to prevent redundancy. This process outputs a structured schema accompanied by a Mermaid ERD diagram for visual validation.

What is the best way to plan database migrations without losing data?▼

Database migration planning involves designing change scripts that evolve the schema safely. By defining incremental migration scripts, you ensure schema evolution occurs without data loss during database updates.

How do I apply normalization forms like 3NF when defining database relationships?▼

Applying normalization forms like 3NF involves structuring 1:1, 1:N, and N:M database relationships to eliminate data redundancy. This ensures relational database integrity by separating concerns into distinct, related tables.

Does this database schema design approach work for both PostgreSQL and NoSQL stores?▼

Yes, this database schema design approach applies to both relational engines like PostgreSQL and NoSQL stores. It provides universal architectural design principles adaptable across different database paradigms.

How do I ensure data integrity using indexing, constraints, and triggers?▼

Ensuring data integrity involves defining an indexing strategy, constraints, and triggers at the database engine level. This combination enforces data rules directly within the schema architecture.

Related Skills

Explore More Software Engineering Skills→
SSiertsemaSSiertsema

conceptual-data-modeling

Define domain entities, relationships, and business rules in plain language.

Community
Intermediate
jtucker9jtucker9

memstack-development-database-architect

Design PostgreSQL/Supabase schemas with RLS policies and migration SQL.

Community
Advanced
Eigo-Mt-FujiEigo-Mt-Fuji

query-designer

Translate natural-language SQL requests into dialect-aware queries for PostgreSQL, MySQL, SQLite, SQL Server, and Oracle.

Community
Intermediate
zizzfizzixzizzfizzix

migrate-orm

Automate database schema migrations for ORM-based applications.

Community
Intermediate