skills.rest
devCharuzu
devCharuzuCOMMUNITY
Explore all skills by this author →
GitHub

database-designer

Design database schemas with normalization checks and ERD generation.

Updated Apr 16, 2026
Search Tags:#design#indexing#database#migration#sql#normalization#nosql
One-click install
npx skills add https://github.com/devCharuzu/philfida-taskmanage --skill database-designer-devcharuzu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-designer
Source: https://github.com/devCharuzu/philfida-taskmanage/tree/main/.windsurf/skills/database-designer
Command: npx skills add https://github.com/devCharuzu/philfida-taskmanage --skill database-designer-devcharuzu

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

The database-designer skill helps architects and developers design robust, scalable database schemas, evaluate normalization, plan migrations, and optimize performance across SQL and NoSQL ecosystems.

Core Features & Use Cases

  • Schema Design & Analysis: normalization checks, ERD generation, constraint validation
  • Migration Planning: zero-downtime strategies, rollout planning, rollback options
  • Index & Query Optimization: index selection, performance modeling, query patterns
  • Platform Selection: guidance between SQL databases, NoSQL stores, and data modeling patterns

Quick Start

Run a full schema assessment for a new project and generate a normalized schema with an indexing plan, migration steps, and ERD.

Frequently Asked Questions about database-designer

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

FAQPage Schema
How do I design a scalable database schema for both SQL and NoSQL workloads?▼

Database schema design for SQL and NoSQL requires evaluating normalization, indexing, and data modeling patterns. This skill generates optimized schemas, applies automated normalization checks, and produces ERDs to ensure scalable relational and non-relational data structures.

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

Zero-downtime database migrations require rollout planning and rollback options to prevent service disruption. This skill designs migration strategies that evaluate schema changes, generate step-by-step rollout plans, and provide safe rollback paths for continuous availability.

How does database indexing affect query performance and how do I optimize it?▼

Database indexing directly impacts query performance by reducing data scan overhead. This skill provides index selection guidance, performance modeling, and query pattern analysis to optimize both relational and non-relational workload execution.

When do I need database normalization and how do I check if my schema meets normalization standards?▼

Database normalization is needed to reduce data redundancy and improve integrity in relational schemas. This skill runs automated normalization checks against your schema design, validating constraint compliance and generating normalized table structures.

Can I generate an ERD for my existing database schema automatically?▼

Yes, ERD generation is supported directly from your schema design. This skill analyzes table definitions, relationships, and constraints to produce entity-relationship diagrams that visualize your relational database structure for review and optimization.

How do I choose between SQL and NoSQL for my data modeling requirements?▼

Choosing between SQL and NoSQL depends on your data structure, query patterns, and scalability needs. This skill provides platform selection guidance, comparing relational constraints against non-relational flexibility to recommend the optimal data modeling approach.

Related Skills

Explore More Software Engineering Skills→
musujmusuj

phase-1-schema

Define project terminology, entities, relationships, and data structures.

Community
Intermediate
jay6697117jay6697117

agency-database-optimizer

Optimize PostgreSQL and MySQL database schemas, indexes, and query plans.

Community
Advanced
jonnabiojonnabio
6

database-operations

Automate database migrations, schema changes, and query optimization.

Community
Advanced
elsolalelsolal
1

database-designer

Design relational database schemas with ERD, migrations, and performance-oriented indexes.

Community
Advanced