Database Migration

What it does

This skill automates the process of migrating data between different database systems. It handles schema transformations and data type conversions, ensuring a smooth transition with minimal downtime. The tool supports various database platforms like PostgreSQL, MySQL, and SQLite, simplifying complex migration tasks.

When to use it

• You need to upgrade your application's database from an older version (e.g., MySQL 5.7 to MySQL 8).
• You are migrating data from one cloud provider’s database service to another (e.g., AWS RDS PostgreSQL to Google Cloud SQL for PostgreSQL).
• Your team needs to consolidate multiple databases into a single, unified system.
• You want to move your application's data to a different database technology entirely (e.g., from SQLite to PostgreSQL).

Key capabilities

• Schema transformation between various database types.
• Data type conversion during migration.
• Support for PostgreSQL, MySQL, and SQLite databases.
• Automated migration process with minimal downtime.

Example prompts

• "Migrate the 'users' table from my MySQL 5.7 database to a new PostgreSQL instance."
• “Can you convert the schema of my SQLite database to be compatible with MySQL?”
• "Perform a full data migration from our legacy on-premise MySQL server to AWS RDS for PostgreSQL, handling all necessary type conversions.”

Tips & gotchas

The skill requires access credentials and connection details for both the source and destination databases. Ensure these are provided accurately for successful execution; incorrect credentials will prevent the migration process from starting.