DBI: R Database Interface

A database interface definition for communication between R and relational database management systems. All classes in this package are virtual and need to be extended by the various R/DBMS implementations.

Version: 1.3.0
Depends: methods, R (≥ 3.0.0)
Suggests: arrow, blob, callr, covr, DBItest (≥ 1.8.2), dbplyr, downlit, dplyr, glue, hms, knitr, magrittr, nanoarrow (≥ 0.3.0.1), otel, otelsdk, RMariaDB, rmarkdown, rprojroot, RSQLite (≥ 1.1-2), testthat (≥ 3.0.0), vctrs, xml2
Published: 2026-02-25
DOI: 10.32614/CRAN.package.DBI
Author: R Special Interest Group on Databases (R-SIG-DB) [aut], Hadley Wickham [aut], Kirill Müller ORCID iD [aut, cre], R Consortium [fnd]
Maintainer: Kirill Müller <kirill at cynkra.com>
BugReports: https://github.com/r-dbi/DBI/issues
License: LGPL-2.1 | LGPL-3 [expanded from: LGPL (≥ 2.1)]
URL: https://dbi.r-dbi.org, https://github.com/r-dbi/DBI
NeedsCompilation: no
Materials: README, NEWS
In views: Databases
CRAN checks: DBI results

Documentation:

Reference manual: DBI.html , DBI.pdf
Vignettes: A Common Database Interface (DBI) (source)
Advanced DBI Usage (source, R code)
Using DBI with Arrow (source, R code)
History of DBI (source)
A Common Interface to Relational Databases from R and S – A Proposal (source)
Introduction to DBI (source, R code)
Implementing a new backend (source, R code)
DBI specification (source, R code)

Downloads:

Package source: DBI_1.3.0.tar.gz
Windows binaries: r-devel: DBI_1.3.0.zip, r-release: DBI_1.3.0.zip, r-oldrel: DBI_1.3.0.zip
macOS binaries: r-release (arm64): DBI_1.3.0.tgz, r-oldrel (arm64): DBI_1.3.0.tgz, r-release (x86_64): DBI_1.3.0.tgz, r-oldrel (x86_64): DBI_1.3.0.tgz
Old sources: DBI archive

Reverse dependencies:

Reverse depends: biglm, biglmm, ckanr, D4TAlink.light, dbWebForms, dittodb, duckdb, gmDatabase, implyr, odbc.resourcer, RecordLinkage, repana, RJDBC, RMySQL, ROracle, rpostgis, RPostgreSQL, stacomirtools, TKCat
Reverse imports: acc, acdcquery, actigraph.sleepr, actiRhythm, adbi, AdhereRViz, africamonitor, agcounts, allofus, Andromeda, ankiR, apsimx, archivist, arkdb, AzureKusto, basedosdados, BatchExperiments, BatchJobs, bcdata, bdlp, bedrockbio, bidux, BIEN, bigrquery, biolink, birdscanR, blsBandit, BOLDNODE, brclimr, brfssdata, brickster, canpumf, cansim, CDMConnector, chms, chunked, ciecl, CITAN, ClickHouseHTTP, clintrialx, cnefetools, CodelistGenerator, CommonDataModel, commons, connections, connector, connector.databricks, contoso, cranlike, csdb, ctrialsgov, D3GB, DatabaseConnector, datacaged, datapond, db2pq, dbglm, dbi.table, DBItest, dbMatrix, dbplyr, dbProject, dbSpatial, dbx, dexter, dextergui, dfeR, diseasystore, DisImpact, DIZutils, dqcheckr, dqcheckrGUI, duckdbfs, duckh3, ducklake, duckplyr, duckspatial, earthUI, easydb, eatDB, elcf4R, emuR, epidm, etl, Eunomia, expDB, eyeris, farr, featdelta, FeatureExtraction, FIESTA, FIESTAutils, filehashSQLite, firmmatchr, framework, fspls2, gatoRs, gcbd, geobr, geocodebr, GeoTox, gooseR, gpkg, GWalkR, htsr, hybridEHR, hydrodownloadR, ILORA, iNZightTools, ipanema, kidsides, landsepi, lazysf, liteq, LLMAgentR, login, lucas, marmap, MCOE, mdbr, mdsr, MeasurementDiagnostics, metrica, mfdb, mitools, moodleR, motherduck, mpathsenser, mtgjsonsdk, NCA, neonstore, neuroimaGene, nodbi, nordstatExtras, obm, occCite, octopus, odbc, okf, OmopOnSpark, openappr, OpenRange, OpenSourceAP.DownloadR, overtureR, PANACEA, parquetize, pathdb, pathfindR, pestr, pgTools, phylosignal, piecemeal, PKbioanalysis, pmparser, pointblank, pool, prrd, pysparklyr, QBMS, qryflow, qst, quak, RAGFlowChainR, ragnar, rangeMapper, rapsimng, RAthena, rb3, rcdf, RClickhouse, rDeckgl, Rduckhts, readepi, redquack, rerddapUtils, restez, ResultModelManager, ReviewR, RGreenplum, RMariaDB, rMosaic, rocker, RODBCDBI, rpgconn, RPostgres, rsgl, RSQL, RSQLite, RSQLite.toolkit, rsyncrosim, RuHere, rvisual, rwevalidate, RXKCD, samadb, SangerTools, SCDB, scRNAstat, sdstudio, SEERaBomb, sehrnett, sejmRP, sergeant, sf, shinyChatR, shinyHugePlot, shinymanager, shinymgr, shinyNotes, simplegraphdb, snowquery, snplist, soilDB, soundClass, spanishoddata, sparkavro, sparklyr, SQL, sqldf, sqlhelper, sqlHelpers, sqliter, sqliteutils, sqlm, SQLove, sqlq, sqltargets, srcr, starwarsdb, stenographer, supabaseR, surveydown, svrep, syrona, taskqueue, taxadb, taxizedb, tcpl, TestGenerator, tidyfinance, tidyhydat, tidywikidatar, tigreBrowserWriter, toxSummary, TrialEmulation, ugatsdb, VectrixDB, vegdata, virtuoso, when, wizaRdry, wrds, writer, zipcodeR, zot
Reverse suggests: activAnalyzer, aisdk, aroma.affymetrix, arrow, AzureCosmosR, baseballr, bdc, btw, catalog, cdata, cellkeyperturbation, censobr, censosbo, cfbfastR, CohortCharacteristics, CohortConstructor, CohortContrast, CohortCosts, CohortSurvival, CohortSymmetry, CohortUtilisation, convey, cookiemonster, corrr, countryatlas, crawlee, cytominer, datadiff, dataverifyr, dbplot, diegr, dlookr, dm, dplyneage, dplyr, DrugExposureDiagnostics, DrugUtilisation, ECOTOXr, editbl, emburden, EpiStandard, ETLUtils, fabricQueryR, FakeDataR, fastRhockey, finbif, freestiler, geoflow, geogenr, geojsonio, GitStats, gloBFPr, glue, GWSDAT, hoopR, hyd1d, IncidencePrevalence, insurancerating, intendo, InterpretMSSpectrum, ipumsr, joinery, knitr, learnr, lgrExtra, mlr3db, mlr3oml, modeldb, myIO, nanoparquet, NetSimR, nflfastR, nhanesA, nngeo, oai, oce, oddsapiR, omock, OmopIndices, OmopSketch, orbital, orderly, osdc, palimpsestr, PatientProfiles, PhenotypeR, PhysicalActivity, pillar, positron.tutorials, ProjectTemplate, prqlr, quantmod, R6P, radiant.data, RaMS, rdataretriever, REDCapR, reproducible, resourcer, retraction, rolap, rqdatatable, rquery, rtemis, rxode2, scrime, shinyauthr, shinylogs, simaerep, sixtyfour, soilKey, SpaDES.core, srvyr, stats19, stevemisc, storr, stream, StreamCatTools, survey, taxify, tidylearn, tidypredict, tidyprompt, tidyquery, toxpiR, TreatmentPatterns, valr, vectra, vtreat, wehoop, winch, withr
Reverse enhances: caroline

Linking:

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