{
  "_id": "6a1e153b1d7bb097a0a60a41",
  "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",
  "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-01 22:47:48 UTC",
  "RemoteUrl": "https://github.com/posit-dev/querychat",
  "RemoteRef": "HEAD",
  "RemoteSha": "a0cf561921576dbcf0ca2479da834504bdc6e44f",
  "RemoteSubdir": "pkg-r",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-06-01 23:12:06 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>",
  "MD5sum": "562fac9711fca85e60a1f8889a1a6ad7",
  "_user": "posit-dev",
  "_type": "src",
  "_file": "querychat_0.3.0.9000.tar.gz",
  "_fileid": "167395fe35a8d7d56ad29dd99ea40d0e44bbdeb406219bf85c7c8b4adbc0dfac",
  "_filesize": 2784049,
  "_sha256": "167395fe35a8d7d56ad29dd99ea40d0e44bbdeb406219bf85c7c8b4adbc0dfac",
  "_created": "2026-06-01T23:12:06.000Z",
  "_published": "2026-06-01T23:26:51.124Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 78967265184,
      "time": 168,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7345246672"
    },
    {
      "job": 78967265161,
      "time": 169,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7345246836"
    },
    {
      "job": 78967265156,
      "time": 715,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7345376693"
    },
    {
      "job": 78967265174,
      "time": 846,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7345407361"
    },
    {
      "job": 78966820700,
      "time": 204,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7345204830"
    },
    {
      "job": 78967265157,
      "time": 138,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7345239209"
    },
    {
      "job": 78967265166,
      "time": 107,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7345231543"
    },
    {
      "job": 78967265180,
      "time": 116,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7345233773"
    },
    {
      "job": 78967265193,
      "time": 115,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7345233444"
    }
  ],
  "_buildurl": "https://github.com/r-universe/posit-dev/actions/runs/26787540574",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/posit-dev/querychat",
  "_commit": {
    "id": "a0cf561921576dbcf0ca2479da834504bdc6e44f",
    "author": "Carson <cpsievert1@gmail.com>",
    "committer": "Carson <cpsievert1@gmail.com>",
    "message": "chore(pkg-r): start new version\n",
    "time": 1780354068
  },
  "_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": "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": "dbplyr",
      "role": "Suggests"
    },
    {
      "package": "dplyr",
      "role": "Suggests"
    },
    {
      "package": "DT",
      "role": "Suggests"
    },
    {
      "package": "duckdb",
      "role": "Suggests"
    },
    {
      "package": "ggsql",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "palmerpenguins",
      "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-22",
      "n": 4
    },
    {
      "week": "2025-23",
      "n": 1
    },
    {
      "week": "2025-24",
      "n": 1
    },
    {
      "week": "2025-25",
      "n": 1
    },
    {
      "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
    }
  ],
  "_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": 192,
  "_contributors": [
    {
      "user": "cpsievert",
      "count": 82,
      "uuid": 1365941
    },
    {
      "user": "gadenbuie",
      "count": 54,
      "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"
  },
  "_downloads": {
    "count": 267,
    "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": 80,
  "_rbuild": "4.6.0",
  "_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",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/posit-dev/querychat",
  "_realowner": "posit-dev",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.2.0",
      "date": "2026-01-12"
    }
  ],
  "_exports": [
    "DataFrameSource",
    "DataSource",
    "DBISource",
    "querychat",
    "QueryChat",
    "querychat_app",
    "querychat_data_source",
    "querychat_greeting",
    "querychat_init",
    "querychat_server",
    "querychat_sidebar",
    "querychat_ui",
    "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": "querychat-convenience",
      "title": "QueryChat convenience functions",
      "topics": [
        "querychat",
        "querychat_app"
      ]
    },
    {
      "page": "QueryChat",
      "title": "QueryChat: Interactive Data Querying with Natural Language",
      "topics": [
        "QueryChat"
      ]
    },
    {
      "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"
  ],
  "_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",
        "Multiple filtered tables",
        "See also"
      ],
      "created": "2025-12-22 14:56:13",
      "modified": "2026-04-16 21:29:31",
      "commits": 3
    },
    {
      "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",
        "Custom sources"
      ],
      "created": "2025-12-22 14:56:13",
      "modified": "2025-12-22 14:56:13",
      "commits": 1
    },
    {
      "source": "greet.Rmd",
      "filename": "greet.html",
      "title": "Greet Users",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Provide a greeting",
        "Generate a greeting"
      ],
      "created": "2025-12-22 14:56:13",
      "modified": "2026-05-14 23:15:11",
      "commits": 2
    },
    {
      "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": [
        "Default prompt",
        "Data description",
        "Additional instructions",
        "Custom template"
      ],
      "created": "2025-12-22 14:56:13",
      "modified": "2025-12-22 14:56:13",
      "commits": 1
    },
    {
      "source": "tools.Rmd",
      "filename": "tools.html",
      "title": "Tools",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Data updating",
        "Data analysis",
        "Data visualization",
        "View the source"
      ],
      "created": "2025-12-22 14:56:13",
      "modified": "2026-05-27 19:33:58",
      "commits": 4
    },
    {
      "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.340053669270988,
  "_indexed": true,
  "_nocasepkg": "querychat",
  "_universes": [
    "posit-dev",
    "gadenbuie"
  ],
  "_previous": "0.2.0.9000",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.3.0.9000",
      "date": "2026-06-01T23:14:46.000Z",
      "distro": "noble",
      "commit": "a0cf561921576dbcf0ca2479da834504bdc6e44f",
      "fileid": "3ca2b27296ddc707a4f1f0b935fb157bddcaef403e801db66d2637a03fbba833",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/26787540574"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.3.0.9000",
      "date": "2026-06-01T23:14:45.000Z",
      "distro": "noble",
      "commit": "a0cf561921576dbcf0ca2479da834504bdc6e44f",
      "fileid": "66bf6d90aed351501bb082e0e25a49bd6713d6bccf07f77556d5c9b9abd56c07",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/26787540574"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.3.0.9000",
      "date": "2026-06-01T23:24:04.000Z",
      "commit": "a0cf561921576dbcf0ca2479da834504bdc6e44f",
      "fileid": "d2331f47dbd3542be0651f777046d42f8cbe47c540ed7cca12ac8765f782a6f9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/26787540574"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.3.0.9000",
      "date": "2026-06-01T23:26:01.000Z",
      "commit": "a0cf561921576dbcf0ca2479da834504bdc6e44f",
      "fileid": "cb8532530de5dcea0816ad779cf2a29a72d2b636678e592433ee5974a619837f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/26787540574"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.3.0.9000",
      "date": "2026-06-01T23:14:48.000Z",
      "commit": "a0cf561921576dbcf0ca2479da834504bdc6e44f",
      "fileid": "84c885eccc018c28b8916297bd91fa348b5952b5a248a66195af50c3ac4ca5a2",
      "status": "success",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/26787540574"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.3.0.9000",
      "date": "2026-06-01T23:13:29.000Z",
      "commit": "a0cf561921576dbcf0ca2479da834504bdc6e44f",
      "fileid": "35597c901ecdfd31a30cb5314c3dbbbfb2fb98743ea0ed40aca766c3eed14cb2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/26787540574"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.3.0.9000",
      "date": "2026-06-01T23:13:40.000Z",
      "commit": "a0cf561921576dbcf0ca2479da834504bdc6e44f",
      "fileid": "290c6895e6e018f49c3a5f80b4d0237f8898269c6be7aca171782f5213a201a1",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/26787540574"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.3.0.9000",
      "date": "2026-06-01T23:13:44.000Z",
      "commit": "a0cf561921576dbcf0ca2479da834504bdc6e44f",
      "fileid": "b7f56d6945dd2ef60f081b037df80490a628bc7b11056cbfbd0128743018fbfe",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/posit-dev/actions/runs/26787540574"
    }
  ]
}