{ "_id": "6ada3307c9cc1e56bbac4c68", "Package": "querychat", "Title": "Filter and Query Data Frames in 'shiny' Using an LLM Chat\nInterface", "Version": "0.4.1", "Authors@R": "c(\nperson(\"Garrick\", \"Aden-Buie\", , \"garrick@posit.co\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-7111-0077\")),\nperson(\"Joe\", \"Cheng\", , \"joe@posit.co\", role = c(\"aut\", \"ccp\")),\nperson(\"Carson\", \"Sievert\", , \"carson@posit.co\", role = \"aut\",\ncomment = c(ORCID = \"0000-0002-4958-2844\")),\nperson(\"Posit Software, PBC\", role = c(\"cph\", \"fnd\"))\n)", "Description": "Adds an LLM-powered chatbot to your 'shiny' app, that can\nturn your users' natural language questions into 'SQL' queries\nthat run against your data, and return the result as a reactive\ndata frame. Use it to drive reactive calculations,\nvisualizations, downloads, and more.", "License": "MIT + file LICENSE", "URL": "https://posit-dev.github.io/querychat/r/,\nhttps://posit-dev.github.io/querychat/,\nhttps://github.com/posit-dev/querychat", "BugReports": "https://github.com/posit-dev/querychat/issues", "VignetteBuilder": "knitr", "Config/roxygen2/version": "8.1.0", "Config/testthat/edition": "3", "Config/testthat/parallel": "true", "Encoding": "UTF-8", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-22 15:31:33 UTC", "User": "root" }, "Author": "Garrick Aden-Buie [aut, cre] (ORCID:\n), Joe Cheng [aut, ccp],\nCarson Sievert [aut] (ORCID:\n), Posit Software, PBC\n[cph, fnd]", "Maintainer": "Garrick Aden-Buie ", "Config/pak/sysreqs": "cmake make libuv1-dev libssl-dev zlib1g-dev", "Repository": "https://cranhaven.r-universe.dev", "Date/Publication": "2026-10-22 02:02:00 UTC", "RemoteUrl": "https://github.com/cranhaven/cranhaven.r-universe.dev", "RemoteRef": "package/querychat", "RemoteSha": "8da5be1d2bad6dc54ae5ed301707cf439cf3f6cc", "RemoteSubdir": "querychat", "_user": "cranhaven", "_type": "src", "_file": "querychat_0.4.1.tar.gz", "_fileid": "https://r2.ropensci.org/831ea34afb7f401a6f80de500d6fded78c3ac2abb72d085b92f5c096cace8d4f", "_filesize": 2825092, "_sha256": "831ea34afb7f401a6f80de500d6fded78c3ac2abb72d085b92f5c096cace8d4f", "_expires": "2027-01-30T16:00:03.000Z", "_created": "2026-10-22T15:31:33.000Z", "_published": "2026-10-22T19:21:25.209Z", "_upstream": "https://github.com/cranhaven/cranhaven.r-universe.dev", "_status": "success", "_maintainer": { "name": "Garrick Aden-Buie", "email": "garrick@posit.co", "login": "gadenbuie", "mastodon": "@grrrck@fosstodon.org", "bluesky": "@grrrck.xyz", "description": "Software engineer for Shiny at @posit-pbc", "uuid": 5420529, "orcid": "0000-0002-7111-0077" }, "_jobs": [ { "job": 119918352960, "time": 191, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12438416312" }, { "job": 119918352366, "time": 234, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12437253200" }, { "job": 119918352571, "time": 1654, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "12439831257" }, { "job": 119918352329, "time": 163, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "12437567502" }, { "job": 119915546014, "time": 300, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12437442030" }, { "job": 119918352122, "time": 117, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "12437623658" }, { "job": 119918352524, "time": 146, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12438066642" }, { "job": 119918352471, "time": 164, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "12437936978" }, { "job": 119918352103, "time": 160, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12436804652" } ], "_buildurl": "https://github.com/r-universe/cranhaven/actions/runs/39804910978", "_commit": { "id": "8da5be1d2bad6dc54ae5ed301707cf439cf3f6cc", "author": "GitHub Action ", "committer": "GitHub Action ", "message": "Add querychat to CRANhaven, because archived on 2026-10-22 02:02:00 +0000\n", "time": 1792634520 }, "_distro": "resolute", "_host": "GitHub-Actions", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "bsicons", "role": "Imports" }, { "package": "bslib", "version": ">= 0.11.0", "role": "Imports" }, { "package": "cli", "role": "Imports" }, { "package": "coro", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "ellmer", "version": ">= 0.5.0", "role": "Imports" }, { "package": "htmltools", "role": "Imports" }, { "package": "jsonlite", "role": "Imports" }, { "package": "lifecycle", "role": "Imports" }, { "package": "promises", "role": "Imports" }, { "package": "R6", "role": "Imports" }, { "package": "rlang", "version": ">= 1.1.0", "role": "Imports" }, { "package": "S7", "role": "Imports" }, { "package": "shiny", "version": ">= 1.14.0", "role": "Imports" }, { "package": "shinychat", "version": ">= 0.5.0", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "whisker", "role": "Imports" }, { "package": "yaml", "role": "Imports" }, { "package": "zip", "role": "Imports" }, { "package": "dbplyr", "role": "Suggests" }, { "package": "dplyr", "role": "Suggests" }, { "package": "DT", "role": "Suggests" }, { "package": "duckdb", "role": "Suggests" }, { "package": "ggsql", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "later", "role": "Suggests" }, { "package": "nanoparquet", "role": "Suggests" }, { "package": "palmerpenguins", "role": "Suggests" }, { "package": "pins", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "rsvg", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "V8", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "cranhaven", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-43", "n": 1 } ], "_tags": [], "_topics": [ "archived", "packages", "r-universe" ], "_stars": 5, "_contributors": [ { "user": "henrikbengtsson", "count": 183, "uuid": 1616850 } ], "_userbio": { "uuid": 161993010, "type": "organization", "name": "cranhaven", "followers": 3, "description": "CRANhaven - Repository for Recently Archived CRAN Packages" }, "_downloads": { "count": 580, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/querychat" }, "_devurl": "https://github.com/posit-dev/querychat", "_pkgdown": "https://posit-dev.github.io/querychat/r/", "_searchresults": 138, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/querychat.html", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_homeurl": "https://github.com/posit-dev/querychat", "_realowner": "posit-dev", "_cranurl": false, "_releases": [ { "version": "0.2.0", "date": "2026-01-12" }, { "version": "0.3.0", "date": "2026-06-01" }, { "version": "0.4.0", "date": "2026-09-14" }, { "version": "0.4.1", "date": "2026-09-30" } ], "_exports": [ "DataFrameSource", "DataSource", "DBISource", "PinSource", "querychat", "QueryChat", "querychat_app", "querychat_data_source", "querychat_greeting", "querychat_init", "querychat_server", "querychat_sidebar", "querychat_ui", "TableAccessor", "TblSqlSource" ], "_help": [ { "page": "DataFrameSource", "title": "Data Frame Source", "topics": [ "DataFrameSource" ] }, { "page": "DataSource", "title": "Data Source Base Class", "topics": [ "DataSource" ] }, { "page": "DBISource", "title": "DBI Source", "topics": [ "DBISource" ] }, { "page": "PinSource", "title": "Pin Source", "topics": [ "PinSource" ] }, { "page": "querychat-convenience", "title": "QueryChat convenience functions", "topics": [ "querychat", "querychat_app" ] }, { "page": "QueryChat", "title": "QueryChat: Interactive Data Querying with Natural Language", "topics": [ "QueryChat" ] }, { "page": "read_data_dict", "title": "Read a Data Dictionary from YAML", "topics": [ "read_data_dict" ] }, { "page": "TblSqlSource", "title": "Data Source: SQL Tibble", "topics": [ "TblSqlSource" ] } ], "_pkglogo": "https://github.com/cranhaven/cranhaven.r-universe.dev/raw/package/querychat/querychat/man/figures/logo.png", "_readme": "https://github.com/cranhaven/cranhaven.r-universe.dev/raw/package/querychat/querychat/README.md", "_rundeps": [ "askpass", "base64enc", "bsicons", "bslib", "cachem", "cli", "commonmark", "coro", "curl", "DBI", "digest", "ellmer", "fastmap", "fontawesome", "fs", "glue", "htmltools", "httpuv", "httr2", "jquerylib", "jsonlite", "later", "lifecycle", "magrittr", "memoise", "mime", "openssl", "otel", "pillar", "pkgconfig", "promises", "R6", "rappdirs", "Rcpp", "rlang", "S7", "sass", "shiny", "shinychat", "sourcetools", "sys", "tibble", "utf8", "vctrs", "whisker", "withr", "xtable", "yaml", "zip" ], "_vignettes": [ { "source": "build.Rmd", "filename": "build.html", "title": "Build an App", "engine": "knitr::rmarkdown", "headings": [ "Starter template", "Chat-first page", "Deferred data sources", "Reactives", "Filtered data", "SQL query", "Title", "Custom UI", "Data views", "Programmatic updates", "Multiple tables", "Registering tables", "Per-table reactive access", "Tracking the active table", "Data dictionary", "Separate chat interfaces", "See also" ], "created": "2026-10-22 02:02:00", "modified": "2026-10-22 02:02:00", "commits": 1 }, { "source": "data-sources.Rmd", "filename": "data-sources.html", "title": "Data Sources", "engine": "knitr::rmarkdown", "headings": [ "Data frames", "Database connections", "DuckDB", "SQLite", "PostgreSQL", "MySQL", "Creating a database from a data frame", "Pins", "Lazy queries with pins", "Custom sources" ], "created": "2026-10-22 02:02:00", "modified": "2026-10-22 02:02:00", "commits": 1 }, { "source": "greet.Rmd", "filename": "greet.html", "title": "Greet Users", "engine": "knitr::rmarkdown", "headings": [ "Provide a greeting", "Generate a greeting", "Greetings with multiple tables" ], "created": "2026-10-22 02:02:00", "modified": "2026-10-22 02:02:00", "commits": 1 }, { "source": "models.Rmd", "filename": "models.html", "title": "Models", "engine": "knitr::rmarkdown", "headings": [ "Specify a model", "Credentials", "Recommended models" ], "created": "2026-10-22 02:02:00", "modified": "2026-10-22 02:02:00", "commits": 1 }, { "source": "context.Rmd", "filename": "context.html", "title": "Provide Context", "engine": "knitr::rmarkdown", "headings": [ "Data dictionary", "Format", "Tables", "Relationships", "Glossary", "Data description", "Additional instructions", "Default prompt", "Custom template" ], "created": "2026-10-22 02:02:00", "modified": "2026-10-22 02:02:00", "commits": 1 }, { "source": "tools.Rmd", "filename": "tools.html", "title": "Tools", "engine": "knitr::rmarkdown", "headings": [ "Schema retrieval", "Data updating", "Data analysis", "Data visualization", "View the source" ], "created": "2026-10-22 02:02:00", "modified": "2026-10-22 02:02:00", "commits": 1 }, { "source": "visualize.Rmd", "filename": "visualize.html", "title": "Visualizations", "engine": "knitr::rmarkdown", "headings": [ "Getting started", "Choosing tools", "Custom apps", "What you can ask for", "Chart controls", "How it works", "See also" ], "created": "2026-10-22 02:02:00", "modified": "2026-10-22 02:02:00", "commits": 1 } ], "_score": 5.382917135087531, "_indexed": false, "_nocasepkg": "querychat", "_universes": [ "cranhaven" ], "_indexurl": "https://posit-dev.r-universe.dev/querychat", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.4.1", "date": "2026-10-22T15:34:13.000Z", "distro": "resolute", "commit": "8da5be1d2bad6dc54ae5ed301707cf439cf3f6cc", "fileid": "https://r2.ropensci.org/d5f1339b65c92f78daf544dfa7f7ee27ce3436fa6034d0da3261ab9d5465b7a8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cranhaven/actions/runs/39804910978" }, { "r": "4.6.1", "os": "linux", "version": "0.4.1", "date": "2026-10-22T15:34:51.000Z", "distro": "resolute", "commit": "8da5be1d2bad6dc54ae5ed301707cf439cf3f6cc", "fileid": "https://r2.ropensci.org/012ddddc0eb9903496bdfae0ff085e069ee4df850305b8ba0702edcb6c9245de", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cranhaven/actions/runs/39804910978" }, { "r": "4.5.3", "os": "mac", "version": "0.4.1", "date": "2026-10-22T15:58:06.000Z", "commit": "8da5be1d2bad6dc54ae5ed301707cf439cf3f6cc", "fileid": "https://r2.ropensci.org/cc2ad3cc45211483e78be1c41db6acd2f659833fb42f0d7838fd1b2e5c69fb79", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cranhaven/actions/runs/39804910978" }, { "r": "4.6.1", "os": "mac", "version": "0.4.1", "date": "2026-10-22T15:33:39.000Z", "commit": "8da5be1d2bad6dc54ae5ed301707cf439cf3f6cc", "fileid": "https://r2.ropensci.org/767a8f5da650d678e3fcfbb6322437504c1eb9fc5b8dec58ea8a50eec77eea17", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cranhaven/actions/runs/39804910978" }, { "r": "4.6.0", "os": "wasm", "version": "0.4.1", "date": "2026-10-22T15:34:01.000Z", "commit": "8da5be1d2bad6dc54ae5ed301707cf439cf3f6cc", "fileid": "https://r2.ropensci.org/21e447326ca8e7af5e20d2002d4d56f38fe8502b2543495fd09375c370eca516", "status": "success", "buildurl": "https://github.com/r-universe/cranhaven/actions/runs/39804910978" }, { "r": "4.7.0", "os": "win", "version": "0.4.1", "date": "2026-10-22T15:33:09.000Z", "commit": "8da5be1d2bad6dc54ae5ed301707cf439cf3f6cc", "fileid": "https://r2.ropensci.org/db73a67fb77817bf5045e4062273117459a9c4641be471cd757817d89292f30c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cranhaven/actions/runs/39804910978" }, { "r": "4.5.3", "os": "win", "version": "0.4.1", "date": "2026-10-22T15:33:06.000Z", "commit": "8da5be1d2bad6dc54ae5ed301707cf439cf3f6cc", "fileid": "https://r2.ropensci.org/d7b80e31f6ddaf3b883c64fbe8442efd786f5ac7ccff31a963d9f71327536341", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cranhaven/actions/runs/39804910978" }, { "r": "4.6.1", "os": "win", "version": "0.4.1", "date": "2026-10-22T15:33:06.000Z", "commit": "8da5be1d2bad6dc54ae5ed301707cf439cf3f6cc", "fileid": "https://r2.ropensci.org/a15ce4a86c6bb116589c3cb9ab7ca8b108be6ce9c4cd73f803f799e9427249a8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cranhaven/actions/runs/39804910978" } ] }