dbplyr
Translate R data pipelines into SQL for any database
All Skills in This Repository (4)
Pure Emerald Level Indicators
tidyversetidy-deprecate-function
Automate R function and argument deprecation workflows in dbplyr.
tidyversecreate-skill
Create reusable Claude Code skills with YAML frontmatter and markdown instructions.
tidyversesql-research
Produces research on SQL dialect nuances for accurate Dubugging and translation of Dart code.
tidyversesql-translation
Translate R function calls into database-specific SQL for dbplyr backends.
Frequently Asked Questions
FAQPage SchemaHow to install dbplyr?▼
Run `npx skills add tidyverse/dbplyr --all -g -y` in your terminal to install all skills in this repository globally.
What does dbplyr do?▼
dbplyr automatically translates R dplyr code into SQL, so you can work with remote database tables as if they were in-memory data frames. Queries run lazily and only execute on the database when you request results.
Which databases does dbplyr support?▼
It includes backends for PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Redshift, Snowflake, Spark, Hive, Impala, Teradata, and more, plus generic ODBC and JDBC connections.
How do I add a new SQL translation to dbplyr?▼
The sql-translation skill guides your agent through researching official database documentation, adding the translation to the correct backend file, and writing snapshot tests to verify the generated SQL.
Do I need to know SQL to use dbplyr?▼
No. You write standard dplyr verbs like filter, mutate, and summarise in R, and dbplyr generates the correct SQL for your specific database automatically.
Related Repositories in Data & Analytics
View All in Data & Analytics→
PaddlePaddlePaddleOCR
Extract text, tables, and formulas from PDFs and images
D4VinciScrapling
Scrape any website and bypass anti-bot protection with AI
mvanhornlast30days-skill
Research any topic across Reddit, X, YouTube, and the web