querychat: Filter and Query Data Frames in 'shiny' Using an LLM Chat Interface

Adds an LLM-powered chatbot to your 'shiny' app, that can turn your users' natural language questions into SQL queries that run against your data, and return the result as a reactive data frame. Use it to drive reactive calculations, visualizations, downloads, and more.

Version: 0.2.0
Depends: R (≥ 4.1.0)
Imports: bslib, cli, DBI, ellmer (≥ 0.3.0), htmltools, lifecycle, promises, R6, rlang (≥ 1.1.0), S7, shiny, shinychat (≥ 0.3.0), utils, whisker
Suggests: bsicons, dbplyr, dplyr, DT, duckdb, knitr, palmerpenguins, rmarkdown, RSQLite, shinytest2, testthat (≥ 3.0.0), withr
Published: 2026-01-12
DOI: 10.32614/CRAN.package.querychat (may not be active yet)
Author: Garrick Aden-Buie ORCID iD [aut, cre], Joe Cheng [aut, ccp], Carson Sievert ORCID iD [aut], Posit Software, PBC [cph, fnd]
Maintainer: Garrick Aden-Buie <garrick at posit.co>
BugReports: https://github.com/posit-dev/querychat/issues
License: MIT + file LICENSE
URL: https://posit-dev.github.io/querychat/r/, https://posit-dev.github.io/querychat/, https://github.com/posit-dev/querychat
NeedsCompilation: no
Materials: README, NEWS
CRAN checks: querychat results

Documentation:

Reference manual: querychat.html , querychat.pdf
Vignettes: Build an App (source, R code)
Provide Context (source, R code)
Data Sources (source, R code)
Greet Users (source, R code)
Models (source, R code)
Tools (source, R code)

Downloads:

Package source: querychat_0.2.0.tar.gz
Windows binaries: r-devel: not available, r-release: not available, r-oldrel: not available
macOS binaries: r-release (arm64): querychat_0.2.0.tgz, r-oldrel (arm64): querychat_0.2.0.tgz, r-release (x86_64): querychat_0.2.0.tgz, r-oldrel (x86_64): querychat_0.2.0.tgz

Linking:

Please use the canonical form https://CRAN.R-project.org/package=querychat to link to this page.