querychat
Filter and Query Data Frames in 'shiny' Using an LLM Chat Interface
Description
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.
Downloads
739
Last 30 days
4270th
1.3K
Last 90 days
2.7K
Last year
Trend: +171.7% (30d vs prior 30d)
85
Last 30 days
102
Last 90 days
121
Last year
Trend: +466.7% (30d vs prior 30d)
6
Last 7 days
23
Last 30 days
0
All-time
autoCRAN-only: this name is served only by autoCRAN, so the count is exact.
CRAN Check Status
Show all 13 flavors
| Flavor | Status |
|---|---|
| r-devel-linux-x86_64-debian-clang | OK |
| r-devel-linux-x86_64-debian-gcc | OK |
| r-devel-linux-x86_64-fedora-clang | OK |
| r-devel-linux-x86_64-fedora-gcc | OK |
| r-devel-windows-x86_64 | OK |
| r-oldrel-macos-arm64 | OK |
| r-oldrel-macos-x86_64 | OK |
| r-oldrel-windows-x86_64 | OK |
| r-patched-linux-x86_64 | OK |
| r-release-linux-x86_64 | OK |
| r-release-macos-arm64 | OK |
| r-release-macos-x86_64 | OK |
| r-release-windows-x86_64 | OK |
Check History
OK 13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE May 24, 2026
ERROR 12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE May 17, 2026
tests
Running ‘testthat.R’ [30s/20s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
> # This file is part of the standard setup for testthat.
> # It is recommended that you do not modify it.
> #
> # Where should you do additional
...[truncated]...
(data, table_name, engine = engine) at ./helper-fixtures.R:88:3
3. └─querychat (local) initialize(...)
4. └─rlang::check_installed("duckdb")
[ FAIL 43 | WARN 0 | SKIP 45 | PASS 246 ]
Error:
! Test failures.
Execution halted
OK 13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE May 15, 2026
ERROR 12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE May 13, 2026
tests
Running ‘testthat.R’ [21s/13s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
> # This file is part of the standard setup for testthat.
> # It is recommended that you do not modify it.
> #
> # Where should you do additional
...[truncated]...
(data, table_name, engine = engine) at ./helper-fixtures.R:88:3
3. └─querychat (local) initialize(...)
4. └─rlang::check_installed("duckdb")
[ FAIL 43 | WARN 0 | SKIP 45 | PASS 246 ]
Error:
! Test failures.
Execution halted
OK 12 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Apr 25, 2026
ERROR 13 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Mar 10, 2026
re-building of vignette outputs
Error(s) in re-building vignettes: --- re-building 'build.Rmd' using rmarkdown --- finished re-building 'build.Rmd' --- re-building 'context.Rmd' using rmarkdown --- finished re-building 'context.Rmd' --- re-building 'data-sources.Rmd' using rmarkd ...[truncated]... ssing vignette 'tools.Rmd' failed with diagnostics: pandoc document conversion failed with error 99 --- failed re-building 'tools.Rmd' SUMMARY: processing the following file failed: 'tools.Rmd' Error: Vignette re-building failed. Execution halted
Dependency Network
Version History
2 trackedR Observatory began tracking this package on Mar 10, 2026; it first appeared on CRAN Jan 12, 2026. Releases before tracking aren’t shown.