database-migration

Name: database-migration
Availability: InStock
Author: eXeLearning

Create and rollback database schema changes across SQLite, PostgreSQL, and MariaDB.

138|25|Updated May 8, 2025

Search Tags:#database #schema #migration #sql #cross-database #kysely

Ready to run

npx skills add https://github.com/exelearning/exelearning --skill database-migration-exelearning

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-migration
Source: https://github.com/exelearning/exelearning/tree/main/.agents/skills/database-migration
Command: npx skills add https://github.com/exelearning/exelearning --skill database-migration-exelearning

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill streamlines the process of altering database schemas, enabling seamless migrations and updates with confidence.

Core Features & Use Cases

Schema Management: Create, modify, and rollback database structures like tables and indexes.
Cross-Platform Compatibility: Supports SQLite, PostgreSQL, and MariaDB with unified syntax.
Use Case: A developer needs to add a new column to a table in different environments, ensuring consistency and reliability across databases.

Quick Start

Use the database-migration skill to run a migration script that updates the database schema according to project requirements.

Frequently Asked Questions about database-migration

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I run cross-database schema migrations for SQLite, PostgreSQL, and MariaDB?▼

You can manage cross-database schema changes by running validated, portable migration scripts that ensure compatibility and safety across SQLite, PostgreSQL, and MariaDB dialects.

Can I rollback database schema changes like dropping tables or columns safely?▼

Yes, schema management features allow you to modify and rollback database structures like tables and indexes, ensuring safe alterations and reversals across supported database platforms.

Does this database migration approach work with Kysely for version control?▼

Yes, database migration and version control are facilitated for backend developers, handling cross-database schema changes using portable scripts compatible with the Kysely query builder ecosystem.

What is the best way to add a new column to a table across different SQL database environments?▼

The best way to add a new column across different SQL environments is using a unified syntax that generates portable scripts, ensuring consistency and reliability across multiple supported database dialects.

Are there limitations when creating portable SQL scripts for multiple database dialects?▼

Portable SQL scripts ensure safeties and compatibility across supported dialects, but migrations are specifically limited to creating and dropping tables and columns within SQLite, PostgreSQL, and MariaDB.