skills.rest
Veloxia-agency
Veloxia-agencyCOMMUNITY
Explore all skills by this author →
GitHub

database-designer

Design and optimize database schemas, indexes, and migrations.

Updated Apr 24, 2026
Search Tags:#indexing#database#migrations#normalization#erd#schema-design
One-click install
npx skills add https://github.com/Veloxia-agency/VELOXIA-WEB --skill database-designer-veloxia-agency
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-designer
Source: https://github.com/Veloxia-agency/VELOXIA-WEB/tree/main/.claude/skills/engineering/skills/database-designer
Command: npx skills add https://github.com/Veloxia-agency/VELOXIA-WEB --skill database-designer-veloxia-agency

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and assets (resource) components.

What problem does it solve?

This Skill helps teams design better database schemas, catch normalization and constraint issues early, and avoid performance problems before they reach production.

Core Features & Use Cases

  • Schema Analysis: Reviews tables, columns, keys, constraints, and naming for normalization and data type issues.
  • Index Optimization: Recommends missing, overlapping, and covering indexes from real query patterns.
  • Migration Planning: Generates safe schema evolution steps, rollback paths, and zero-downtime migration strategies.
  • Use Case: A developer can feed in an existing schema and workload data to get ERD guidance, performance recommendations, and a production-ready migration plan.

Quick Start

Ask the database designer skill to review your schema or migration plan and return prioritized optimization, indexing, and rollback recommendations.

Frequently Asked Questions about database-designer

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

FAQPage Schema
How do I optimize database indexes based on query workload patterns?▼

Database index optimization analyzes your query patterns to recommend missing, overlapping, and covering indexes. Provide your schema definitions and workload data to receive targeted index recommendations that prevent performance issues.

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

Database migration planning generates safe schema evolution steps, rollback paths, and zero-downtime migration strategies. Submit your current-versus-target models to get production-ready migration plans with validation checks.

How do I review my database schema for normalization issues?▼

Schema normalization review analyzes tables, columns, keys, and constraints to catch data type and structural issues early. Feed in your schema definitions to receive ERD guidance and normalization recommendations.

Can I use this for both SQL and NoSQL database schema design?▼

Yes, database schema design applies to both SQL and NoSQL selection, relational modeling, and normalization review. Provide your schema definitions and query patterns to get tailored structural recommendations.

How do I generate an ERD from an existing database schema?▼

Generating an ERD requires your existing schema definitions and query patterns. The database designer analyzes your current models to produce Entity Relationship Diagrams alongside performance and structural recommendations.

When should I not use automated database schema optimization?▼

Automated database schema optimization requires accurate query patterns and current-versus-target models to be effective. Without real workload data or existing schema definitions, the generated index and migration recommendations may not be reliable.

Related Skills

Explore More Software Engineering Skills→
tedtv1007-ctrltedtv1007-ctrl

postgresql-optimization

Analyze PostgreSQL execution plans and schema definitions to recommend query and index optimizations.

Community
Advanced
HyperscapeAIHyperscapeAI
91

database-migration-helper

Generate reversible database migrations with up and down logic for Prisma, TypeORM, Alembic, and Sequelize.

Official
Intermediate
cyperx84cyperx84
2

Query Optimization

Analyze EXPLAIN plans and recommend indexing strategies for SQL queries.

Community
Advanced
xlelibertyxleliberty

database-designer

Analyze SQL schemas for normalization violations and generate index optimization reports.

Community
Advanced