{ "_id": "6a3ec73ea319ef9414490845", "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-06-26 17:20:30 UTC", "RemoteUrl": "https://github.com/posit-dev/querychat", "RemoteRef": "HEAD", "RemoteSha": "f68e6ae14813d2ac681a85fe1893e0c2e1aed198", "RemoteSubdir": "pkg-r", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-26 18:34:31 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 ", "MD5sum": "324b3773c982311cd97646722fa17d1d", "_user": "posit-dev", "_type": "src", "_file": "querychat_0.3.0.9000.tar.gz", "_fileid": "a25457fe8eafddc874497087bbf131131ac4298ddbc2034d7dc19e90d47518d0", "_filesize": 2871895, "_sha256": "a25457fe8eafddc874497087bbf131131ac4298ddbc2034d7dc19e90d47518d0", "_created": "2026-06-26T18:34:31.000Z", "_published": "2026-06-26T18:38:54.925Z", "_distro": "resolute", "_jobs": [ { "job": 83725342509, "time": 203, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "7913575693" }, { "job": 83725342508, "time": 227, "config": "linux-release-x86_64", "r": "4.6.1", "check": "NOTE", "artifact": "7913583392" }, { "job": 83725342565, "time": 121, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "7913548256" }, { "job": 83725342557, "time": 110, "config": "macos-release-arm64", "r": "4.6.1", "check": "NOTE", "artifact": "7913544002" }, { "job": 83724691519, "time": 221, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "7913503777" }, { "job": 83725342533, "time": 162, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7913561983" }, { "job": 83725342549, "time": 139, "config": "windows-devel", "r": "4.7.0", "check": "NOTE", "artifact": "7913554416" }, { "job": 83725342575, "time": 143, "config": "windows-oldrel", "r": "4.5.3", "check": "NOTE", "artifact": "7913555624" }, { "job": 83725342570, "time": 127, "config": "windows-release", "r": "4.6.1", "check": "NOTE", "artifact": "7913550103" } ], "_buildurl": "https://github.com/r-universe/posit-dev/actions/runs/28257632291", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/posit-dev/querychat", "_commit": { "id": "f68e6ae14813d2ac681a85fe1893e0c2e1aed198", "author": "Garrick Aden-Buie ", "committer": "GitHub ", "message": "feat: editable SQL query editor in `$app()` (#265)\n\n* feat: editable SQL query in \\$app()\n\nReplace the read-only SQL markdown display with a `bslib::input_code_editor()`\nthat lets users edit the SQL directly. The editor submits on blur or Ctrl/Cmd+Enter.\n\n- `sync_sql_editor` observer keeps the editor in sync via `update_code_editor()`\n when the LLM updates SQL, the query is reset, or the active table switches\n- `on_sql_editor` observer applies user edits to `sql_val()`; treats the default\n `SELECT * FROM ` as NULL to prevent the Reset button from reappearing\n after a reset (update_code_editor triggers input$sql_editor on the server)\n- Editor excluded from bookmarking in both R and Python\n\nCloses #70\n\n* style(pkg-r): air format QueryChat.R\n\n* fix(pkg-py): update E2E selectors for CodeMirror editor\n\n`pre code` no longer exists; SQL is now rendered in `input_code_editor`\nwhich uses a `.cm-content` element.\n\n* fix(pkg-py): fix E2E selectors for bslib code editor\n\nbslib's input_code_editor renders as a custom element\nusing prism-code-editor (not CodeMirror). The editable value lives in the\ntextarea inside the element; switch from to_contain_text() to to_have_value()\naccordingly.\n\n* fix(pkg-py): add missing re import in test_02_prompt_app\n\n* docs: add NEWS and CHANGELOG bullets for editable SQL editor", "time": 1782494430 }, "_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" }, "_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-26", "n": 1 }, { "week": "2025-27", "n": 3 }, { "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 } ], "_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" } ], "_stars": 197, "_contributors": [ { "user": "cpsievert", "count": 87, "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": 965 }, "_downloads": { "count": 721, "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": 101, "_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.440550830220024, "_indexed": true, "_nocasepkg": "querychat", "_universes": [ "posit-dev", "gadenbuie" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.0.9000", "date": "2026-06-26T18:37:30.000Z", "distro": "resolute", "commit": "f68e6ae14813d2ac681a85fe1893e0c2e1aed198", "fileid": "c1e7626c95342e59cf22ec766f1a88b10b6bccf1eb553718a9a6d1cd56f13a8b", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/28257632291" }, { "r": "4.6.1", "os": "linux", "version": "0.3.0.9000", "date": "2026-06-26T18:37:54.000Z", "distro": "resolute", "commit": "f68e6ae14813d2ac681a85fe1893e0c2e1aed198", "fileid": "8d94c9005017f22009027a502a97e47fa62696e8ad90644e5bd1aa60027a7e14", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/28257632291" }, { "r": "4.5.3", "os": "mac", "version": "0.3.0.9000", "date": "2026-06-26T18:36:19.000Z", "commit": "f68e6ae14813d2ac681a85fe1893e0c2e1aed198", "fileid": "ac394554b4d138f04d1dfb1d8b9d97407ee3351ee91a1bb446c248dfbcf3a830", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/28257632291" }, { "r": "4.6.1", "os": "mac", "version": "0.3.0.9000", "date": "2026-06-26T18:36:12.000Z", "commit": "f68e6ae14813d2ac681a85fe1893e0c2e1aed198", "fileid": "a0833617a3e073b15fbfdfc9f0a57af059f3858e93c9bb2eb71d9307475d0c4b", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/28257632291" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.0.9000", "date": "2026-06-26T18:37:37.000Z", "commit": "f68e6ae14813d2ac681a85fe1893e0c2e1aed198", "fileid": "12108f6ece298e926c86db1aec8bcec3fa908c27289816112e1f2e51d4d9127d", "status": "success", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/28257632291" }, { "r": "4.7.0", "os": "win", "version": "0.3.0.9000", "date": "2026-06-26T18:36:04.000Z", "commit": "f68e6ae14813d2ac681a85fe1893e0c2e1aed198", "fileid": "355b27ef0cd22609d63cee20b4d19fa59359e22ae60331ee44072c6eb6a0f3c5", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/28257632291" }, { "r": "4.5.3", "os": "win", "version": "0.3.0.9000", "date": "2026-06-26T18:36:06.000Z", "commit": "f68e6ae14813d2ac681a85fe1893e0c2e1aed198", "fileid": "f293e7dd1629a5ae268cba816dbdf78a477e7ecfafdb5a1ac1eaf8e0cef5992e", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/28257632291" }, { "r": "4.6.1", "os": "win", "version": "0.3.0.9000", "date": "2026-06-26T18:35:56.000Z", "commit": "f68e6ae14813d2ac681a85fe1893e0c2e1aed198", "fileid": "a92a0810aad2390f736d6cc15b46d6ef8c910999abd837e32572528687cdecbb", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/28257632291" } ] }