How does it handle performance optimization?

The skill analyzes your access patterns to suggest appropriate indexing strategies, chooses optimal data types, and identifies when denormalization is necessary for read-heavy workloads.

Which database types does the Database Schema Designer support?

The skill supports both SQL (PostgreSQL, MySQL, SQLite) and NoSQL database designs. It defaults to SQL best practices but can be explicitly triggered for NoSQL modeling.

Can this skill help refactor an existing database?

Yes, you can use the 'normalize' and 'review schema' commands to audit existing tables, identify anti-patterns, and receive specific recommendations for improvement.

Does it generate actual migration code?

Absolutely. It generates reversible migration scripts including both 'up' and 'down' actions, ensuring that schema changes are manageable and backward compatible.

Database Schema Designer

Name: Database Schema Designer
Author: softaworks

bysoftaworks

•

347

数据库管理

Designs production-ready SQL and NoSQL database schemas using industry-standard normalization, indexing, and performance optimization patterns.

关于

The Database Schema Designer skill equips AI coding agents with the expertise to architect robust, scalable, and maintainable data models. It guides the development process through four critical phases: analysis of access patterns, structured design following normalization rules (1NF-3NF), performance optimization via strategic indexing, and the generation of reversible migration scripts. By enforcing best practices like foreign key constraints, proper data typing, and anti-pattern avoidance, this skill ensures data integrity and high query performance for both relational and non-relational database systems.

主要功能

Reversible migration script generation (UP/DOWN) for schema evolution
Automated SQL and NoSQL schema generation based on entity descriptions
Advanced indexing strategies to optimize query performance and JOINs
347 GitHub stars
Expert normalization guidance including 1NF, 2NF, and 3NF enforcement
Comprehensive schema auditing to detect anti-patterns and performance bottlenecks

使用场景

Architecting the data foundation for new e-commerce, SaaS, or analytics platforms
Refactoring legacy database tables to eliminate redundancy and improve data integrity
Planning and generating zero-downtime migration scripts for production database updates

关于

主要功能

Reversible migration script generation (UP/DOWN) for schema evolution
Automated SQL and NoSQL schema generation based on entity descriptions
Advanced indexing strategies to optimize query performance and JOINs
347 GitHub stars
Expert normalization guidance including 1NF, 2NF, and 3NF enforcement
Comprehensive schema auditing to detect anti-patterns and performance bottlenecks

使用场景

Architecting the data foundation for new e-commerce, SaaS, or analytics platforms
Refactoring legacy database tables to eliminate redundancy and improve data integrity
Planning and generating zero-downtime migration scripts for production database updates