The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

ggsql: Grammar of Graphics for SQL

Allows you to write queries that combine SQL (Structured Query Language) data retrieval with visualization specifications in a single, composable syntax. The 'ggsql' package binds directly with the 'ggsql' 'Rust' library and allows you to set up readers and writers and execute queries against it. The package also offers 'knitr' and 'shiny' integration allowing the user to use 'ggsql' in both frameworks.

Version: 0.3.3
Depends: R (≥ 4.2)
Imports: cli, htmltools, htmlwidgets, jsonlite, knitr, nanoarrow, R6, rlang (≥ 1.1.0), yaml
Suggests: gapminder, quarto, reticulate, rmarkdown, rsvg, shiny, testthat (≥ 3.0.0), V8, withr
Published: 2026-06-03
DOI: 10.32614/CRAN.package.ggsql
Author: Thomas Lin Pedersen ORCID iD [aut, cre], George Stagg ORCID iD [aut], Teun van den Brand ORCID iD [aut], Posit, PBC ROR ID [cph, fnd]
Maintainer: Thomas Lin Pedersen <thomas.pedersen at posit.co>
BugReports: https://github.com/posit-dev/ggsql-r/issues
License: MIT + file LICENSE
URL: https://r.ggsql.org, https://github.com/posit-dev/ggsql-r
NeedsCompilation: yes
SystemRequirements: Cargo (Rust's package manager), rustc (>= 1.86), ODBC driver manager (unixODBC on Linux, iODBC or unixODBC on macOS; built into Windows)
Materials: README, NEWS
CRAN checks: ggsql results

Documentation:

Reference manual: ggsql.html , ggsql.pdf
Vignettes: The ggsql knitr engine (source, R code)
Getting started (source, R code)

Downloads:

Package source: ggsql_0.3.3.tar.gz
Windows binaries: r-devel: ggsql_0.3.2.zip, r-release: ggsql_0.3.3.zip, r-oldrel: ggsql_0.3.2.zip
macOS binaries: r-release (arm64): ggsql_0.3.3.tgz, r-oldrel (arm64): ggsql_0.3.3.tgz, r-release (x86_64): ggsql_0.3.3.tgz, r-oldrel (x86_64): ggsql_0.3.3.tgz
Old sources: ggsql archive

Reverse dependencies:

Reverse suggests: querychat

Linking:

Please use the canonical form https://CRAN.R-project.org/package=ggsql to link to this page.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.