Can it detect changes in indexes and triggers?

Yes, the tool identifies differences across tables, columns, indexes, constraints, and database triggers.

How do I trigger the schema comparison?

You can trigger the skill by asking Claude to 'compare schemas', 'generate a migration script', or by using the /db-diff command.

Does it generate safe scripts for production?

Yes, it generates transaction-safe scripts to prevent data corruption and automatically provides rollback procedures for error recovery.

Which database engines are supported by this skill?

The Database Diff & Migration skill currently supports PostgreSQL and MySQL databases.

Database Diff & Migration Adapter

Name: Database Diff & Migration Adapter
Author: BbgnsurfTech

byBbgnsurfTech

•

Gestión de Bases de Datos

Compares database schemas and generates transaction-safe migration scripts and rollback procedures for PostgreSQL and MySQL.

This skill empowers Claude to perform production-grade database schema comparisons and management tasks. By leveraging specialized diffing tools, it identifies discrepancies in tables, columns, indexes, and constraints between environments like development and production. It goes beyond simple comparison by automatically generating safe, transaction-wrapped migration scripts and corresponding rollback procedures, ensuring data integrity and minimizing downtime during complex database deployments.

Características Principales

01Instant rollback procedure creation for safe deployments

02Automated transaction-safe migration script generation

031 GitHub stars

04Support for synchronization workflows across staging and production

05Cross-environment schema comparison for PostgreSQL and MySQL

06Detection of differences in tables, columns, indexes, and triggers

Casos de Uso

01Synchronizing staging database schemas with production environments

02Auditing database structural differences between local and remote instances

03Generating SQL migration scripts for CI/CD deployment pipelines

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection skill-adapter

For use in Claude.ai and ChatGPT

Download Skill