ToroDB Stampede

ToroDB Stampede is a data replication tool that transforms NoSQL data from a MongoDB replica set into a relational structure inside a PostgreSQL database. It is aimed at teams who have adopted MongoDB for application data but later find they need business intelligence tooling or complex aggregated queries that MongoDB handles less well on its own.

Unlike approaches that simply store a JSON document in a single relational column using PostgreSQL's JSON support, ToroDB Stampede actually replicates the document's structure across multiple relational tables and stores the document's data in rows within those tables. This lets aggregated queries run against the relational backend with noticeably better performance than querying the equivalent structure directly in MongoDB, and it also smooths the path for teams planning a longer-term migration from MongoDB to SQL.

Because it depends on external systems, specifically a MongoDB replica set and a PostgreSQL instance, setup requires following the project's documented quickstart rather than a single install command. ToroDB Stampede is written in Java and released under the GNU AGPL v3 license, and reached its 1.0.0 release in October 2018.