Learn R Programming

status](https://www.r-pkg.org/badges/version/motherduck?svg=1.png)](https://CRAN.R-project.org/package=motherduck)

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")

Copy Link

Version

Install

install.packages('motherduck')

Version

0.2.0

License

MIT + file LICENSE

Maintainer

Alejandro Hagan

Last Published

December 2nd, 2025

Functions in motherduck (0.2.0)

create_table_tbl

Overwrite or Append a Local Tibble to a Database Table
drop_share

Drop a MotherDuck share
delete_md_user

Delete a MotherDuck user
delete_schema

Drop a Schema from a Database
describe_share

Describe a MotherDuck share
delete_table

Drop a Table
launch_ui

Launch the DuckDB UI in your browser
list_setting

List Database Settings
create_md_user

Create a new MotherDuck user
list_owned_shares

List all shares owned by the current user
create_md_access_token

Create a MotherDuck access token
list_all_databases

List Databases Visible to the Connection
list_fns

List Database Functions (DuckDB/MotherDuck)
read_excel

Read an Excel file into a DuckDB/MotherDuck table
delete_database

Drop a Database
delete_md_access_token

Delete a MotherDuck user's access token
list_md_active_accounts

List active MotherDuck accounts
read_csv

Read a CSV file into a DuckDB/MotherDuck table
validate_md_connection_status

Validate Mother Duck Connection Status
install_extensions

Install DuckDB/MotherDuck Extensions
validate_extension_install_status

Validate Installed MotherDuck/DuckDB Extensions
validate_extension_load_status

Validate Loaded MotherDuck/DuckDB Extensions
list_md_user_instance

List a MotherDuck user's instance settings
list_md_user_tokens

List a MotherDuck user's tokens
create_table_dbi

Create a Database Table from a DBI Object
summary

Summarize a Lazy DBI Table
validate_and_print_database_loction

validate and Pprint your database location
validate_con

Validate connection is DuckDB
list_shares

List MotherDuck Shares
list_extensions

List MotherDuck/DuckDB Extensions
delete_and_create_schema

Drop and Recreate a Schema in a MotherDuck / DuckDB Database
list_shared_with_me_shares

List all shares shared with the current user
list_current_tables

List Tables in the Current Database and Schema
upload_database_to_md

Upload a Local Database to MotherDuck
list_all_tables

List All Tables Visible to the Connection
pwd

Print Current MotherDuck Database Context
list_current_schemas

List Schemas in the Current Database
load_extensions

Load and Install DuckDB/MotherDuck Extensions
show_current_user

Show current database user
show_motherduck_token

Show Your MotherDuck Token
cd

Change Active Database and Schema
config_csv

DuckDB CSV read configuration (config_csv)
cli_show_db

Catalog Report Generator
create_if_not_exists_share

Create a MotherDuck database share if it does not exist
alter_table_schema

Move Tables from One Schema to Another
create_database

Create (If Not Exists) and Switch to a Database
create_schema

Create a Schema in a Database if It Does Not Exist
cli_create_obj

Database, Schema, and Table Creator
convert_table_to_sql_id

Convert Table Metadata to SQL Identifiers
config_parquet

DuckDB Parquet read configuration (config_parquet)
config_excel

DuckDB Excel read configuration (config_excel)
config_db

DuckDB runtime database configuration (config_db)
create_or_replace_share

Create or replace a MotherDuck database share
cli_delete_obj

CLI print deleted objects
cli_show_user

User Information Report
copy_tables_to_new_location

Copy Tables to a New Database/Schema
connect_to_motherduck

Create connection to motherduck
configure_md_user_settings

Configure a MotherDuck user's settings
create_table

Create or Append a Table from a Tibble or DBI-Backed Table