skills.rest
ramybarsoum
ramybarsoumCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-design

Generate ER diagrams, SQL table definitions, indexes, migrations, and EF Core configurations from feature descriptions.

Updated Apr 10, 2026
Search Tags:#migrations#indexes#erd#schema-design#database-design#ef-core
One-click install
npx skills add https://github.com/ramybarsoum/RStack-V0 --skill database-design-ramybarsoum
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/ramybarsoum/RStack-V0/tree/main/skill/database-design
Command: npx skills add https://github.com/ramybarsoum/RStack-V0 --skill database-design-ramybarsoum

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Designing consistent, maintainable, and convention-compliant database schemas from feature requests or tech designs is time-consuming and error-prone; this Skill produces ERDs, table definitions, indexes, migration plans, and EF Core configurations to accelerate implementation and reduce design drift.

Core Features & Use Cases

  • ERD and schema generation: Create entity-relationship diagrams and normalized table layouts mapping domain models to relational tables.
  • Migrations and index strategy: Produce SQL table definitions, index recommendations, and step-by-step migration plans to evolve schemas safely.
  • EF Core configurations: Output entity classes and Fluent API or attribute-based EF Core configurations following AllCare conventions to plug directly into the application codebase.
  • Use Case: Convert a patient preferences feature spec into an ERD, SQL schema, migration plan, and EF Core entity mappings ready for code review and CI integration.

Quick Start

Invoke the database-design skill with a concise feature description or link to a tech design to generate an ERD, table definitions, index strategy, migration steps, and EF Core configurations saved to work/database-designs/[feature]-database-design.md.

Frequently Asked Questions about database-design

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

FAQPage Schema
How do I generate an ERD and database schema from a feature description?▼

To generate a database schema and ERD, provide a concise feature description or technical design. The system produces normalized table layouts and entity-relationship diagrams mapping domain models directly to relational tables.

How do I create EF Core entity configurations from an existing schema design?▼

Creating EF Core configurations requires a schema design input. The system outputs entity classes and Fluent API configurations following AllCare conventions, ready to plug directly into your application codebase.

What's the best way to plan database migrations for new application features?▼

Planning database migrations involves producing step-by-step migration plans to evolve schemas safely. The system generates SQL table definitions and index recommendations to ensure safe CI integration.

Can I use this to generate index strategies for relational database tables?▼

Yes, generating index strategies is supported. The system analyzes your schema design to produce tailored index recommendations that optimize query performance alongside the SQL table definitions.

Does this database schema design approach work with healthcare platform conventions?▼

Yes, this database schema design works with healthcare platforms following AllCare conventions. It produces ERDs, schemas, and EF Core mappings specifically aligned with those structural requirements.

Why do I need to normalize table schemas when designing a new database feature?▼

Normalizing table schemas reduces design drift and ensures maintainability. The system maps domain models to normalized relational tables, preventing data anomalies and accelerating implementation.

Related Skills

Explore More Software Engineering Skills→
myrtlepnmyrtlepn
24

schema-designer

Design database schemas, ERDs, and migration plans for software features.

Community
Advanced
s205109s205109
2

cck-migration-workflow

Apply EF Core migrations with SQL review, rollback plans, and test verification.

Community
Advanced
dart-langdart-lang
428

dart-generate-test-mocks

Generate mocks for Dart unit tests using mockito and build_runner.

Official
Intermediate
jeremylongshorejeremylongshore
2.6k

designing-database-schemas

Design normalized relational database schemas and generate Mermaid ERDs with SQL CREATE statements.

Community
Intermediate