skills.rest
exelearning
exelearningOFFICIAL
Explore all skills by this author →
WebsiteGitHub

database-migration

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
One-click install
npx skills add https://github.com/exelearning/exelearning --skill database-migration-exelearning
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
OneWave-AIOneWave-AI
245

database-schema-designer

Design optimized SQL and NoSQL database schemas with ERDs and migration scripts.

Official
Basic
Cure-Consulting-GroupCure-Consulting-Group

data-migration

Migrate data between databases with validation and rollback mechanisms.

Official
Advanced
mgd34msumgd34msu
4

kysely

Implement type-safe SQL queries for PostgreSQL, MySQL, and SQLite with Kysely.

Community
Advanced
4lerman4lerman

sql-database-assistant

Generate SQL queries, introspect schemas, optimize performance, and create migration scripts.

Community
Advanced