Package index

Connection & Session Management

connect_to_motherduck()

Create connection to motherduck

cd()

Change Active Database and Schema

pwd()

Print Current MotherDuck Database Context

validate_con()

Validate connection is DuckDB

validate_md_connection_status()

Validate Mother Duck Connection Status

show_current_user()

Show current database user

show_motherduck_token()

Show Your MotherDuck Token

launch_ui()

Launch the DuckDB UI in your browser

Database Management

create_database()

Create (If Not Exists) and Switch to a Database

delete_database()

Drop a Database

list_all_databases()

List Databases Visible to the Connection

upload_database_to_md()

Upload a Local Database to MotherDuck

validate_and_print_database_loction()

validate and Pprint your database location

Schema Management

create_schema()

Create a Schema in a Database if It Does Not Exist

delete_schema()

Drop a Schema from a Database

list_current_schemas()

List Schemas in the Current Database

alter_table_schema()

Move Tables from One Schema to Another

copy_tables_to_new_location()

Copy Tables to a New Database/Schema

delete_and_create_schema()

Drop and Recreate a Schema in a MotherDuck / DuckDB Database

Table Management

create_table()

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

delete_table()

Drop a Table

list_all_tables()

List All Tables Visible to the Connection

list_current_tables()

List Tables in the Current Database and Schema

File Import (CSV, Excel, Parquet)

read_csv()

Read a CSV file into a DuckDB/MotherDuck table

read_excel()

Read an Excel file into a DuckDB/MotherDuck table

config_csv

DuckDB CSV read configuration (config_csv)

config_excel

DuckDB Excel read configuration (config_excel)

config_parquet

DuckDB Parquet read configuration (config_parquet)

Configuration & Settings

config_db

DuckDB runtime database configuration (config_db)

list_setting()

List Database Settings

list_fns()

List Database Functions (DuckDB/MotherDuck)

Extensions

install_extensions()

Install DuckDB/MotherDuck Extensions

load_extensions()

Load and Install DuckDB/MotherDuck Extensions

list_extensions()

List MotherDuck/DuckDB Extensions

validate_extension_install_status()

Validate Installed MotherDuck/DuckDB Extensions

validate_extension_load_status()

Validate Loaded MotherDuck/DuckDB Extensions

MotherDuck User & Account Management

create_md_user()

Create a new MotherDuck user

delete_md_user()

Delete a MotherDuck user

list_md_active_accounts()

List active MotherDuck accounts

list_md_user_instance()

List a MotherDuck user's instance settings

configure_md_user_settings()

Configure a MotherDuck user's settings

MotherDuck Tokens

create_md_access_token()

Create a MotherDuck access token

delete_md_access_token()

Delete a MotherDuck user's access token

list_md_user_tokens()

List a MotherDuck user's tokens

MotherDuck Shares

create_if_not_exists_share()

Create a MotherDuck database share if it does not exist

create_or_replace_share()

Create or replace a MotherDuck database share

drop_share()

Drop a MotherDuck share

describe_share()

Describe a MotherDuck share

list_shares()

List MotherDuck Shares

list_owned_shares()

List all shares owned by the current user

list_shared_with_me_shares()

List all shares shared with the current user

Utilities

validate_and_print_database_loction()

validate and Pprint your database location

summary(<tbl_lazy>)

Summarize a Lazy DBI Table