skills.rest
dreamingechoes
dreamingechoesCOMMUNITY
Explore all skills by this author →
Website𝕏@dreamingechoesGitHub

database-schema

Design normalized database schemas with tables, constraints, and migration plans.

2|1|Updated Apr 13, 2026
Search Tags:#database#migration#sql#constraints#indexes#normalization#schema-design
One-click install
npx skills add https://github.com/dreamingechoes/dx-toolkit --skill database-schema-dreamingechoes
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema
Source: https://github.com/dreamingechoes/dx-toolkit/tree/main/templates/skills/database-schema
Command: npx skills add https://github.com/dreamingechoes/dx-toolkit --skill database-schema-dreamingechoes

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Design a principled database schema from requirements to ensure consistent tables, robust constraints, and clean migration plans.

Core Features & Use Cases

  • Generate normalized tables with primary keys, foreign keys, and constraints.
  • Propose indexes and migration strategies for evolving schemas.
  • Use case: start a new feature by outlining tables, relationships, and indexes for a smooth rollout.

Quick Start

Provide project requirements and run this skill to generate a schema outline ready for review.

Frequently Asked Questions about database-schema

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

FAQPage Schema
How do I design a normalized database schema from project requirements?▼

To design a normalized database schema from requirements, you outline the necessary tables, primary and foreign keys, and explicit constraints. This process ensures your data model achieves 3NF normalization for consistent data integrity.

What is the best way to generate SQL indexes and constraints for a new data model?▼

Generating SQL indexes and constraints for a new data model involves defining explicit primary and foreign keys alongside proposed indexes. This ensures robust database designs with structured relationships and optimized query performance.

How do I create a database migration plan when updating an existing schema?▼

Creating a database migration plan for an existing schema involves proposing structured strategies to evolve your data model. This defines the necessary table definition updates and constraint modifications for a smooth rollout.

Can I use 3NF normalization for reviewing and updating existing database designs?▼

Yes, you can use 3NF normalization for reviewing and updating existing database designs. Applying this principle ensures your tables, relationships, and explicit constraints remain robust and consistent across evolving projects.

When do I need explicit constraints and indexes for my database tables?▼

You need explicit constraints and indexes for database tables when designing a normalized schema from scratch or rolling out a new feature. They enforce data integrity and optimize queries within your relational data model.

Related Skills

Explore More Software Engineering Skills→
H2OSLabsH2OSLabs
1

schema-to-openapi

Converts Synnovator data schemas into OpenAPI 3.0 YAML or JSON specifications.

Official
Intermediate
OneWave-AIOneWave-AI
245

database-schema-designer

Design optimized SQL and NoSQL database schemas with ERDs and migration scripts.

Official
Basic
abranjithabranjith

build-data-model

Design normalized relational data models from plain-language domain requirements.

Community
Advanced
derek2035derek2035

data-model-creation

Generate Mermaid class diagrams from user requirements for data schema modeling.

Community
Advanced