skills.rest
gaebalai
gaebalaiCOMMUNITY
Explore all skills by this author →
Website𝕏@gaebalaiGitHub

db-backfill-plan

Generate a phased database backfill plan with SQL design and rollback procedures.

2|Updated Feb 25, 2026
Search Tags:#planning#rollback#database#sql#data migration#backfill
One-click install
npx skills add https://github.com/gaebalai/claude-code-kit-ko --skill db-backfill-plan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-backfill-plan
Source: https://github.com/gaebalai/claude-code-kit-ko/tree/main/.claude/skills/db-backfill-plan
Command: npx skills add https://github.com/gaebalai/claude-code-kit-ko --skill db-backfill-plan

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you create a safe, step-by-step plan for modifying or supplementing existing data in your database, minimizing service impact and ensuring rollback capabilities.

Core Features & Use Cases

  • Strategic Planning: Develop a comprehensive plan for data backfilling, including batch sizing, execution modes, and rollback procedures.
  • SQL Design: Generate SQL statements for data updates, progress tracking, and validation.
  • Use Case: You need to update a critical column in a large production table. This Skill will guide you through analyzing the current state, defining a safe update strategy, writing the necessary SQL, and planning for potential issues and rollbacks.

Quick Start

Generate a plan to backfill the 'email' column in the 'users' table, ensuring all existing null values are updated.

Frequently Asked Questions about db-backfill-plan

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

FAQPage Schema
How do I safely backfill a large database table in production?▼

Database backfill rollback procedures involve generating specific SQL statements designed to reverse data updates. A solid backfill plan includes predefined rollback steps that address recovery needs, ensuring you can safely restore data integrity if service disruption or modification errors occur.

What is the best way to plan a data migration for existing SQL records?▼

Database backfill strategies for large-scale data modifications include phased execution, batch sizing, and specific execution modes. By generating targeted SQL for data updates and progress tracking, these strategies mitigate risks to data integrity and prevent service disruption.

Can I generate SQL statements for batch updates and progress tracking?▼

Yes, you can generate SQL statements for batch updates and progress tracking as part of a comprehensive backfill plan. This includes designing data update SQL, validation queries, and rollback procedures to monitor and safely execute modifications on existing database records.

When do I need a rollback procedure for database backfills?▼

You need a rollback procedure for database backfills whenever you are performing large-scale data modifications on existing records. Planning for rollback addresses recovery needs and mitigates risks associated with data integrity issues or unexpected service disruption during critical updates.

Related Skills

Explore More Software Engineering Skills→
rabbicserabbicse

database-optimizer

Optimize slow PostgreSQL and MySQL queries with EXPLAIN ANALYZE validation.

Community
Advanced
lekemulalekemula

rails-query-analyzer

Analyzes ActiveRecord queries for performance issues and suggests optimizations.

Community
Advanced
himanshu231204himanshu231204
2

database-migrations

Plan zero-downtime PostgreSQL and MySQL schema migrations with expand-contract strategies.

Community
Advanced
MicrockMicrock
322

data-migration

Plan and execute database migrations with rollback and integrity validation.

Community
Advanced