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.

주요 기능

01Reversible migration script generation (UP/DOWN) for schema evolution

02Automated SQL and NoSQL schema generation based on entity descriptions

03Advanced indexing strategies to optimize query performance and JOINs

04347 GitHub stars

05Expert normalization guidance including 1NF, 2NF, and 3NF enforcement

06Comprehensive schema auditing to detect anti-patterns and performance bottlenecks

사용 사례

01Architecting the data foundation for new e-commerce, SaaS, or analytics platforms

02Refactoring legacy database tables to eliminate redundancy and improve data integrity

03Planning and generating zero-downtime migration scripts for production database updates

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add softaworks/agent-toolkit database-schema-designer

For use in Claude.ai and ChatGPT

Download Skill