Can I use this to improve my existing database structure?

Absolutely. You can provide your current table definitions and use commands like 'review schema' or 'normalize' to receive optimization and refactoring suggestions.

Does it handle database migrations?

Yes, the skill generates reversible migration scripts (up and down) to ensure your schema changes are manageable and backward-compatible.

Does this skill support both SQL and NoSQL databases?

Yes, while it defaults to SQL for relational modeling, it can design optimized NoSQL schemas focusing on document embedding and referencing strategies when requested.

What database anti-patterns does it help avoid?

It prevents common mistakes such as using inappropriate data types (like FLOAT for currency), missing foreign key constraints, and over-indexing which can slow down write operations.

How does it optimize for query performance?

It analyzes your application's access patterns to recommend B-Tree, Hash, or Composite indexes, ensuring that frequently queried columns and foreign keys are properly indexed.

Database Schema Designer

Name: Database Schema Designer
Author: Microck

byMicrock

•

Database Management

Designs robust, scalable SQL and NoSQL database schemas with built-in best practices for normalization, indexing, and migrations.

The Database Schema Designer skill transforms high-level data requirements into production-ready database architectures. It provides expert-level guidance on entity-relationship modeling, ensuring data integrity through strict normalization (1NF to 3NF) and optimized indexing strategies. Whether you are building a greenfield e-commerce platform or refactoring a legacy system, this skill automates the creation of DDL scripts, reversible migrations, and performance-tuned schemas that align with your specific application access patterns.

Key Features

01Audits existing schemas to identify anti-patterns and performance bottlenecks

02Automates indexing strategies based on query and access patterns

032 GitHub stars

04Generates normalized SQL schemas and optimized NoSQL data models

05Supports complex constraints including foreign keys, unique indexes, and check validations

06Creates reversible migration scripts with both 'up' and 'down' logic

Use Cases

01Refactoring flat or redundant data structures into normalized relational models

02Planning zero-downtime schema evolutions and database migrations

03Architecting the data layer for multi-tenant SaaS or high-traffic e-commerce platforms

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add microck/opendots-microck database-schema-designer

For use in Claude.ai and ChatGPT

Download Skill