{
"_id": "6a1c10561d7bb097a0a2e8c5",
"Package": "motherduck",
"Type": "Package",
"Title": "Utilities for Managing a 'Motherduck' Database",
"Version": "0.2.3",
"Authors@R": "person(\n\"Alejandro\", \"Hagan\",\nemail = \"alejandro.hagan@outlook.com\",\nrole = c(\"aut\", \"cre\")\n)",
"Description": "Provides helper functions, metadata utilities, and\nworkflows for administering and managing 'DuckDB' databases on\nthe 'MotherDuck' cloud platform. Some features require a\n'MotherDuck' account (). Note: Windows\nis not supported; use 'WSL' (Windows Subsystem for Linux)\ninstead\n().",
"License": "MIT + file LICENSE",
"Encoding": "UTF-8",
"Roxygen": "list(markdown = TRUE)",
"RoxygenNote": "7.3.3",
"LazyData": "true",
"Config/testthat/edition": "3",
"URL": "https://usrbinr.github.io/motherduck/",
"BugReports": "https://codeberg.org/usrbinr/motherduck/issues",
"Config/Needs/website": "rmarkdown",
"Config/pak/sysreqs": "libicu-dev libssl-dev xz-utils",
"Repository": "https://usrbinr.r-universe.dev",
"Date/Publication": "2026-03-01 16:31:39 UTC",
"RemoteUrl": "https://github.com/usrbinr/motherduck",
"RemoteRef": "HEAD",
"RemoteSha": "119b592b75070896ff5de4448d3c0f3c06e2abfc",
"NeedsCompilation": "no",
"Packaged": {
"Date": "2026-05-31 10:37:23 UTC",
"User": "root"
},
"Author": "Alejandro Hagan [aut, cre]",
"Maintainer": "Alejandro Hagan ",
"MD5sum": "9951b95e57e8907a4364b5fd3fd807ed",
"_user": "usrbinr",
"_type": "src",
"_file": "motherduck_0.2.3.tar.gz",
"_fileid": "d54e57a78b92940011b54b56a21ff491cd600e4135349ab2685d6d6cac9652a1",
"_filesize": 2347974,
"_sha256": "d54e57a78b92940011b54b56a21ff491cd600e4135349ab2685d6d6cac9652a1",
"_created": "2026-05-31T10:37:23.000Z",
"_published": "2026-05-31T10:41:26.146Z",
"_distro": "noble",
"_jobs": [
{
"job": 78719177033,
"time": 147,
"config": "linux-devel-x86_64",
"r": "4.7.0",
"check": "OK",
"artifact": "7316032809"
},
{
"job": 78719177042,
"time": 142,
"config": "linux-release-x86_64",
"r": "4.6.0",
"check": "OK",
"artifact": "7316032460"
},
{
"job": 78719177039,
"time": 155,
"config": "macos-oldrel-arm64",
"r": "4.5.3",
"check": "OK",
"artifact": "7316030350"
},
{
"job": 78719177034,
"time": 211,
"config": "macos-release-arm64",
"r": "4.6.0",
"check": "OK",
"artifact": "7316037877"
},
{
"job": 78718994846,
"time": 194,
"config": "source",
"r": "4.6.0",
"check": "OK",
"artifact": "7316017366"
},
{
"job": 78719177031,
"time": 112,
"config": "wasm-release",
"r": "4.6.0",
"check": "OK",
"artifact": "7316029125"
},
{
"job": 78719177036,
"time": 115,
"config": "windows-devel",
"r": "4.7.0",
"check": "OK",
"artifact": "7316030604"
},
{
"job": 78719177048,
"time": 92,
"config": "windows-oldrel",
"r": "4.5.3",
"check": "OK",
"artifact": ""
},
{
"job": 78719177030,
"time": 98,
"config": "windows-release",
"r": "4.6.0",
"check": "OK",
"artifact": "7316027641"
}
],
"_buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26710232746",
"_status": "success",
"_host": "GitHub-Actions",
"_upstream": "https://github.com/usrbinr/motherduck",
"_commit": {
"id": "119b592b75070896ff5de4448d3c0f3c06e2abfc",
"author": "hagan ",
"committer": "hagan ",
"message": "Update ignore files\n",
"time": 1772382699
},
"_maintainer": {
"name": "Alejandro Hagan",
"email": "alejandro.hagan@outlook.com",
"login": "usrbinr",
"description": "",
"uuid": 87534364
},
"_registered": true,
"_dependencies": [
{
"package": "R",
"version": ">= 4.1.0",
"role": "Depends"
},
{
"package": "DBI",
"role": "Imports"
},
{
"package": "assertthat",
"role": "Imports"
},
{
"package": "cli",
"role": "Imports"
},
{
"package": "dbplyr",
"role": "Imports"
},
{
"package": "dplyr",
"role": "Imports"
},
{
"package": "duckdb",
"version": ">= 1.3.0",
"role": "Imports"
},
{
"package": "glue",
"role": "Imports"
},
{
"package": "purrr",
"role": "Imports"
},
{
"package": "stringr",
"role": "Imports"
},
{
"package": "httr2",
"role": "Imports"
},
{
"package": "rlang",
"role": "Imports"
},
{
"package": "janitor",
"role": "Imports"
},
{
"package": "tibble",
"role": "Imports"
},
{
"package": "testthat",
"version": ">= 3.0.0",
"role": "Suggests"
},
{
"package": "quarto",
"role": "Suggests"
},
{
"package": "contoso",
"role": "Suggests"
},
{
"package": "openxlsx",
"role": "Suggests"
}
],
"_owner": "usrbinr",
"_selfowned": true,
"_usedby": 0,
"_updates": [
{
"week": "2025-46",
"n": 12
},
{
"week": "2025-47",
"n": 7
},
{
"week": "2025-48",
"n": 2
},
{
"week": "2025-49",
"n": 1
},
{
"week": "2025-50",
"n": 1
},
{
"week": "2025-51",
"n": 3
},
{
"week": "2025-52",
"n": 2
},
{
"week": "2026-06",
"n": 1
},
{
"week": "2026-08",
"n": 1
},
{
"week": "2026-09",
"n": 3
}
],
"_tags": [],
"_stars": 1,
"_contributors": [
{
"user": "usrbinr",
"count": 28,
"uuid": 87534364
}
],
"_userbio": {
"uuid": 87534364,
"type": "user",
"name": "usr/bin/R"
},
"_downloads": {
"count": 496,
"source": "https://cranlogs.r-pkg.org/downloads/total/last-month/motherduck"
},
"_devurl": "https://codeberg.org/usrbinr/motherduck",
"_searchresults": 2,
"_rbuild": "4.6.0",
"_assets": [
"extra/citation.cff",
"extra/citation.html",
"extra/citation.json",
"extra/citation.txt",
"extra/contents.json",
"extra/motherduck.html",
"extra/NEWS.html",
"extra/NEWS.txt",
"extra/readme.html",
"extra/readme.md",
"manual.pdf"
],
"_homeurl": "https://github.com/usrbinr/motherduck",
"_realowner": "usrbinr",
"_cranurl": true,
"_releases": [
{
"version": "0.2.0",
"date": "2025-12-02"
},
{
"version": "0.2.1",
"date": "2025-12-22"
}
],
"_exports": [
"alter_table_schema",
"cd",
"configure_md_user_settings",
"connect_to_motherduck",
"copy_tables_to_new_location",
"create_database",
"create_if_not_exists_share",
"create_md_access_token",
"create_md_user",
"create_or_replace_share",
"create_schema",
"create_table",
"delete_and_create_schema",
"delete_database",
"delete_md_access_token",
"delete_md_user",
"delete_schema",
"delete_table",
"describe_share",
"drop_share",
"install_extensions",
"launch_ui",
"list_all_databases",
"list_all_tables",
"list_current_schemas",
"list_current_tables",
"list_extensions",
"list_fns",
"list_md_active_accounts",
"list_md_user_instance",
"list_md_user_tokens",
"list_owned_shares",
"list_setting",
"list_shared_with_me_shares",
"list_shares",
"load_extensions",
"pwd",
"read_csv",
"read_excel",
"show_current_user",
"show_information_schema",
"show_motherduck_token",
"upload_database_to_md",
"validate_database_exists",
"validate_database_schema_exists",
"validate_extension_install_status",
"validate_extension_load_status",
"validate_md_connection_status"
],
"_datasets": [
{
"name": "config_csv",
"title": "DuckDB CSV read configuration (config_csv)",
"object": "config_csv",
"class": [
"tbl_df",
"tbl",
"data.frame"
],
"fields": [
"name",
"description",
"type",
"default"
],
"rows": 41,
"table": true,
"tojson": true
},
{
"name": "config_db",
"title": "DuckDB runtime database configuration (config_db)",
"object": "config_db",
"class": [
"list"
],
"fields": [],
"table": true,
"tojson": true
},
{
"name": "config_excel",
"title": "DuckDB Excel read configuration (config_excel)",
"object": "config_excel",
"class": [
"tbl_df",
"tbl",
"data.frame"
],
"fields": [
"Option",
"Type",
"Default",
"Description"
],
"rows": 7,
"table": true,
"tojson": true
},
{
"name": "config_parquet",
"title": "DuckDB Parquet read configuration (config_parquet)",
"object": "config_parquet",
"class": [
"tbl_df",
"tbl",
"data.frame"
],
"fields": [
"Name",
"Description",
"Type",
"Default"
],
"rows": 6,
"table": true,
"tojson": true
}
],
"_help": [
{
"page": "alter_table_schema",
"title": "Move Tables from One Schema to Another",
"concept": [
"db-manage"
],
"topics": [
"alter_table_schema"
]
},
{
"page": "cd",
"title": "Change Active Database and Schema",
"concept": [
"db-meta"
],
"topics": [
"cd"
]
},
{
"page": "config_csv",
"title": "DuckDB CSV read configuration (config_csv)",
"topics": [
"config_csv"
]
},
{
"page": "config_db",
"title": "DuckDB runtime database configuration (config_db)",
"topics": [
"config_db"
]
},
{
"page": "config_excel",
"title": "DuckDB Excel read configuration (config_excel)",
"topics": [
"config_excel"
]
},
{
"page": "config_parquet",
"title": "DuckDB Parquet read configuration (config_parquet)",
"topics": [
"config_parquet"
]
},
{
"page": "configure_md_user_settings",
"title": "Configure a MotherDuck user's settings",
"concept": [
"db-api"
],
"topics": [
"configure_md_user_settings"
]
},
{
"page": "connect_to_motherduck",
"title": "Create connection to motherduck",
"topics": [
"connect_to_motherduck"
]
},
{
"page": "copy_tables_to_new_location",
"title": "Copy Tables to a New Database/Schema",
"concept": [
"db-manage"
],
"topics": [
"copy_tables_to_new_location"
]
},
{
"page": "create_database",
"title": "Create (If Not Exists) and Switch to a Database",
"concept": [
"db-manage"
],
"topics": [
"create_database"
]
},
{
"page": "create_if_not_exists_share",
"title": "Create a MotherDuck database share if it does not exist",
"concept": [
"db-manage"
],
"topics": [
"create_if_not_exists_share"
]
},
{
"page": "create_md_access_token",
"title": "Create a MotherDuck access token",
"concept": [
"db-api"
],
"topics": [
"create_md_access_token"
]
},
{
"page": "create_md_user",
"title": "Create a new MotherDuck user",
"concept": [
"db-api"
],
"topics": [
"create_md_user"
]
},
{
"page": "create_or_replace_share",
"title": "Create or replace a MotherDuck database share",
"concept": [
"db-manage"
],
"topics": [
"create_or_replace_share"
]
},
{
"page": "create_schema",
"title": "Create a Schema in a Database if It Does Not Exist",
"concept": [
"db-manage"
],
"topics": [
"create_schema"
]
},
{
"page": "create_table",
"title": "Create or Append a Table from a Tibble or DBI-Backed Table",
"concept": [
"db-manage"
],
"topics": [
"create_table"
]
},
{
"page": "delete_and_create_schema",
"title": "Drop and Recreate a Schema in a MotherDuck / DuckDB Database",
"concept": [
"db-manage"
],
"topics": [
"delete_and_create_schema"
]
},
{
"page": "delete_database",
"title": "Drop a Database",
"concept": [
"db-manage"
],
"topics": [
"delete_database"
]
},
{
"page": "delete_md_access_token",
"title": "Delete a MotherDuck user's access token",
"concept": [
"db-api"
],
"topics": [
"delete_md_access_token"
]
},
{
"page": "delete_md_user",
"title": "Delete a MotherDuck user",
"concept": [
"db-api"
],
"topics": [
"delete_md_user"
]
},
{
"page": "delete_schema",
"title": "Drop a Schema from a Database",
"concept": [
"db-manage"
],
"topics": [
"delete_schema"
]
},
{
"page": "delete_table",
"title": "Drop a Table",
"concept": [
"db-manage"
],
"topics": [
"delete_table"
]
},
{
"page": "describe_share",
"title": "Describe a MotherDuck share",
"concept": [
"db-manage"
],
"topics": [
"describe_share"
]
},
{
"page": "drop_share",
"title": "Drop a MotherDuck share",
"concept": [
"db-manage"
],
"topics": [
"drop_share"
]
},
{
"page": "install_extensions",
"title": "Install DuckDB/MotherDuck Extensions",
"concept": [
"db-con"
],
"topics": [
"install_extensions"
]
},
{
"page": "launch_ui",
"title": "Launch the DuckDB UI in your browser",
"concept": [
"db-meta"
],
"topics": [
"launch_ui"
]
},
{
"page": "list_all_databases",
"title": "List Databases Visible to the Connection",
"concept": [
"db-list"
],
"topics": [
"list_all_databases"
]
},
{
"page": "list_all_tables",
"title": "List All Tables Visible to the Connection",
"concept": [
"db-list"
],
"topics": [
"list_all_tables"
]
},
{
"page": "list_current_schemas",
"title": "List Schemas in the Current Database",
"concept": [
"db-list"
],
"topics": [
"list_current_schemas"
]
},
{
"page": "list_current_tables",
"title": "List Tables in the Current Database and Schema",
"concept": [
"db-list"
],
"topics": [
"list_current_tables"
]
},
{
"page": "list_extensions",
"title": "List MotherDuck/DuckDB Extensions",
"concept": [
"db-list"
],
"topics": [
"list_extensions"
]
},
{
"page": "list_fns",
"title": "List Database Functions (DuckDB/MotherDuck)",
"concept": [
"db-list"
],
"topics": [
"list_fns"
]
},
{
"page": "list_md_active_accounts",
"title": "List active MotherDuck accounts",
"concept": [
"db-api"
],
"topics": [
"list_md_active_accounts"
]
},
{
"page": "list_md_user_instance",
"title": "List a MotherDuck user's instance settings",
"concept": [
"db-api"
],
"topics": [
"list_md_user_instance"
]
},
{
"page": "list_md_user_tokens",
"title": "List a MotherDuck user's tokens",
"concept": [
"db-api"
],
"topics": [
"list_md_user_tokens"
]
},
{
"page": "list_owned_shares",
"title": "List all shares owned by the current user",
"concept": [
"db-manage"
],
"topics": [
"list_owned_shares"
]
},
{
"page": "list_setting",
"title": "List Database Settings",
"concept": [
"db-list"
],
"topics": [
"list_setting"
]
},
{
"page": "list_shared_with_me_shares",
"title": "List all shares shared with the current user",
"concept": [
"db-manage"
],
"topics": [
"list_shared_with_me_shares"
]
},
{
"page": "list_shares",
"title": "List MotherDuck Shares",
"concept": [
"db-list"
],
"topics": [
"list_shares"
]
},
{
"page": "load_extensions",
"title": "Load and Install DuckDB/MotherDuck Extensions",
"concept": [
"db-con"
],
"topics": [
"load_extensions"
]
},
{
"page": "pwd",
"title": "Print Current MotherDuck Database Context",
"concept": [
"db-meta"
],
"topics": [
"pwd"
]
},
{
"page": "read_csv",
"title": "Read a CSV file into a DuckDB/MotherDuck table",
"concept": [
"db-read"
],
"topics": [
"read_csv"
]
},
{
"page": "read_excel",
"title": "Read an Excel file into a DuckDB/MotherDuck table",
"concept": [
"db-read"
],
"topics": [
"read_excel"
]
},
{
"page": "show_current_user",
"title": "Show current database user",
"concept": [
"db-api"
],
"topics": [
"show_current_user"
]
},
{
"page": "show_information_schema",
"title": "Show Information Schema Schemas",
"topics": [
"show_information_schema"
]
},
{
"page": "show_motherduck_token",
"title": "Show Your MotherDuck Token",
"concept": [
"db-con"
],
"topics": [
"show_motherduck_token"
]
},
{
"page": "summary",
"title": "Summarize a Lazy DBI Table",
"concept": [
"db-meta"
],
"topics": [
"summary",
"summary.tbl_lazy"
]
},
{
"page": "upload_database_to_md",
"title": "Upload a Local Database to MotherDuck",
"concept": [
"db-manage"
],
"topics": [
"upload_database_to_md"
]
},
{
"page": "validate_con",
"title": "Validate connection is DuckDB",
"topics": [
"validate_con"
]
},
{
"page": "validate_database_exists",
"title": "Check if a Database Exists",
"topics": [
"validate_database_exists"
]
},
{
"page": "validate_database_schema_exists",
"title": "Check if a Schema Exists in a Database",
"topics": [
"validate_database_schema_exists"
]
},
{
"page": "validate_extension_install_status",
"title": "Validate Installed MotherDuck/DuckDB Extensions",
"concept": [
"db-con"
],
"topics": [
"validate_extension_install_status"
]
},
{
"page": "validate_extension_load_status",
"title": "Validate Loaded MotherDuck/DuckDB Extensions",
"concept": [
"db-con"
],
"topics": [
"validate_extension_load_status"
]
},
{
"page": "validate_md_connection_status",
"title": "Validate Mother Duck Connection Status",
"topics": [
"validate_md_connection_status"
]
}
],
"_readme": "https://github.com/usrbinr/motherduck/raw/HEAD/README.md",
"_rundeps": [
"askpass",
"assertthat",
"blob",
"cli",
"cpp11",
"curl",
"DBI",
"dbplyr",
"dplyr",
"duckdb",
"generics",
"glue",
"hms",
"httr2",
"janitor",
"lifecycle",
"lubridate",
"magrittr",
"openssl",
"pillar",
"pkgconfig",
"purrr",
"R6",
"rappdirs",
"rlang",
"snakecase",
"stringi",
"stringr",
"sys",
"tibble",
"tidyr",
"tidyselect",
"timechange",
"utf8",
"vctrs",
"withr"
],
"_score": 3.6989700043360187,
"_indexed": true,
"_nocasepkg": "motherduck",
"_universes": [
"usrbinr",
"codeberg-usrbinr"
],
"_binaries": [
{
"r": "4.5.3",
"os": "win",
"version": "0.2.3",
"date": "2026-05-01T05:20:49.000Z",
"commit": "119b592b75070896ff5de4448d3c0f3c06e2abfc",
"fileid": "d615894f0801149f53a078bcaaf6825fe0c117ff63e93a972c7f5a39df9b081f",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/usrbinr/actions/runs/25203349423"
},
{
"r": "4.7.0",
"os": "linux",
"version": "0.2.3",
"date": "2026-05-31T10:39:40.000Z",
"distro": "noble",
"commit": "119b592b75070896ff5de4448d3c0f3c06e2abfc",
"fileid": "30f274af90227a7e685e1686276da55fafb094ebedabb9c95480af86e9a20e18",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26710232746"
},
{
"r": "4.6.0",
"os": "linux",
"version": "0.2.3",
"date": "2026-05-31T10:39:40.000Z",
"distro": "noble",
"commit": "119b592b75070896ff5de4448d3c0f3c06e2abfc",
"fileid": "aea8b4e820cdf49089d0d95da9cbaacc8cf1fef0f82ded26876c6fba7f1c592f",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26710232746"
},
{
"r": "4.5.3",
"os": "mac",
"version": "0.2.3",
"date": "2026-05-31T10:39:26.000Z",
"commit": "119b592b75070896ff5de4448d3c0f3c06e2abfc",
"fileid": "e59c82039bffa1cf21d3fcdefc66219d19831999c5e95d5ff2c6f56ba72186fa",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26710232746"
},
{
"r": "4.6.0",
"os": "mac",
"version": "0.2.3",
"date": "2026-05-31T10:40:36.000Z",
"commit": "119b592b75070896ff5de4448d3c0f3c06e2abfc",
"fileid": "2d9999d418cda503dce2c6ed6a9caaa95b46123efd65e756599f622877f09dc0",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26710232746"
},
{
"r": "4.6.0",
"os": "wasm",
"version": "0.2.3",
"date": "2026-05-31T10:39:33.000Z",
"commit": "119b592b75070896ff5de4448d3c0f3c06e2abfc",
"fileid": "b849be7ba9123e0db2b05551cc5c67e73fb4af26dd92b73b089785f8e6dc8332",
"status": "success",
"buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26710232746"
},
{
"r": "4.7.0",
"os": "win",
"version": "0.2.3",
"date": "2026-05-31T10:39:15.000Z",
"commit": "119b592b75070896ff5de4448d3c0f3c06e2abfc",
"fileid": "b09f1702a02bf86f0f052f470ec19f4792897f2cff9f2598ee4e1a499859394c",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26710232746"
},
{
"r": "4.6.0",
"os": "win",
"version": "0.2.3",
"date": "2026-05-31T10:38:44.000Z",
"commit": "119b592b75070896ff5de4448d3c0f3c06e2abfc",
"fileid": "3106a17bfbbf08d0093c7725b2f3f79ec71a960a7d370f70f31d43bcb93c581e",
"status": "success",
"check": "OK",
"buildurl": "https://github.com/r-universe/usrbinr/actions/runs/26710232746"
}
]
}