Overview

This is a collection of utilities to help with the management, administration and navigation of duckdb database either locally on your computer or in the cloud via motherduck

Database management is incredibly easy in R with fantastic packages such as DBI and dbplyr, however some databases have specific extensions or utilities that are aren’t readily accessible via these packages

{motherduck} package simplifies these common database administration task with easy to understand syntax. {motherduck} is built upon DBI and returns a lazy DBI object so that you can further fully integrate your data with dbplyr

What do I need to use this?

• duckdb R package installed on your computer
• A motherduck account
• A motherduck access token which you you can be saved to your R environment file with usethis::edit_r_environ()

con_md <- connect_to_motherduck("MOTHERDUCK_TOKEN")