Skip to content

Database Migration Safety Checker

Flag migrations that will lock tables or lose data before they run.

Intermediate14h1–2 people17/20 fit
TL;DR

Build Database Migration Safety Checker for backend teams in ~14h with 1–2 people. Stack: Node.js + Postgres + GitHub Actions.

Why it wins: Prevents outages with simple rules.

Build flow

01 · Problem
Migrations take production down with long locks.
02 · Solution
Parse migration SQL, detect risky operations like full rewrites, missing defaults and dropped columns and suggest safer steps.
03 · Build
  1. 1Parse SQL
  2. 2Encode rules
  3. 3Comment on PRs
  4. 4Suggest fixes
04 · Demo
Add a column with a default and see the lock warning.

MVP checklist

  • SQL parsing
  • Risk rules
  • Safer alternatives
  • PR check

Tech stack

TechRole
Node.jsBackend runtime
PostgresRelational database
GitHub ActionsRepo + PR data

Related ideas

More Devtools
  • Screenshot key pages on each PR and highlight visual changes

    Intermediate16h1–2
    PlaywrightGitHub ActionsNode.js
    17/20
  • Catch quality drops when prompts or models change

    Intermediate14h1–2
    Node.jsLLMGitHub Actions
    17/20