dbplyr

Spec sheet

Purpose

dbplyr is the database backend for dplyr and converts dplyr code into SQL for remote database tables.Read 5 Oct 2026 · dbplyr.tidyverse.org

Intended users

The documentation describes using dbplyr when data already lives in a database or is too large to fit in memory at once.Read 5 Oct 2026 · dbplyr.tidyverse.org

Support

The site links users to a getting-help page and a GitHub issue tracker for reporting bugs.Read 5 Oct 2026 · dbplyr.tidyverse.org

License

The dbplyr site identifies the package license as MIT.Read 5 Oct 2026 · dbplyr.tidyverse.org

Connection interface

Database connections are coordinated through DBI, and users install a backend package for the database they want to connect to.Read 5 Oct 2026 · dbplyr.tidyverse.org

Database backends

The package index lists built-in dialects or backends including SQLite, PostgreSQL, MySQL/MariaDB, SQL Server, Oracle, Snowflake, Redshift, Spark SQL, Teradata, Hive, and others.Read 5 Oct 2026 · dbplyr.tidyverse.org

Inspect queries

The package provides functions to show generated SQL and query plans.Read 5 Oct 2026 · dbplyr.tidyverse.org

Installation

The documentation gives installation commands for dbplyr from CRAN and for the development version from GitHub.Read 5 Oct 2026 · dbplyr.tidyverse.org

Lazy queries

Operations on remote tables are delayed and sent to the database when results are requested.Read 5 Oct 2026 · dbplyr.tidyverse.org

Maintainers

The site lists Hadley Wickham as author and maintainer and names Maximilian Girlich and Edgar Ruiz as authors.Read 5 Oct 2026 · dbplyr.tidyverse.org

Maker history

Posit says RStudio, now Posit, was founded in 2009 to create open-source software for data scientists.Read 5 Oct 2026 · posit.co

Requirements

Using dbplyr with a database requires a DBI backend package for that database.Read 5 Oct 2026 · dbplyr.tidyverse.org

SQL scope

dbplyr focuses on generating SELECT statements and does not translate all of SQL.Read 5 Oct 2026 · dbplyr.tidyverse.org

Supported operations

Documented operations include filtering, selecting, mutating, grouping, summarising, joins, set operations, and row modifications.Read 5 Oct 2026 · dbplyr.tidyverse.org

Plans and prices

Every dbplyr plan and price →

Where Specifiction places it

• Data Transformation Tools#18 of 377.8