MotherDuck Research
Discover key research materials on MotherDuck's innovations.

Cost-Based Hybrid Query Optimization in MotherDuck
This thesis tackles a core challenge in MotherDuck's hybrid execution model: deciding which parts of a query should run locally vs. in the cloud. The result is a cost-based optimizer that delivers up to 17x speedups on long-running analytical queries.

Towards Efficient Data Wrangling with LLMs using Code Generation
Instead of applying LLMs to every row, generate code once and run it on millions of rows. Up to 37-point F1 improvement on data transformations at a fraction of the cost.

MotherDuck: DuckDB in the Cloud and in the Client
We describe and demo MotherDuck: a new service that connects DuckDB to the cloud. MotherDuck provides the concept of hybrid query processing: the ability to execute queries partly on the client and partly in the cloud.


