How does the skill handle safety during implementation?

It follows a strict 5-step workflow: assessing current state, designing with risk mitigation, testing in non-production, validating results, and then deploying with monitoring.

Can I use this for NoSQL document modeling?

Yes, the skill is capable of designing NoSQL schemas and managing collections using tools like mongosh for MongoDB environments.

Does it follow normalization and performance best practices?

Absolutely. The skill incorporates standard design patterns, normalization rules, and indexing strategies to ensure optimal database performance.

Which database engines are supported by this skill?

The skill supports a wide range of systems including PostgreSQL, MySQL, and MongoDB through integrated support for psql, mysql, and mongosh tools.

Can it help with migrating existing production databases?

Yes, it is specifically designed to create migrations, assess risks, and document rollback plans to ensure structural changes are handled safely.

Database Schema Designer

Name: Database Schema Designer
Author: BbgnsurfTech

byBbgnsurfTech

•

Database Management

Architects robust database schemas and automates migrations using industry best practices for SQL and NoSQL systems.

The Database Schema Designer skill empowers Claude to act as a senior database architect, guiding you through the end-to-end lifecycle of data modeling and structural management. It automates the generation of optimized schemas, creates safe migration scripts for engines like PostgreSQL and MySQL, and establishes comprehensive validation protocols to ensure data integrity. Whether you are building a greenfield application or refactoring legacy data structures, this skill provides the automation and safety-first workflows needed to design, test, and deploy database changes with confidence.

Key Features

01Native integration with psql, mysql, and mongosh CLI tools

02Structured assessment and validation for non-production testing

03Automated SQL and NoSQL schema generation and modeling

04Comprehensive migration management with rollback procedures

05Automatic generation of runbooks and monitoring configurations

063 GitHub stars

Use Cases

01Generating comprehensive database documentation and performance monitoring dashboards

02Refactoring existing table structures while maintaining data integrity through migrations

03Designing a scalable relational database architecture for a new web application

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection database-schema-designer

For use in Claude.ai and ChatGPT

Download Skill