All capabilities
02 / 14One query · every source

Your data can stay where it already works.

River gives your team one SQL surface across Postgres, MySQL, MongoDB, and more. Join operational and analytical data without a migration project or a new silo to maintain.

Under the hood

PostgreSQLMySQLMongoDBSQLitePushdown plannerNative translationStreaming results

The problem

Teams lose days moving data into a warehouse before they can answer a question. By the time the copy is ready, it is stale — and the original systems still need to be maintained.

The River approach

River plans each part of a query and pushes work down to the source that owns the data, combining the results in one transparent execution plan.

See it working

Inside Federated SQL.

Results of a federated query joined across Postgres and MongoDB
One query, two backends — rows joined across Postgres and MongoDB with no copy in between.

What changes for your team

Less friction between the question and the answer.

Answer cross-system questions while data stays in place
Reduce duplicate pipelines and warehouse maintenance
Give analysts a consistent catalog and SQL workflow
01

Connect

Register your existing databases and services once.

02

Compose

Write one familiar SQL query across sources.

03

Understand

Inspect the plan and results without hidden copies.

Next capability

Lily, your AI assistant

Explore Lily, your AI assistant