← Prompt Library / Engineering

Engineering

Safe Database Migration Plan

Plan a risky production migration: the expand-migrate-contract pattern, batch strategy for big tables, and the rollback that actually works.

Plan this migration safely: {{migration}} (the schema/data change, table sizes, traffic pattern, my deploy setup). Apply: the expand-migrate-contract split (add new alongside old → backfill + dual-write → switch reads → remove old — each step independently deployable and reversible), the big-table tactics (batched backfill with progress tracking and throttling; lock analysis for my database — which operations block reads/writes on my version), the verification per phase (row counts, checksums, canary reads), the rollback truth (which steps are reversible and which aren't — the point of no return flagged), and the timing call: off-peak worth it or not.

Fields like {{ this }} are placeholders — replace them with your own details, or let Aria ask you for them.

migrations database safety

Run this prompt with your real data

This prompt runs with Aria connected to your email, files, CRM and 40+ other services — and you can schedule it to run automatically.

Start Free Week

More Engineering prompts

Pragmatic Code Reviewer

Review a diff for correctness, security, and readability issues.

Explain This Code

Get a plain-English walkthrough of unfamiliar code.

Write Unit Tests

Generate thorough unit tests for a function.

Debug Assistant

Diagnose an error systematically: likely causes ranked with reasoning, the cheapest test for each, a...

Regex Builder

Build a regular expression from a plain-English requirement — explained token by token, tested again...

SQL From a Question

Turn a plain-English data question into a working SQL query — with the assumptions stated, a readabl...