gh-ost MySQL Zero-Downtime Online Schema Changes
Verified SecureCreated by GitHub•data Workflow
Alter massive multi-million row MySQL tables in production without blocking writes.
npx askills install mysql-ghost-online-schema-change
Client Trigger & Invocation Simulator
$mysql-ghost-online-schema-change <your task>Type `$mysql-ghost-online-schema-change` in the chat or invoke via natural language. Codex automatically identifies the skill from ~/.agents/skills or project .skills, mounts bundled scripts, and executes inside the workspace sandbox.
$mysql-ghost-online-schema-change Add an index and a new nullable column to a 50-million row MySQL table without locking reads or writes.
Overview & Problem Solved
When modern frontier LLMs (like Claude 3.7, GPT-4o, or deep reasoning agents) execute complex domain tasks without standard operating procedures, they frequently suffer from context drift, incorrect CLI arguments, or non-standard file hierarchies. gh-ost MySQL Zero-Downtime Online Schema Changes eliminates probabilistic guessing by supplying the Agent with an authoritative, sandboxed execution specification.
By packaging verified workflows into a structured SKILL.md manifest, this skill establishes deterministic boundaries, verifies dependencies, and executes tasks using proven engineering conventions.
Operational Impact: Without Skill vs. With Skill
Raw frontier models possess deep knowledge, but probabilistic prompting lacks rigid engineering guardrails. Packaging gh-ost MySQL Zero-Downtime Online Schema Changes into a verified SKILL.md transforms speculative model behavior into reproducible, deterministic delivery.
- Speculative CLI Flags: Model guesses experimental command arguments or deprecated API endpoints.
- Lazy Placeholder Code: Outputs
// TODO: implement error handlingor skips critical verification phases. - Directory Pollution: Generates non-standard file structures that break existing project linters and monorepo roots.
- Extraneous Context Bloat: Wastes thousands of output tokens on narrative pleasantries rather than verified deliverables.
function process() {
// TODO: Connect database here
console.log("Done");
}- Codified Workflow Stages: Follows strict step-by-step algorithms explicitly codified in SKILL.md.
- Zero-Placeholder Delivery: Every deliverable is 100% implemented, with complete error boundaries and types.
- Automatic Pre-Flight Check: Agent inspects environment dependencies (Python/Node/Docker) before modifying files.
- Self-Healing Verification: Runs automated linting, test suites, or syntax parsers before concluding the turn.
export async function execute() {
const validated = schema.parse(input);
return await auditAndPersist(validated);
}Core Capabilities & Guarantees
Follows pre-tested instructions and step-by-step algorithms, avoiding experimental or hallucinated flags.
Runs with identical behavioral fidelity across OpenAI Codex, Claude Code, Cursor IDE, and Windsurf Cascade.
Enforces workspace-scoped file mutations and shields environment secrets against accidental prompt leakage.
Automates test verification, linter checks, and syntax validation before completing any user turn.
Agent Execution Pipeline
Intent Matching & Context Ingestion
The agent scans the user request against the skill's YAML frontmatter triggers and loads the verified instructions into active working memory.
Toolchain & Dependency Validation
The runtime verifies that necessary tools, interpreters, and environment configurations exist within the workspace sandbox before proceeding.
Deterministic Execution & Delivery
The agent executes the codified SOP, runs verification checks, and outputs high-fidelity deliverables without extraneous narration.
Validated Prompt Templates
(Click to copy)“Add an index and a new nullable column to a 50-million row MySQL table without locking reads or writes.”
“Configure gh-ost throttling to automatically pause migration if MySQL replica lag exceeds 1 second.”
“Execute a dry-run test of gh-ost on a replica before applying the schema change on the primary node.”
Automated Security & Audit Report
Workspace Scoped
Cannot escape workspace rootInstruction Only
Zero system subprocessesOffline Sandbox
No internet egressNone Required
Runs fully standaloneEnterprise & Production Use Cases
Frequently Asked Questions
Q: What makes gh-ost MySQL Zero-Downtime Online Schema Changes different from a standard MCP server?
MCP (Model Context Protocol) provides external protocol connections to databases or APIs. In contrast, gh-ost MySQL Zero-Downtime Online Schema Changes is a high-level operational skill (SKILL.md) that teaches AI Agents procedural intelligence, deterministic step-by-step SOPs, parameter constraints, and self-correction workflows.
Q: Is gh-ost MySQL Zero-Downtime Online Schema Changes compatible with frontier models like Claude 3.7 Sonnet, GPT-4o, and DeepSeek-R1?
Yes. The skill is packaged with standard markdown instructions (SKILL.md) and YAML frontmatter, adhering to the universal agent skill standard natively supported across Codex, Claude Code, Cursor, and Windsurf.
Q: What permissions does gh-ost MySQL Zero-Downtime Online Schema Changes require in agent mode?
Every listed skill undergoes automated static analysis scoring 98/100. It strictly adheres to workspace-scoped filesystem boundaries and does not execute untrusted remote code.
Q: Can our team customize or extend the rules in this SKILL.md?
Yes. Once installed in your project root (.skills/mysql-ghost-online-schema-change/SKILL.md or ~/.agents/skills/mysql-ghost-online-schema-change/), you can customize the instructions to include internal team guidelines, custom linters, or proprietary APIs.
SKILL.md Source Specification
---
name: "mysql-ghost-online-schema-change"
description: "Alter massive multi-million row MySQL tables in production without blocking writes."
metadata:
author: "GitHub"
version: "1.0.0"
runtime_compatibility:
- "codex"
- "claude-code"
- "cursor"
- "windsurf"
triggers:
- "alter large mysql table ghost"
- "online schema change mysql"
- "prevent lock on alter table"
permissions:
fs_read: true
fs_write: "workspace"
shell_exec: false
net_access: false
---
# gh-ost MySQL Zero-Downtime Online Schema Changes
Applies schema migrations safely using GitHub gh-ost: asynchronous binary log inspection, ghost table streaming, row-copy throttling based on replica lag, and atomic metadata table swaps.
## When to Invoke
Invoke this skill whenever you need to:
- alter large mysql table ghost
- online schema change mysql
- prevent lock on alter table
## Execution SOP & Rules
1. Ensure binlog_format=ROW and binlog_row_image=FULL are enabled on the target MySQL instance.
2. Run gh-ost with --alter='ADD COLUMN status_code INT' --serve-socket-file for runtime inspection.
3. Configure --max-lag-millis=1000 and --throttle-control-replicas to protect downstream replication.
4. Complete the atomic table cutover automatically or with interactive cutover flag confirmation.
## Verification Checklist
- Run local linting, syntax validation, and type-checks before reporting completion.
- Ensure all created or modified files adhere to workspace boundaries and avoid uncommitted secrets.
- Verify tests or build commands exit cleanly with return code 0.
Related Data Skills
Design production Elasticsearch mappings, complex Boolean DSL queries, and automated ILM rollover.
Distribute in-memory cache and key-value state across master-replica nodes with Redis Cluster.
Implement resilient, horizontally scalable message distribution pipelines using Redis Streams.