ggsql

0.3.3

Grammar of Graphics for SQL

1packages depend

1.2Kdownloads / year

–test coverage

13/13checks pass

Overview

About

Maintained by Thomas Lin PedersenFirst published 2026-05-272 releasesCRAN page ↗GitHub ↗

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.

Install

R (CRAN)pak (dev)Ubuntu (r2u)

install.packages("ggsql", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("posit-dev/ggsql-r")

Development version from posit-dev/ggsql-r. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-ggsql

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled.

bspm (used by r2u) also needs make: sudo apt install make

Health

CRAN checks

13OK

Slowest check: 129.9 min · r-devel-linux-x86_64-fedora-clang

Check history

OK2026-07-21
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-07-16
12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
OK2026-06-11
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-05-28
3 OK · 0 NOTE · 0 WARNING · 4 ERROR · 0 FAILURE

Documentation

Documentation signals are not tracked yet for this package.

Downloads

1.2K

CRAN downloads in the past year

Rank #9,337 · ~3/day · ~97/mo

ggsql Releases R versions

Daily download trend is not available in this view yet.

44730 days

1.2K90 days

1.2K1 year

Compare downloads with other packages →

Also on38 r2u

Repository

GitHub ↗ posit-dev/ggsql-r

15Stars

2Forks

2Open issues

0Open PRs

2Releases

43Commits

3Contributors

43 commits · Last activity 2026-06-15 · +15.4% stars, 30d

Repository practices

Upstream repositoryBeta

6 development-tooling and community-health practices detected across 5 families in the upstream repository

Checks run against github.com/posit-dev/ggsql-r on 2026-07-19.

Continuous integration (1)

GitHub Actions

CRAN release process (1)

cran-comments.md

Docs source (1)

README.Rmd

Lint, format, editor (2)

AirVS Code

Show all practices

Coverage (1)

Codecov

How this is detected·Detection ruleset v1 (2026-07-18)

Dependencies

Declared dependencies

18 external dependencies (excludes base and recommended)

Depends (1)

R >= 4.2

Imports (9)

cli htmltools htmlwidgets jsonlite knitr nanoarrow R6 rlang yaml

LinkingTo (0)

none

Suggests (9)

gapminder quarto reticulate rmarkdown rsvg shiny testthat V8 withr

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

1direct

0indirect

querychat

Code & Tests

People & History

People (4)

Maintainer (1)

Thomas Lin Pedersen

Author, Maintainer

Authors (3)

Author, Maintainer

Author

Author

Funders (1)

Package Timeline

2 releases. R releases are shown for context.

0.3.3Latest
2026-06-03 · current release · diff ↗
0.3.2
2026-05-27
R
R 4.6.0 released · 2026-04-24

Package metadata

First published: 2026-05-27
Total releases: 2 / 1 yrs
License: MIT + file LICENSE OSI
Download size: not tracked yet
Installed size: not tracked yet
With dependencies: not tracked yet

Report a problem with this page →