dbplyr

2.6.0

A 'dplyr' Back End for Databases

136packages depend

7.3Mdownloads / year

91.8%test coverage

13/13checks pass

Overview

About

Maintained by Hadley WickhamFirst published 2017-06-0926 releasesCRAN page ↗GitHub ↗

A 'dplyr' back end for databases that allows you to work with remote database tables as if they are in-memory data frames. Basic features work with any database that has a 'DBI' back end; more advanced features require 'SQL' translation to be provided by the package author.

Install

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

install.packages("dbplyr", 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("tidyverse/dbplyr")

Development version from tidyverse/dbplyr. 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-dbplyr

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

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-dbplyr

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed).

Health

CRAN checks

13OK

Slowest check: 8.8 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-18
12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
OK2026-06-27
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-06-24
12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
OK2026-06-09
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Show 5 earlier snapshots

ERROR2026-06-08
12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
OK2026-05-05
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-05-04
12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
OK2026-04-25
12 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-03-10
12 OK · 0 NOTE · 0 WARNING · 2 ERROR · 0 FAILURE

Documentation

Documentation signals are not tracked yet for this package.

Downloads

7.3M

CRAN downloads in the past year

Rank #140 · ~19.9K/day · ~606.2K/mo

dbplyr Releases R versions

Daily download trend is not available in this view yet.

400.8K30 days

1.4M90 days

7.3M1 year

Compare downloads with other packages →

Also on111.2K r2u170 autocran896.8K conda_forge6.1K c2d4u

Repository

GitHub ↗ tidyverse/dbplyr

514Stars

191Forks

14Open issues

3Open PRs

25Releases

4,121Commits

167Contributors

rdatabase

4,121 commits · Last activity 2026-06-17 · +0.4% stars, 30d

Repository practices

Upstream repositoryBeta

14 development-tooling and community-health practices detected across 8 families in the upstream repository

Checks run against github.com/tidyverse/dbplyr on 2026-07-19.

Continuous integration (1)

GitHub Actions

Reproducibility and dev environment (1)

Dev Container

CRAN release process (2)

cran-comments.mdrevdep/

Docs source (1)

README.Rmd

Show all practices

Lint, format, editor (3)

AirVS CodeRStudio project

Coverage (2)

Codecov.covrignore

Governance and community (3)

Issue templatesCODEOWNERSSupport guide

Git structural (1)

.gitattributes

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

Dependencies

Declared dependencies

32 external dependencies (excludes base and recommended)

Depends (1)

R >= 4.1

Imports (18)

blob cli DBI dplyr (>= 1.1.2)glue lifecycle magrittrmethodspillar purrr R6 rlang tibble tidyr tidyselectutilsvctrs withr (>= 2.5.0)

LinkingTo (0)

none

Suggests (16)

adbcdrivermanager adbcsqlite adbi bit64 covr knitr Lahman nycflights13 odbc RJDBC RMariaDB (>= 1.2.2)rmarkdown RPostgres RPostgreSQL RSQLite testthat

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

136direct

163indirect

and 88 more packages.

Code & Tests

People & History

People (4)

Maintainer (1)

Hadley Wickham

Author, Maintainer

Authors (3)

Hadley Wickham

Author, Maintainer

Maximilian Girlich

Author · added in 2.1.0

Edgar Ruiz

Author · added in 1.2.0

Posit Software, PBC

Funders (1)

Posit Software, PBC

Listed in earlier versions (1)

RStudio

no longer listed · 1.0.0 to 2.4.0

Package Timeline

26 releases. R releases are shown for context.

2.6.0Latest
2026-06-18 · current release · diff ↗
R
R 4.6.0 released · 2026-04-24
2.5.2
2026-02-13 · diff ↗
2.5.1
2025-09-10 · diff ↗
R
R 4.5.0 released · 2025-04-11
R
R 4.4.0 released · 2024-04-24
2.5.0
2024-03-19 · diff ↗
2.4.0
2023-10-26 · diff ↗
2.3.4
2023-09-27 · diff ↗
2.3.3
2023-07-07 · diff ↗
R
R 4.3.0 released · 2023-04-21
2.3.2
2023-03-21 · diff ↗
2.3.1
2023-02-24 · diff ↗
2.3.0
2023-01-16 · diff ↗
2.2.1
2022-06-27 · diff ↗
2.2.0
2022-06-05 · diff ↗

Show 20 earlier events

R
R 4.2.0 released · 2022-04-22
R
R 4.1.0 released · 2021-05-18
2.1.1
2021-04-06 · diff ↗
2.1.0
2021-02-03 · diff ↗
2.0.0
2020-11-03 · diff ↗
1.4.4
2020-05-27 · diff ↗
R
R 4.0.0 released · 2020-04-24
1.4.3
2020-04-19 · diff ↗
1.4.2
2019-06-17 · diff ↗
1.4.1
2019-06-06 · diff ↗
R
R 3.6.0 released · 2019-04-26
1.4.0
2019-04-24 · diff ↗
1.3.0
2019-01-09 · diff ↗
1.2.2
2018-07-25 · diff ↗
R
R 3.5.0 released · 2018-04-23
1.2.1
2018-02-19 · diff ↗
1.2.0
2018-01-03 · diff ↗
1.1.0
2017-06-27 · diff ↗
1.0.0
2017-06-09
R
R 3.4.0 released · 2017-04-21

Package metadata

First published: 2017-06-09
Total releases: 26 / 9 yrs
License: MIT + file LICENSE OSI
Download size: 540 KB
Installed size: not tracked yet
With dependencies: not tracked yet

Appears in task views

Databases with R Model Deployment with R

Report a problem with this page →