{ "_id": "6a5174649b92047c28d50914", "Package": "querychat", "Title": "Filter and Query Data Frames in 'shiny' Using an LLM Chat\nInterface", "Version": "0.3.0.9000", "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", "Remotes": [ "posit-dev/shinychat/pkg-r" ], "Config/roxygen2/version": "8.0.0", "Config/testthat/edition": "3", "Config/testthat/parallel": "true", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "Config/pak/sysreqs": "cmake make libuv1-dev libssl-dev zlib1g-dev", "Repository": "https://posit-dev.r-universe.dev", "Date/Publication": "2026-07-10 21:17:33 UTC", "RemoteUrl": "https://github.com/posit-dev/querychat", "RemoteRef": "HEAD", "RemoteSha": "09dd6fc3e0598ce69d3afaf77dfe0c21d9663f5e", "RemoteSubdir": "pkg-r", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-10 21:48:02 UTC", "User": "root" }, "Author": "Garrick Aden-Buie [aut, cre] (ORCID:\n),\nJoe Cheng [aut, ccp],\nCarson Sievert [aut] (ORCID: ),\nPosit Software, PBC [cph, fnd]", "Maintainer": "Garrick Aden-Buie ", "_user": "posit-dev", "_type": "src", "_file": "querychat_0.3.0.9000.tar.gz", "_fileid": "https://r2.ropensci.org/c32dc426430dc06c70898fb691ace84e9143b7ac9b2b1b50e5b355bba0ef2a73", "_filesize": 2879175, "_sha256": "c32dc426430dc06c70898fb691ace84e9143b7ac9b2b1b50e5b355bba0ef2a73", "_expires": "2026-10-18T22:38:25.000Z", "_created": "2026-07-10T21:48:02.000Z", "_published": "2026-07-10T22:38:27.985Z", "_jobs": [ { "job": 86471150356, "time": 201, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "8240301569" }, { "job": 86471150348, "time": 184, "config": "linux-release-x86_64", "r": "4.6.1", "check": "NOTE", "artifact": "8240296868" }, { "job": 86471150374, "time": 133, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "8240281200" }, { "job": 86471150345, "time": 106, "config": "macos-release-arm64", "r": "4.6.1", "check": "NOTE", "artifact": "8240273428" }, { "job": 86470347087, "time": 306, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8240240743" }, { "job": 86471150337, "time": 143, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8240283760" }, { "job": 86471150362, "time": 2625, "config": "windows-devel", "r": "4.7.0", "check": "NOTE", "artifact": "8240984110" }, { "job": 86471150364, "time": 2965, "config": "windows-oldrel", "r": "4.5.3", "check": "NOTE", "artifact": "8241079329" }, { "job": 86471150368, "time": 2378, "config": "windows-release", "r": "4.6.1", "check": "NOTE", "artifact": "8240912881" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/posit-dev/actions/runs/29125540406", "_status": "success", "_upstream": "https://github.com/posit-dev/querychat", "_commit": { "id": "09dd6fc3e0598ce69d3afaf77dfe0c21d9663f5e", "author": "Carson Sievert ", "committer": "GitHub ", "message": "fix(pkg-py): pin pyarrow<25.0.0 to avoid a mimalloc segfault behind Streamlit e2e flakiness (#268)\n\n* fix(pkg-py): give each Streamlit e2e test its own server process\n\nThe Streamlit e2e fixtures (app_04_streamlit, app_09_streamlit_custom) were\nmodule-scoped: one Streamlit subprocess served every test in the class,\nwith each test doing a fresh page.goto() against it. Observed in CI and\nreproduced locally (including on a commit that predates any related\napplication changes, via an isolated git worktree): after the first test's\nbrowser session completed successfully, the server stopped re-running its\nscript for any later session -- the static page shell still loaded, but no\nreactive content (e.g. the chat greeting) ever streamed in, with no error\nlogged on either side. The condition was permanent for that server process;\na fresh browser context/page didn't recover it, only a new server did\n(confirmed by instrumenting the render path: it ran exactly once across the\nwhole affected test class, including pytest-rerunfailures' automatic\nreruns).\n\nOther e2e fixtures in this file (Shiny, Gradio, Dash) use the same\nmodule-scoped-server / fresh-page-per-test pattern without hitting this --\nmany sequential sessions against one server work fine for those apps in\nthe same CI run, including the *other* Streamlit example\n(09-streamlit-custom-app.py, which doesn't wait on the chat message in its\nsetup and so never surfaced this). So this isn't a blanket \"Streamlit can't\nhandle repeat sessions\" issue; the actual trigger wasn't pinned down.\n\nHypothetical fix: give each Streamlit test its own server process\n(function-scoped fixture) instead of sharing one across a class, trading\nsome subprocess-startup overhead for not accumulating whatever state causes\nthis. Validated against the reported failure locally -- it resolves the\nhang. Not fully validated: with fresh servers per test, a different set of\ntests (the ones that submit a chat message and wait on a real LLM response)\nshowed new fla", "time": 1783718253 }, "_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" }, "_distro": "resolute", "_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": "DBI", "role": "Imports" }, { "package": "ellmer", "version": ">= 0.4.1", "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", "role": "Imports" }, { "package": "shinychat", "version": "> 0.4.0", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "whisker", "role": "Imports" }, { "package": "yaml", "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": "nanoparquet", "role": "Suggests" }, { "package": "palmerpenguins", "role": "Suggests" }, { "package": "pins", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "rsvg", "role": "Suggests" }, { "package": "shinytest2", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "V8", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "posit-dev", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-31", "n": 1 }, { "week": "2025-32", "n": 1 }, { "week": "2025-33", "n": 1 }, { "week": "2025-34", "n": 8 }, { "week": "2025-36", "n": 12 }, { "week": "2025-37", "n": 2 }, { "week": "2025-38", "n": 3 }, { "week": "2025-42", "n": 6 }, { "week": "2025-46", "n": 3 }, { "week": "2025-47", "n": 2 }, { "week": "2025-48", "n": 7 }, { "week": "2025-49", "n": 17 }, { "week": "2025-50", "n": 13 }, { "week": "2025-51", "n": 3 }, { "week": "2025-52", "n": 6 }, { "week": "2026-02", "n": 4 }, { "week": "2026-03", "n": 11 }, { "week": "2026-04", "n": 2 }, { "week": "2026-05", "n": 2 }, { "week": "2026-07", "n": 2 }, { "week": "2026-10", "n": 1 }, { "week": "2026-12", "n": 2 }, { "week": "2026-14", "n": 1 }, { "week": "2026-15", "n": 1 }, { "week": "2026-16", "n": 3 }, { "week": "2026-18", "n": 7 }, { "week": "2026-19", "n": 4 }, { "week": "2026-20", "n": 2 }, { "week": "2026-21", "n": 4 }, { "week": "2026-22", "n": 6 }, { "week": "2026-23", "n": 2 }, { "week": "2026-24", "n": 2 }, { "week": "2026-25", "n": 4 }, { "week": "2026-26", "n": 10 }, { "week": "2026-28", "n": 2 } ], "_tags": [ { "name": "py/v0.2.0", "date": "2025-09-02" }, { "name": "py/v0.2.1", "date": "2025-09-04" }, { "name": "py/v0.2.2", "date": "2025-09-04" }, { "name": "py/v0.3.0", "date": "2025-12-10" }, { "name": "r/v0.2.0", "date": "2026-01-12" }, { "name": "py/v0.4.0", "date": "2026-01-14" }, { "name": "py/v0.5.0", "date": "2026-01-16" }, { "name": "py/v0.5.1", "date": "2026-01-23" }, { "name": "py/v0.6.0", "date": "2026-05-06" }, { "name": "py/v0.6.1", "date": "2026-05-27" }, { "name": "r/v0.3.0", "date": "2026-06-01" }, { "name": "py/v0.7.0", "date": "2026-07-10" } ], "_stars": 206, "_contributors": [ { "user": "cpsievert", "count": 89, "uuid": 1365941 }, { "user": "gadenbuie", "count": 65, "uuid": 5420529 }, { "user": "jcheng5", "count": 18, "uuid": 129551 }, { "user": "schloerke", "count": 5, "uuid": 93231 }, { "user": "chendaniely", "count": 5, "uuid": 5782147 }, { "user": "copilot", "count": 2, "uuid": 198982749 }, { "user": "elnelson575", "count": 1, "uuid": 16469084 }, { "user": "howardbaik", "count": 1, "uuid": 50791792 }, { "user": "thisisnic", "count": 1, "uuid": 13715823 }, { "user": "npelikan", "count": 1, "uuid": 25183744 }, { "user": "oacar", "count": 1, "uuid": 13300870 }, { "user": "songfeil", "count": 1, "uuid": 26142971 } ], "_userbio": { "uuid": 107264312, "type": "organization", "name": "posit-dev", "followers": 987 }, "_downloads": { "count": 696, "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": 104, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/querychat.html", "extra/readme.html", "extra/readme.md", "LICENSE", "manual.pdf" ], "_homeurl": "https://github.com/posit-dev/querychat", "_realowner": "posit-dev", "_cranurl": true, "_releases": [ { "version": "0.2.0", "date": "2026-01-12" }, { "version": "0.3.0", "date": "2026-06-01" } ], "_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/posit-dev/querychat/raw/HEAD/pkg-r/man/figures/logo.png", "_readme": "https://github.com/posit-dev/querychat/raw/HEAD/pkg-r/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" ], "_vignettes": [ { "source": "build.Rmd", "filename": "build.html", "title": "Build an App", "engine": "knitr::rmarkdown", "headings": [ "Starter template", "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": "2025-12-22 14:56:13", "modified": "2026-06-23 15:10:03", "commits": 5 }, { "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": "2025-12-22 14:56:13", "modified": "2026-06-12 17:25:38", "commits": 2 }, { "source": "greet.Rmd", "filename": "greet.html", "title": "Greet Users", "engine": "knitr::rmarkdown", "headings": [ "Provide a greeting", "Generate a greeting", "Greetings with multiple tables" ], "created": "2025-12-22 14:56:13", "modified": "2026-06-26 13:32:28", "commits": 3 }, { "source": "models.Rmd", "filename": "models.html", "title": "Models", "engine": "knitr::rmarkdown", "headings": [ "Specify a model", "Credentials", "Recommended models" ], "created": "2025-12-22 14:56:13", "modified": "2025-12-22 14:56:13", "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": "2025-12-22 14:56:13", "modified": "2026-06-23 14:09:42", "commits": 2 }, { "source": "tools.Rmd", "filename": "tools.html", "title": "Tools", "engine": "knitr::rmarkdown", "headings": [ "Schema retrieval", "Data updating", "Data analysis", "Data visualization", "View the source" ], "created": "2025-12-22 14:56:13", "modified": "2026-06-23 14:09:42", "commits": 5 }, { "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-05-04 15:28:22", "modified": "2026-05-27 19:33:58", "commits": 3 } ], "_score": 10.46042933352671, "_indexed": true, "_nocasepkg": "querychat", "_universes": [ "posit-dev", "gadenbuie" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.0.9000", "date": "2026-07-10T21:50:59.000Z", "distro": "resolute", "commit": "09dd6fc3e0598ce69d3afaf77dfe0c21d9663f5e", "fileid": "https://r2.ropensci.org/3f95eae06c5c504c66c8d903e4672e05446db20e30039a94e2edf9b0c483edca", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/29125540406" }, { "r": "4.6.1", "os": "linux", "version": "0.3.0.9000", "date": "2026-07-10T21:50:48.000Z", "distro": "resolute", "commit": "09dd6fc3e0598ce69d3afaf77dfe0c21d9663f5e", "fileid": "https://r2.ropensci.org/4e45a2651fccc649e9797a257912fca14c90eeb4857f6b6b6fcbc98a3e97fc0f", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/29125540406" }, { "r": "4.5.3", "os": "mac", "version": "0.3.0.9000", "date": "2026-07-10T21:50:04.000Z", "commit": "09dd6fc3e0598ce69d3afaf77dfe0c21d9663f5e", "fileid": "https://r2.ropensci.org/2e43e2f2dd7ce992b8f1e79c260fa821acb3b9f6beb69f0bdf4a254d59348304", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/29125540406" }, { "r": "4.6.1", "os": "mac", "version": "0.3.0.9000", "date": "2026-07-10T21:49:44.000Z", "commit": "09dd6fc3e0598ce69d3afaf77dfe0c21d9663f5e", "fileid": "https://r2.ropensci.org/a06447ff51ef5667c8a227683b343877e50d6a739f3d3d96887ddf319afc9c24", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/29125540406" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.0.9000", "date": "2026-07-10T21:50:49.000Z", "commit": "09dd6fc3e0598ce69d3afaf77dfe0c21d9663f5e", "fileid": "https://r2.ropensci.org/5436f0a4c347435c7ee784b703b85aca161c3cb8b0693d7f950db321d29b672e", "status": "success", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/29125540406" }, { "r": "4.7.0", "os": "win", "version": "0.3.0.9000", "date": "2026-07-10T22:31:04.000Z", "commit": "09dd6fc3e0598ce69d3afaf77dfe0c21d9663f5e", "fileid": "https://r2.ropensci.org/0a2932f43b1ab331dc48b8db993a8ff95ada90232646f6cf5aee6f41a339c962", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/29125540406" }, { "r": "4.5.3", "os": "win", "version": "0.3.0.9000", "date": "2026-07-10T22:36:49.000Z", "commit": "09dd6fc3e0598ce69d3afaf77dfe0c21d9663f5e", "fileid": "https://r2.ropensci.org/e3338e777334ebaf2ec572ab03395feda3a2e680857dc112fe74bbb5ad379d4f", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/29125540406" }, { "r": "4.6.1", "os": "win", "version": "0.3.0.9000", "date": "2026-07-10T22:27:04.000Z", "commit": "09dd6fc3e0598ce69d3afaf77dfe0c21d9663f5e", "fileid": "https://r2.ropensci.org/3357fb316b6bb1e9ba5ff9ac99a1163416271f636953a50d0969a9580e979f87", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/29125540406" } ] }