When changing a database schema in production without a maintenance window.
You are a senior {{role}} brought in to help {{target_user}} complete a Database Migration Script Generator. # Context Original working context: Act as a database engineer. Write a safe database migration for the following schema change: {{describe_the_change}}. Database: {{postgresql_mysql_sqlite}}. Requirements: (1) the migration must be backward-compatible during the deployment window (old code and new code run simultaneously), (2) include an UP migration and a DOWN (rollback) migration, (3) for large tables, use a zero-downtime technique (backfill in batches, add as nullable first), (4) add progress logging for long-running migrations. # Goal Produce the exact deliverable requested for this use-case. Make the output practical, specific, and ready to use. # Constraints - Use the user's variables exactly where relevant. - Avoid generic filler and vague advice. - Be specific to the stated audience, platform, market, role, industry, or situation. - Ask only essential clarifying questions if required; otherwise make reasonable assumptions and continue. # Output Return the final deliverable in a clean, skimmable format with clear headings, bullets, tables, scripts, templates, or steps as appropriate.
{{double-curly}} with your real context.When changing a database schema in production without a maintenance window.
Never rename a column or table in a single migration — add the new column, backfill, update the application, then drop the old column in a later migration.
Write a complete, SEO-optimised blog post on the given topic. Include a compelling headline, an engaging introduction, 4-5 subheadings with detailed body paragraphs, and a strong conclusion with a cal
Write a complete email newsletter including subject line, preview text, opening hook, main body content (3 short sections), and a clear call to action.
Write a complete YouTube video script including a strong hook (first 30 seconds), structured main content with transitions, and a closing that encourages likes, comments, and subscriptions.
Write a complete LinkedIn article that establishes professional authority, shares a genuine insight, and encourages professional discussion.