Backends for R-DBI

Do you maintain a backend and think that yours should be on this list? Please open an issue in the backends repository.

adbi 0.1.2 (2025-09-03) πŸ”— πŸ”— πŸ›

DBI Compliant Database Access Using ADBC

In order to make Arrow Database Connectivity (ADBC https://arrow.apache.org/adbc/) accessible from R, an interface compliant with the DBI package is provided, using driver back-ends that are implemented in the adbcdrivermanager framework. This enables interacting with database systems using the Arrow data format, thereby offering an efficient alternative to ODBC for analytical applications.

Maintainer: Nicolas Bennett . License: LGPL (>= 2.1)

AzureKusto 1.1.4 (2025-09-10) πŸ”— πŸ›

Interface to Kusto/Azure Data Explorer

An interface to Azure Data Explorer, also known as Kusto, a fast, distributed data exploration service from Microsoft: https://azure.microsoft.com/en-us/products/data-explorer/. Includes DBI and dplyr interfaces, with the latter modelled after the dbplyr package, whereby queries are translated from R into the native KQL query language and executed lazily. On the admin side, the package extends the object framework provided by AzureRMR to support creation and deletion of databases, and management of database principals. Part of the AzureR family of packages.

Maintainer: Alex Kyllo . License: MIT + file LICENSE

bigrquery 1.6.1 (2025-09-10) πŸ”— πŸ›

An Interface to Google’s BigQuery API

Easily talk to Google’s BigQuery database from R.

Maintainer: Hadley Wickham . License: MIT + file LICENSE

brickster 0.2.12 (2026-02-04)

R Toolkit for Databricks

Collection of utilities that improve using Databricks from R. Primarily functions that wrap specific Databricks APIs (https://docs.databricks.com/api), RStudio connection pane support, quality of life functions to make Databricks simpler to use.

Maintainer: Zac Davies . License: Apache License (>= 2)

ckanr 0.7.0 (2023-03-17) πŸ”— πŸ›

Client for the Comprehensive Knowledge Archive Network (CKAN) API

Client for CKAN API (https://ckan.org/). Includes interface to CKAN APIs for search, list, show for packages, organizations, and resources. In addition, provides an interface to the datastore API.

Maintainer: Francisco Alves . License: MIT + file LICENSE

ClickHouseHTTP 0.3.4 (2025-06-05) πŸ›

A Simple HTTP Database Interface to ClickHouse

ClickHouse (https://clickhouse.com/) is an open-source, high performance columnar OLAP (online analytical processing of queries) database management system for real-time analytics using SQL. This DBI backend relies on the ClickHouse HTTP interface and support HTTPS protocol.

Maintainer: Patrice Godard . License: GPL-3

connections 0.2.1 (2025-09-11) πŸ”— πŸ›

Integrates with the RStudio Connections Pane and pins

Enables DBI compliant packages to integrate with the RStudio connections pane, and the pins package. It automates the display of schemata, tables, views, as well as the preview of the table’s top 1000 records.

Maintainer: Edgar Ruiz . License: MIT + file LICENSE

DatabaseConnector 7.1.0 (2026-01-09) πŸ”— πŸ›

Connecting to Various Database Platforms

An R DataBase Interface (DBI) compatible interface to various database platforms (PostgreSQL, Oracle, Microsoft SQL Server, Amazon Redshift, Microsoft Parallel Database Warehouse, IBM Netezza, Apache Impala, Google BigQuery, Snowflake, Spark, SQLite, and InterSystems IRIS). Also includes support for fetching data as Andromeda objects. Uses either Java Database Connectivity (JDBC) or other DBI drivers to connect to databases.

Maintainer: Martijn Schuemie . License: Apache License

DBI.RODBC 0.1-2

DBI front-end to RODBC

A simple DBI front-end to the RODBC package. This package uses version 4 style classes and methods to create a front-end to the existing RODBC (version 0.8-3) package.

Maintainer: David A. James . License: GPL (version 2 or later)

DBI.RPgSQL 0.1-2

DBI front-end to RPgSQL

A simple DBI front-end to the RPgSQL package. This package uses version 4 style classes and methods to create a front-end to the existing RPgSQL (version 1.0-0) package.

Maintainer: David A. James . License: GPL (version 2 or later)

dittodb 0.1.11 (2026-02-24) πŸ”— πŸ›

A Test Environment for Database Requests

Testing and documenting code that communicates with remote databases can be painful. Although the interaction with R is usually relatively simple (e.g. data(frames) passed to and from a database), because they rely on a separate service and the data there, testing them can be difficult to set up, unsustainable in a continuous integration environment, or impossible without replicating an entire production cluster. This package addresses that by allowing you to make recordings from your database interactions and then play them back while testing (or in other contexts) all without needing to spin up or have access to the database your code would typically connect to.

Maintainer: Jonathan Keane . License: Apache License (>= 2.0)

duckdb 1.5.2 (2026-04-13) πŸ”— πŸ›

DBI Package for the DuckDB Database Management System

The DuckDB project is an embedded analytical data management system with support for the Structured Query Language (SQL). This package includes all of DuckDB and an R Database Interface (DBI) connector.

Maintainer: Kirill MΓΌller . License: MIT + file LICENSE

implyr 0.5.0 (2024-02-06) πŸ›

R Interface for Apache Impala

SQL back-end to dplyr for Apache Impala, the massively parallel processing query engine for Apache Hadoop. Impala enables low-latency SQL queries on data stored in the Hadoop Distributed File System (HDFS), Apache HBase, Apache Kudu, Amazon Simple Storage Service (S3), Microsoft Azure Data Lake Store (ADLS), and Dell EMC Isilon. See https://impala.apache.org for more information about Impala.

Maintainer: Ian Cook . License: Apache License 2.0 | file LICENSE

lazysf 0.3.0 (2026-02-17) πŸ”— πŸ›

Delayed Read for GDAL Vector Data Sources

Lazy read for drawings. A dplyr back end for data sources supported by GDAL vector drivers, that allows working with local or remote sources as if they are in-memory data frames. Basic features works with any drawing format (GDAL vector data source) supported by the sf package.

Maintainer: Michael Sumner . License: GPL-3

MonetDB.R 2.0.0 (2020-08-14)

Connect MonetDB to R

Allows to pull data from MonetDB into R.

Maintainer: Mitchell Weggemans . License: MPL (== 2.0)

MonetDBLite 0.6.0 (2018-07-27) πŸ›

In-Process Version of MonetDB

An in-process version of MonetDB, a SQL database designed for analytical tasks. Similar to SQLite, the database runs entirely inside the R shell.

Maintainer: Hannes MΓΌhleisen . License: MPL (== 2.0)

noctua 2.6.3 (2025-09-15) πŸ”— πŸ›

Connect to AWS Athena using R AWS SDK paws (DBI Interface)

Designed to be compatible with the R package DBI (Database Interface) when connecting to Amazon Web Service (AWS) Athena https://aws.amazon.com/athena/. To do this the R AWS Software Development Kit (SDK) paws https://github.com/paws-r/paws is used as a driver.

Maintainer: Dyfan Jones . License: MIT + file LICENSE

odbc 1.7.0 (2026-05-09) πŸ”— πŸ”— πŸ›

Connect to ODBC Compatible Databases (using the DBI Interface)

A DBI-compatible interface to ODBC databases.

Maintainer: Hadley Wickham . License: MIT + file LICENSE

pool 1.0.4 (2024-10-07) πŸ”— πŸ›

Object Pooling

Enables the creation of object pools, which make it less computationally expensive to fetch a new object. Currently the only supported pooled objects are DBI connections.

Maintainer: Hadley Wickham . License: MIT + file LICENSE

RAthena 2.6.3 (2025-09-29) πŸ”— πŸ›

Connect to AWS Athena using Boto3 (DBI Interface)

Designed to be compatible with the R package DBI (Database Interface) when connecting to Amazon Web Service (AWS) Athena https://aws.amazon.com/athena/. To do this Python Boto3 Software Development Kit (SDK) https://boto3.amazonaws.com/v1/documentation/api/latest/index.html is used as a driver.

Maintainer: Dyfan Jones . License: MIT + file LICENSE

RClickhouse 0.6.10 (2025-02-26) πŸ›

Yandex Clickhouse Interface for R with Basic dplyr Support

Yandex Clickhouse (https://clickhouse.com/) is a high-performance relational column-store database to enable big data exploration and analytics scaling to petabytes of data. Methods are provided that enable working with Yandex Clickhouse databases via DBI methods and using dplyr/dbplyr idioms.

Maintainer: Christian Hotz-Behofsits . License: GPL-2

RH2 0.2.5 (2025-04-11)

DBI/RJDBC Interface to H2 Database

DBI/RJDBC interface to h2 database. h2 version 2.3.232 is included.

Maintainer: β€œDavid M. Kaplan” . License: Mozilla Public License 1.1

RJDBC 0.2-10 (2022-03-24)

Provides Access to Databases Through the JDBC Interface

The RJDBC package is an implementation of R’s DBI interface using JDBC as a back-end. This allows R to connect to any DBMS that has a JDBC driver.

Maintainer: Simon Urbanek . License: MIT + file LICENSE

RMariaDB 1.3.5 (2026-02-06) πŸ”— πŸ”— πŸ›

Database Interface and MariaDB Driver

Implements a DBI-compliant interface to MariaDB (https://mariadb.org/) and MySQL (https://www.mysql.com/) databases.

Maintainer: Kirill MΓΌller . License: MIT + file LICENSE

RMySQL 0.11.3 (2026-04-11) πŸ”— πŸ›

Database Interface and MySQL Driver for R

Legacy DBI interface to MySQL / MariaDB based on old code ported from S-PLUS. A modern MySQL client written in C++ is available from the RMariaDB package.

Maintainer: Jeroen Ooms . License: GPL-2

RODBCDBI 0.1.1 (2016-03-14)

Provides Access to Databases Through the ODBC Interface

An implementation of R’s DBI interface using ODBC package as a back-end. This allows R to connect to any DBMS that has a ODBC driver.

Maintainer: Nagi Teramo . License: MIT + file LICENSE

ROracle 1.5-1 (2025-10-27)

OCI Based Oracle Database Interface for R

Oracle Database interface (DBI) driver for R. This is a DBI-compliant Oracle driver based on the OCI.

Maintainer: Rajendra S. Pingte . License: LGPL

RPostgres 1.4.10 (2026-02-16) πŸ”— πŸ›

C++ Interface to PostgreSQL

Fully DBI-compliant C++-backed interface to PostgreSQL https://www.postgresql.org/, an open-source relational database.

Maintainer: Kirill MΓΌller . License: MIT + file LICENSE

RPostgreSQL 0.7-8 (2025-03-28) πŸ”— πŸ”—

R Interface to the PostgreSQL Database System

Database interface and PostgreSQL driver for R. This package provides a Database Interface DBI compliant driver for R to access PostgreSQL database systems. In order to build and install this package from source, PostgreSQL itself must be present your system to provide PostgreSQL functionality via its libraries and header files. These files are provided as postgresql-devel package under some Linux distributions. On macOS and Microsoft Windows system the attached libpq library source will be used.

Maintainer: Tomoaki Nishiyama . License: GPL-3 | file LICENSE

RPresto 1.4.8 (2025-12-02) πŸ›

DBI Connector to Presto

Implements a DBI compliant interface to Presto. Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes: https://prestodb.io/.

Maintainer: Jarod G.R. Meng . License: BSD_3_clause + file LICENSE

RRedshiftSQL 0.1.2 (2016-09-15)

R Interface to the Redshift Database

Superclasses PostgreSQL connection to help enable full dplyr functionality on Redshift.

Maintainer: Michael Treadwell . License: GPL-2

RSQLite 3.52.0 (2026-05-10) πŸ”— πŸ›

SQLite Interface for R

Embeds the SQLite database engine in R and provides an interface compliant with the DBI package. The source for the SQLite engine and for various extensions is included. System libraries will never be consulted because this package relies on static linking for the plugins it includes; this also ensures a consistent experience across all installations.

Maintainer: Kirill MΓΌller . License: LGPL (>= 2.1)

RSQLServer 0.3.0 (2017-06-17) πŸ›

SQL Server R Database Interface (DBI) and dplyr SQL Backend

Utilises The jTDS project’s JDBC 3.0 SQL Server driver to extend DBI classes and methods. The package also implements a SQL backend to the dplyr package.

Maintainer: Imanuel Costigan . License: GPL-2

sergeant 0.9.1 (2021-11-29) πŸ›

Tools to Transform and Query Data with Apache Drill

Apache Drill is a low-latency distributed query engine designed to enable data exploration and analysis on both relational and non-relational data stores, scaling to petabytes of data. Methods are provided that enable working with Apache Drill instances via the REST API, DBI methods and using dplyr/dbplyr idioms. Helper functions are included to facilitate using official Drill Docker images/containers.

Maintainer: Bob Rudis . License: MIT + file LICENSE

sparklyr 1.9.4 (2026-04-18) πŸ›

R Interface to Apache Spark

R interface to Apache Spark, a fast and general engine for big data processing, see https://spark.apache.org/. This package supports connecting to local and remote Apache Spark clusters, provides a dplyr compatible back-end, and provides an interface to Spark’s built-in machine learning algorithms.

Maintainer: Edgar Ruiz . License: Apache License 2.0 | file LICENSE