skills.rest
SJTU-IPADS
SJTU-IPADSOFFICIAL
Explore all skills by this author →
WebsiteGitHub

database-designer

Analyze JSON schemas for normalization, index optimization, and migration planning.

7|2|Updated Apr 13, 2026
Search Tags:#zero-downtime#database-design#er-diagram#migration-planning#schema-analysis#index-optimization
One-click install
npx skills add https://github.com/SJTU-IPADS/SkVM-data --skill database-designer-sjtu-ipads
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-designer
Source: https://github.com/SJTU-IPADS/SkVM-data/tree/main/skills/database-designer
Command: npx skills add https://github.com/SJTU-IPADS/SkVM-data --skill database-designer-sjtu-ipads

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Automates end-to-end database design, analysis, and migration planning so teams can build scalable, maintainable schemas with confidence.

Core Features & Use Cases

  • Schema Design & Analysis: automated normalization checks, ERD generation, naming validation.
  • Index Optimization: missing index detection, composite index design, redundancy checks, performance modeling.
  • Migration Management: zero-downtime migrations, schema evolution, data migration scripts, rollback planning, execution orchestration.

Quick Start

Run the database-designer on your schema JSON to generate an analysis report and a migration plan.

Frequently Asked Questions about database-designer

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

FAQPage Schema
How do I generate an ER diagram from a JSON schema definition?▼

To generate an ER diagram from a JSON schema definition, submit the schema to the automated database design analysis. The system parses the structure and outputs a visual ERD alongside normalization checks and naming validation.

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

The best way to plan a zero-downtime database migration is to automate schema evolution and rollback planning from your JSON schema. This generates safe migration workflows, data scripts, and rollback steps across common SQL engines.

How do I check for missing indexes and optimize composite indexing in my database?▼

To check for missing indexes and optimize composite indexing, run an index optimization analysis on your schema. The system detects missing keys, designs composite indexes, checks redundancy, and models performance coverage.

Can I use automated schema analysis for enterprise-grade relational databases across different SQL engines?▼

Yes, you can use automated schema analysis for enterprise-grade relational databases across common SQL engines. It validates constraints, checks normalization, and guides migration workflows regardless of schema size.

What constraints validation does database design analysis cover when checking a schema?▼

Database design analysis covers constraints validation by checking for missing keys, evaluating index coverage, and designing composite indexing. It ensures schema integrity through automated normalization and redundancy checks.

Related Skills

Explore More Data & Analytics Skills→
qa-amanqa-aman
19

schema-spec

Document data schemas with headers, fields, types, and evolution rules.

Community
Advanced
Prompt-or-Die-LabsPrompt-or-Die-Labs
7

database-migration-helper

Generate reversible database migrations with schema changes and data transformations.

Official
Intermediate
ref-docsref-docs

database-schema-designer

Design database schemas with ER diagrams, normalization, and DDL generation.

Official
Advanced
xlelibertyxleliberty

database-designer

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

Community
Advanced