Can I use this to fix 'IncorrectVersionError' in Galaxy?

Yes, the skill includes a dedicated troubleshoot mode specifically designed to resolve version mismatches and migration failures.

What tools does this skill help manage?

This skill provides expert guidance for using Alembic and Galaxy's internal migration scripts like manage_db.sh and db_dev.sh.

Is it safe for production databases?

While the skill provides the commands, it emphasizes safety measures such as taking backups and shutting down Galaxy processes before running migrations.

Does it support the Tool Shed database?

Yes, it provides instructions for both the 'gxy' (main Galaxy) and 'tsi' (Tool Shed install) migration branches.

How does it assist with creating new migrations?

It walks you through updating SQLAlchemy models, creating the revision file, and implementing the required upgrade and downgrade functions using Galaxy's migration utilities.

Galaxy DB Migration Manager

Name: Galaxy DB Migration Manager
Author: arash77

byarash77

0•

データベース管理

Manages Galaxy Project database schema changes using Alembic for seamless model updates and version control.

This skill provides specialized guidance for Galaxy Project developers to manage complex database migrations using Alembic. It streamlines the workflow for creating new migration revisions, upgrading or downgrading schema versions, and verifying the current database status against the codebase. By offering step-by-step instructions for SQLAlchemy model modifications and providing advanced troubleshooting strategies for common issues like deadlocks or version mismatches, it ensures consistent and error-free database evolution within the Galaxy ecosystem.

主な機能

01Expert troubleshooting for migration errors, deadlocks, and version conflicts

02Real-time status checking of database versions versus codebase

03Step-by-step workflows for database upgrades and downgrades

04Support for both Galaxy (gxy) and Tool Shed (tsi) database branches

05Automated guidance for creating new Alembic migration revisions

060 GitHub stars

ユースケース

01Synchronizing a local development database with the latest upstream schema changes

02Resolving complex database migration failures during production deployments

03Updating SQLAlchemy models and generating corresponding migration scripts for Galaxy

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add arash77/galaxy-claude-marketplace galaxy-db-migration

For use in Claude.ai and ChatGPT

Download Skill