Schema compare & drift

Catch schema drift before it bites

Compare the inferred schemas of two collections, or of one collection over time. Save snapshots, browse history and diff fields, indexes, validators and collection options.

Get MotionQL free All features

Capabilities

What you can do with it

Collection vs collection

Compare fields, indexes, validator and collection options between two collections, on the same or different connections.

Snapshots

Save a schema snapshot of a collection and compare it with a later snapshot or with the collection as it is now.

History

Browse earlier snapshots, newest first.

Export the diff

Markdown, HTML or JSON for reviews and tickets.

Computed on the server

Field statistics are computed with $sample and $group; only paths, type names and counts come back.

Encrypted at rest

Snapshots are stored encrypted on your computer.

On a schedule

Record schema snapshots automatically as a scheduled task (Pro).

Related features

Schema analysis & ER diagram

Analyze a sample of documents for fields, types and how often each one appears, then draw the whole database as an ER diagram with relationships MotionQL infers and checks for you.

Learn more

Compare & sync

Diff two collections document by document, on the same or different clusters, preview the sync, and apply only the changes you choose.

Learn more

Tasks, scheduling & CLI

Save exports, syncs, dumps, scripts and more as tasks, run them on a schedule even while MotionQL is closed, or start them from your own scripts with --cli.

Learn more

Your next query deserves a better IDE.

Create a free account, download MotionQL, and paste your Pro key. You'll be querying in under two minutes.

Get MotionQL free Explore every feature