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.

About

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

Native integration with psql, mysql, and mongosh CLI tools
Structured assessment and validation for non-production testing
Automated SQL and NoSQL schema generation and modeling
Comprehensive migration management with rollback procedures
Automatic generation of runbooks and monitoring configurations
3 GitHub stars

Use Cases

Generating comprehensive database documentation and performance monitoring dashboards
Refactoring existing table structures while maintaining data integrity through migrations
Designing a scalable relational database architecture for a new web application

About

Key Features

Native integration with psql, mysql, and mongosh CLI tools
Structured assessment and validation for non-production testing
Automated SQL and NoSQL schema generation and modeling
Comprehensive migration management with rollback procedures
Automatic generation of runbooks and monitoring configurations
3 GitHub stars

Use Cases

Generating comprehensive database documentation and performance monitoring dashboards
Refactoring existing table structures while maintaining data integrity through migrations
Designing a scalable relational database architecture for a new web application