{
  "_id": "6ae115003d0f299392dce3c5",
  "Package": "querychat",
  "Title": "Filter and Query Data Frames in 'shiny' Using an LLM Chat\nInterface",
  "Version": "0.4.2.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",
  "Config/roxygen2/version": "8.1.1",
  "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-10-27 17:18:09 UTC",
  "RemoteUrl": "https://github.com/posit-dev/querychat",
  "RemoteRef": "HEAD",
  "RemoteSha": "a4da2b1624fb78bd4d1bb8123947f30839bca0de",
  "RemoteSubdir": "pkg-r",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-27 20:28:48 UTC",
    "User": "root"
  },
  "Author": "Garrick Aden-Buie [aut, cre] (ORCID:\n<https://orcid.org/0000-0002-7111-0077>),\nJoe Cheng [aut, ccp],\nCarson Sievert [aut] (ORCID: <https://orcid.org/0000-0002-4958-2844>),\nPosit Software, PBC [cph, fnd]",
  "Maintainer": "Garrick Aden-Buie <garrick@posit.co>",
  "_user": "posit-dev",
  "_type": "src",
  "_file": "querychat_0.4.2.9000.tar.gz",
  "_fileid": "https://r2.ropensci.org/607bb20a0c3e7fd37b71b9c212b88c745237de296ffa80c08d218a027278f4be",
  "_filesize": 2830244,
  "_sha256": "607bb20a0c3e7fd37b71b9c212b88c745237de296ffa80c08d218a027278f4be",
  "_expires": "2027-02-04T21:17:50.000Z",
  "_created": "2026-10-27T20:28:48.000Z",
  "_published": "2026-10-27T21:17:52.501Z",
  "_upstream": "https://github.com/posit-dev/querychat",
  "_status": "success",
  "_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"
  },
  "_jobs": [
    {
      "job": 122451239642,
      "time": 198,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12768138367"
    },
    {
      "job": 122451239883,
      "time": 172,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12769095902"
    },
    {
      "job": 122451239632,
      "time": 1935,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12772645569"
    },
    {
      "job": 122451239592,
      "time": 176,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12769307249"
    },
    {
      "job": 122448937156,
      "time": 258,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12769055521"
    },
    {
      "job": 122451239579,
      "time": 111,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "12767689434"
    },
    {
      "job": 122451239569,
      "time": 179,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12769335468"
    },
    {
      "job": 122451239715,
      "time": 158,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12769040938"
    },
    {
      "job": 122451239661,
      "time": 155,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12767819483"
    }
  ],
  "_buildurl": "https://github.com/r-universe/posit-dev/actions/runs/40577788783",
  "_commit": {
    "id": "a4da2b1624fb78bd4d1bb8123947f30839bca0de",
    "author": "Garrick Aden-Buie <garrick@adenbuie.com>",
    "committer": "Garrick Aden-Buie <garrick@adenbuie.com>",
    "message": "pkg-r: Increment dev version to v0.4.2.9000\n",
    "time": 1793121489
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_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": "coro",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "ellmer",
      "version": ">= 0.5.0",
      "role": "Imports"
    },
    {
      "package": "htmltools",
      "role": "Imports"
    },
    {
      "package": "jsonlite",
      "role": "Imports"
    },
    {
      "package": "lifecycle",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "promises",
      "role": "Imports"
    },
    {
      "package": "R6",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "version": ">= 1.1.0",
      "role": "Imports"
    },
    {
      "package": "S7",
      "role": "Imports"
    },
    {
      "package": "shiny",
      "version": ">= 1.14.0",
      "role": "Imports"
    },
    {
      "package": "shinychat",
      "version": ">= 0.5.0",
      "role": "Imports"
    },
    {
      "package": "utils",
      "role": "Imports"
    },
    {
      "package": "whisker",
      "role": "Imports"
    },
    {
      "package": "yaml",
      "role": "Imports"
    },
    {
      "package": "zip",
      "role": "Imports"
    },
    {
      "package": "dbplyr",
      "role": "Suggests"
    },
    {
      "package": "dplyr",
      "role": "Suggests"
    },
    {
      "package": "DT",
      "role": "Suggests"
    },
    {
      "package": "duckdb",
      "role": "Suggests"
    },
    {
      "package": "ggsql",
      "version": ">= 0.5.2",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "later",
      "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": "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-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
    },
    {
      "week": "2026-32",
      "n": 3
    },
    {
      "week": "2026-35",
      "n": 3
    },
    {
      "week": "2026-36",
      "n": 4
    },
    {
      "week": "2026-37",
      "n": 23
    },
    {
      "week": "2026-38",
      "n": 1
    },
    {
      "week": "2026-40",
      "n": 4
    },
    {
      "week": "2026-42",
      "n": 5
    },
    {
      "week": "2026-44",
      "n": 2
    }
  ],
  "_tags": [
    {
      "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"
    },
    {
      "name": "py/v0.8.0",
      "date": "2026-09-12"
    },
    {
      "name": "py/v0.9.0",
      "date": "2026-09-13"
    },
    {
      "name": "r/v0.4.0",
      "date": "2026-09-14"
    },
    {
      "name": "r/v0.4.1",
      "date": "2026-09-30"
    },
    {
      "name": "r/v0.4.2",
      "date": "2026-10-27"
    }
  ],
  "_stars": 213,
  "_contributors": [
    {
      "user": "cpsievert",
      "count": 127,
      "uuid": 1365941
    },
    {
      "user": "gadenbuie",
      "count": 72,
      "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, PBC",
    "followers": 1068
  },
  "_downloads": {
    "count": 413,
    "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": 113,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/querychat.html",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_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"
    },
    {
      "version": "0.4.0",
      "date": "2026-09-14"
    },
    {
      "version": "0.4.1",
      "date": "2026-09-30"
    },
    {
      "version": "0.4.2",
      "date": "2026-10-27"
    }
  ],
  "_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",
    "zip"
  ],
  "_vignettes": [
    {
      "source": "build.Rmd",
      "filename": "build.html",
      "title": "Build an App",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Starter template",
        "Chat-first page",
        "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-09-13 19:11:52",
      "commits": 7
    },
    {
      "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": "2026-08-04 00:27:08",
      "commits": 2
    },
    {
      "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.510986820780934,
  "_indexed": true,
  "_nocasepkg": "querychat",
  "_universes": [
    "posit-dev",
    "gadenbuie"
  ],
  "_previous": "0.4.1.9000",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.4.2.9000",
      "date": "2026-10-27T20:31:21.000Z",
      "distro": "resolute",
      "commit": "a4da2b1624fb78bd4d1bb8123947f30839bca0de",
      "fileid": "https://r2.ropensci.org/e6522273e98aebcf3e143be40fd4ba0061bf6fe7ab2a044dbedb1a9b627c91fb",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/40577788783"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.4.2.9000",
      "date": "2026-10-27T20:31:15.000Z",
      "distro": "resolute",
      "commit": "a4da2b1624fb78bd4d1bb8123947f30839bca0de",
      "fileid": "https://r2.ropensci.org/907e5cfaaef8bffc1a88c5a38d08e439ba5c06e6c8441b316eab707560773d13",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/40577788783"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.4.2.9000",
      "date": "2026-10-27T21:15:53.000Z",
      "commit": "a4da2b1624fb78bd4d1bb8123947f30839bca0de",
      "fileid": "https://r2.ropensci.org/8ff55f0d3e1788f974c175bcddf9e6f1d25829778241d0d299448d995f936509",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/40577788783"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.4.2.9000",
      "date": "2026-10-27T20:45:24.000Z",
      "commit": "a4da2b1624fb78bd4d1bb8123947f30839bca0de",
      "fileid": "https://r2.ropensci.org/3dbe645464bc00346630bc2037bf15d70de302615a08fafd38485932198a8c90",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/40577788783"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.4.2.9000",
      "date": "2026-10-27T20:31:11.000Z",
      "commit": "a4da2b1624fb78bd4d1bb8123947f30839bca0de",
      "fileid": "https://r2.ropensci.org/de55dfb0d5b24e9f587eb698d0966abecea5be248d761c0b56b21fd240a68ac4",
      "status": "success",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/40577788783"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.4.2.9000",
      "date": "2026-10-27T20:30:28.000Z",
      "commit": "a4da2b1624fb78bd4d1bb8123947f30839bca0de",
      "fileid": "https://r2.ropensci.org/15239f16585de1c520dd23a9199ce4fe8faca2ac35b0bb0944ee3309acbb3dee",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/40577788783"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.4.2.9000",
      "date": "2026-10-27T20:30:19.000Z",
      "commit": "a4da2b1624fb78bd4d1bb8123947f30839bca0de",
      "fileid": "https://r2.ropensci.org/eed8628e6a619cd4f93316d229fb39eb310331ce702f8f31254254a4f92b55b2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/40577788783"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.4.2.9000",
      "date": "2026-10-27T20:30:15.000Z",
      "commit": "a4da2b1624fb78bd4d1bb8123947f30839bca0de",
      "fileid": "https://r2.ropensci.org/85ec5f4ce71fab5cbe2c9adb2f8d94c67b49c683d098eae5ba0827ead0cd9dde",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/40577788783"
    }
  ]
}