querychat

0.3.0

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

0packages depend

3.2Kdownloads / year

77.1%test coverage

12/13checks pass

Overview

About

Maintained by Garrick Aden-BuieFirst published 2026-01-122 releasesCRAN page ↗GitHub ↗

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.

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("querychat", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("posit-dev/querychat")

Development version from posit-dev/querychat. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-querychat

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-querychat

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-querychat

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed).

Health

CRAN checks

1NOTE12OK

Failing flavors

NOTE r-devel-linux-x86_64-debian-gcc

Slowest check: 3.1 min · r-devel-linux-x86_64-fedora-clang

Code health

Yes

Tests · ratio 1.08

77.1%

Coverage · measured lines

100%

Documentation · exports

Dependencies · direct

Check history

NOTE2026-08-01
12 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
OK2026-05-24
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-05-17
12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
OK2026-05-15
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-05-13
12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE

Show 2 earlier snapshots

OK2026-04-25
12 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-03-10
13 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE

Documentation

READMEYes · 806 wordsVignettesYes · dynamicpkgdown siteNoNEWSYes · 100% structuredCode of conductNoContributing guideNo

Examples that run: 100%
Documented parameters: 100%
Return-value docs: 29%
References docs: 0%

Downloads

3.2K

CRAN downloads in the past year

Rank #5,893 · ~9/day · ~263/mo

Releases R versions

Daily download trend is not available in this view yet.

34430 days

1.5K90 days

3.2K1 year

Compare downloads with other packages →

Also on146 r2u3 autocran

Repository

GitHub ↗ posit-dev/querychat

209Stars

29Forks

19Open issues

8Open PRs

12Releases

190Commits

12Contributors

License MIT · 190 commits · Last activity 2026-07-10 · +1% stars, 30d

Stars over time

2026-07-14 · 2072026-07-22 · 209

Repository practices

Upstream repositoryBeta

3 development-tooling and community-health practices detected across 3 families in the upstream repository

Checks run against github.com/posit-dev/querychat on 2026-08-02.

Continuous integration (1)

GitHub Actions

Reproducibility and dev environment (1)

Makefile

Lint, format, editor (1)

VS Code

How this is detected·Detection ruleset v1 (2026-07-18)

Development tooling

AI-assisted toolingBeta

Uses AI-assisted development tooling (declared in repo)

Earliest detected marker: cursor on 2025-05-29

cursorclaude

Most recent: claude on 2025-10-15

Evidence

cursor: on 2025-05-29 · evidence D
claude: on 2025-10-15 · evidence B, D

How this is detected·Detection ruleset v2 (updated 2026-07-29)

Dependencies

Declared dependencies

28 external dependencies (excludes base and recommended)

Depends (1)

R >= 4.1.0

Imports (15)

bsicons bslib cli DBI ellmer htmltools lifecycle promises R6 rlang S7 shiny shinychatutilswhisker

LinkingTo (0)

none

Suggests (14)

dbplyr dplyr DT duckdb ggsql knitr palmerpenguins rmarkdown RSQLite rsvg shinytest2 testthat V8 withr

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

Code & Tests

People & History

People (4)

Maintainer (1)

Garrick Aden-Buie

Author, Maintainer

Authors (3)

Author, Maintainer

Author, ccp

Author

Funders (1)

Package Timeline

2 releases. Pick two to compare their code metrics. R releases are shown for context.

0.3.0Latest
2026-06-02 · current release · diff ↗
R
R 4.6.0 released · 2026-04-24
0.2.0
2026-03-10
R
R 4.5.0 released · 2025-04-11

Package metadata

First published: 2026-01-12
Total releases: 2 / 1 yrs
License: MIT + file LICENSE OSI
Minimum R: ≥ 4.1.0
Download size: 2.3 MB
Installed size: not tracked yet
With dependencies: not tracked yet

Report a problem with this page →