Settings

Theme

Show HN: Scry – Test migrations against production scale copy of your DB

scrydata.com

5 points by gmcquillan a month ago · 1 comment

Reader

gmcquillanOP a month ago

We built a tool that catches migration regressions before production by replaying real query traffic against shadow databases.

The blog post walks through a concrete example: a missing index that causes a 92x regression on a core query path. Staging misses it because it has 100 rows instead of 25k. Scry catches it because it replays actual production queries at real data scale.

You can replay this exact scenario locally in under 2 minutes:

scry demo Install: https://github.com/scrydata/scry-cli/releases

The demo spins up a source Postgres, applies a migration with a missing index, replays captured traffic, and shows you the regression report. No cloud account needed — everything runs locally.

Happy to answer questions about the architecture (transparent PG proxy for query capture, CDC replication for shadow databases, NATS for event streaming).

Keyboard Shortcuts

j
Next item
k
Previous item
o / Enter
Open selected item
?
Show this help
Esc
Close modal / clear selection