skills.rest
weDevsOfficial
weDevsOfficialOFFICIAL
Explore all skills by this author →
Website𝕏@weDevsGitHub

db-migration

Create and implement WordPress plugin database migrations using PHP and SQL.

224|121|Updated Aug 18, 2012
Search Tags:#database#php#migration#sql#wordpress#schema update
One-click install
npx skills add https://github.com/weDevsOfficial/wp-project-manager --skill db-migration-wedevsofficial
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-migration
Source: https://github.com/weDevsOfficial/wp-project-manager/tree/main/.claude/skills/db-migration
Command: npx skills add https://github.com/weDevsOfficial/wp-project-manager --skill db-migration-wedevsofficial

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill facilitates safe and consistent database schema updates for WP Project Manager by guiding users on creating and applying migrations.

Core Features & Use Cases

  • Schema Changes: Add new columns or tables to existing database structures.
  • Migration Scripting: Assist in writing idempotent PHP migration scripts with proper existence checks.
  • Upgrade & Apply: Ensure updates are applied correctly during plugin activation or upgrades, preventing errors and data loss.
  • Use Case: When a user needs to add a 'priority' column to the tasks table, this Skill provides clear procedures for writing, testing, and deploying the migration.

Quick Start

Use the db-migration skill to generate a new migration script for updating the wp_pm_tasks table.

Frequently Asked Questions about db-migration

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

FAQPage Schema
How do I add a new column to a WordPress plugin database table?▼

WordPress database migrations are forward-only schema updates written as idempotent PHP scripts containing SQL commands, ensuring consistent structural changes like adding tables or columns across environments without data loss.

How do I write an idempotent database migration script in PHP for WordPress?▼

You write an idempotent WordPress migration script by including proper existence checks before executing SQL commands, ensuring schema modifications like adding tables or columns only apply once without causing activation errors.

When do I need a database migration for my WordPress plugin?▼

You need a database migration for your WordPress plugin when releasing schema updates that require adding new tables or columns, ensuring structural changes apply reliably during plugin activation or upgrades without data loss.

Can I use this database migration approach for data modification or just schema updates?▼

This database migration approach is limited strictly to schema updates like adding tables or columns, and does not support data modification, ensuring reliable forward-only structural changes across WordPress environments.

What is the best way to update a WordPress database schema without losing data?▼

The best way to update a WordPress database schema without losing data is using forward-only PHP migration scripts with proper existence checks, applying structural changes safely during plugin activation or upgrades.

Related Skills

Explore More Software Engineering Skills→
leonj1leonj1

rds-postgres

Connect to Amazon RDS PostgreSQL databases and execute SQL queries.

Community
Intermediate
jabrenajabrena
423

513-frameworks-micronaut-db-migrations-flyway

Manage Flyway database migrations in Micronaut applications.

Community
Advanced
adityaarsharmaadityaarsharma
2

orbit-life-rollback

Validate WordPress plugin rollback safety by checking schema, data shape, migration flags, and minimum version.

Community
Advanced
george11642george11642
2

db-supabase

Execute SQL, apply migrations, and deploy edge functions via Supabase MCP tools.

Community
Intermediate