Function reference

All functions and classes exported by motherduck.

All functions

alter_table_schema(): Move Tables from One Schema to Another
cd(): Change Active Database and Schema
config_csv: DuckDB CSV read configuration (config_csv)
config_db: DuckDB runtime database configuration (config_db)
config_excel: DuckDB Excel read configuration (config_excel)
config_parquet: DuckDB Parquet read configuration (config_parquet)
configure_md_user_settings(): Configure a MotherDuck user’s settings
connect_to_motherduck(): Create connection to motherduck
copy_tables_to_new_location(): Copy Tables to a New Database/Schema
create_database(): Create (If Not Exists) and Switch to a Database
create_if_not_exists_share(): Create a MotherDuck database share if it does not exist
create_md_access_token(): Create a MotherDuck access token
create_md_user(): Create a new MotherDuck user
create_or_replace_share(): Create or replace a MotherDuck database share
create_r2_secret(): Register a Cloudflare R2 secret on a connection
create_s3_secret(): Register a generic S3 (S3-compatible) secret on a connection
create_schema(): Create a Schema in a Database if It Does Not Exist
create_table(): Create or Append a Table from a Tibble or DBI-Backed Table
delete_and_create_schema(): Drop and Recreate a Schema in a MotherDuck / DuckDB Database
delete_database(): Drop a Database
delete_md_access_token(): Delete a MotherDuck user’s access token
delete_md_user(): Delete a MotherDuck user
delete_schema(): Drop a Schema from a Database
delete_table(): Drop a Table
describe_share(): Describe a MotherDuck share
drop_share(): Drop a MotherDuck share
install_extensions(): Install DuckDB/MotherDuck Extensions
launch_ui(): Launch the DuckDB UI in your browser
list_all_databases(): List Databases Visible to the Connection
list_all_tables(): List All Tables Visible to the Connection
list_current_schemas(): List Schemas in the Current Database
list_current_tables(): List Tables in the Current Database and Schema
list_extensions(): List MotherDuck/DuckDB Extensions
list_fns(): List Database Functions (DuckDB/MotherDuck)
list_md_active_accounts(): List active MotherDuck accounts
list_md_user_instance(): List a MotherDuck user’s instance settings
list_md_user_tokens(): List a MotherDuck user’s tokens
list_owned_shares(): List all shares owned by the current user
list_setting(): List Database Settings
list_shared_with_me_shares(): List all shares shared with the current user
list_shares(): List MotherDuck Shares
load_extensions(): Load and Install DuckDB/MotherDuck Extensions
pwd(): Print Current MotherDuck Database Context
read_csv(): Read a CSV file into a DuckDB/MotherDuck table
read_excel(): Read an Excel file into a DuckDB/MotherDuck table
show_current_user(): Show current database user
show_information_schema(): Show Information Schema Schemas
show_motherduck_token(): Show Your MotherDuck Token
summarytbl_lazy(): Summarize a Lazy DBI Table
upload_database_to_md(): Upload a Local Database to MotherDuck
validate_con(): Validate connection is DuckDB
validate_database_exists(): Check if a Database Exists
validate_database_schema_exists(): Check if a Schema Exists in a Database
validate_extension_install_status(): Validate Installed MotherDuck/DuckDB Extensions
validate_extension_load_status(): Validate Loaded MotherDuck/DuckDB Extensions
validate_md_connection_status(): Validate Mother Duck Connection Status