Sql Translation
Provides translation guidance and assistance for working with databases and data persistence.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add tidyverse-sql-translation npx -- -y @trustedskills/tidyverse-sql-translation
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"tidyverse-sql-translation": {
"command": "npx",
"args": [
"-y",
"@trustedskills/tidyverse-sql-translation"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill translates tidyverse and dbplyr code into SQL queries. It allows you to leverage the familiar syntax of R’s data manipulation tools while executing operations directly on a database server. The resulting SQL can be used for querying, inserting, updating, or deleting data within a supported database system.
When to use it
- You need to perform complex data transformations and analysis using R but want to offload the processing to a more powerful database.
- You're working with large datasets that are impractical to load entirely into memory in an R session.
- You want to automate SQL query generation from existing
tidyverseordbplyrcode. - You need to execute data manipulation tasks directly within a specific database environment (e.g., PostgreSQL, MySQL).
Key capabilities
- Translates
tidyverse/dbplyrsyntax into SQL. - Supports various database backends.
- Automates SQL query generation.
Example prompts
- "Translate this
dbplyrcode to SQL:library(dbplyr); my_table %>% filter(x > 5) %>% select(y)" - “Generate the SQL equivalent of this
tidyversedata manipulation pipeline.” - "Convert this R code using
dplyrinto a database query."
Tips & gotchas
- Requires familiarity with both
tidyverse/dbplyrand SQL. - The generated SQL will be specific to the underlying database system; ensure compatibility.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.