Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Get Started Free →

SQL Translation Skill · microck | DecimalAI

databy microck

SQL Translation Skill

microck/sql-translation

Source microck/ordinary-claude-skills ↗License NOASSERTION

Guide for adding SQL function translations to dbplyr backends.

SkillScore92Maintained

Automatic

Coding pack

Last verified 8/21/2026

What it changes

Passed 22 of 24 test cases with the skill, and 13 of 24 without it.

Without skill54%

With skill92%

Checks it passed that the model alone missed

Uses devtools::test with reporter set to llm
Instructs formatting the code using air format .
Specifies running air format . to format the code

and 7 more in the full report

9 fixed13 passed either way2 still failing0 broke

Pass-rate lift: +38 pp
Tokens: +27%
Agent turns: 0%
Response time: -53%

Model gemini-3.6-flashMeasured 8/21/2026v122 of 24 cases passed with skill

Tokens, turns and time describe resource use, not a dollar price.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/microck-sql-translation/SKILL.md https://app.decimal.ai/s/microck-sql-translation/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add microck-sql-translation, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/microck-sql-translation/ and pins it in .decimal/skills.lock

decimalai skills add microck-sql-translation

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/microck-sql-translation/SKILL.md https://app.decimal.ai/s/microck-sql-translation/SKILL.md

Raw file: /s/microck-sql-translation/SKILL.md ↗ · machine-readable summary at /s/microck-sql-translation.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

One of 9 test cases the skill fixed. Same model, same prompt, with and without the skill.

1 of 9

Prompt

We need to format R files before submitting a pull request to dbplyr. I usually run `styler::style_pkg()`. What specific CLI command should be executed for code formatting?

What was checked, without and with the skill
Checked	Without skill	With skill
Specifies running air format . to format the code	Missed	Passed

case-19 · gemini-3.6-flash · 8/21/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md183 linessingle file

SQL Translation Skill

Use this skill when adding new SQL function translations for a specific database backend.

Overview

This skill guides you through adding SQL translations to dbplyr. SQL translations convert R functions to their SQL equivalents for different database backends.

Workflow

1. Research SQL (CRITICAL - ALWAYS FIRST)

Before implementing any SQL translation, you MUST research the SQL syntax and behavior using the sql-research skill. See that skill for the complete research workflow.

Quick summary:

Search official documentation for "{dialect} {function}"
Document findings in research/{dialect}-{function}.md
Include all source URLs
Only proceed to implementation after completing research

2. Identify the backend file

SQL translations are defined in backend-specific files:

R/backend-sqlite.R - SQLite
R/backend-postgres.R - PostgreSQL
R/backend-mysql.R - MySQL
R/backend-mssql.R - MS SQL Server
etc.

3. Add translation

Translations are added to the sql_translation() method for the connection class. This method returns a sql_variant() with three components:

Scalar translations (for mutate/filter):

sql_translator(.parent = base_scalar,
  # Simple function name mapping
  log10 = function(x) sql_expr(log(!!x)),

  # Function with different arguments

Track record

Benchmark

22 / 24

test cases passed, vs 13 / 24 without

Adoption

Users: 0
Times used: 0

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/3/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

microck / ordinary-claude-skills

skills_all/sql-translation/SKILL.md

View on GitHub ↗

License NOASSERTIONImported 8/3/2026Version v1

Other skills for the same job

Published skills whose descriptions closely match this one, with their headline benchmark lift.

microck/sql-researchGuide for researching SQL syntax and behavior for database backends. Use when you need to research how a SQL function, command, or feature works in a specific database before implementing it in dbplyr.Close match

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

SQL Translation Skill

Overview

Workflow

1. Research SQL (CRITICAL - ALWAYS FIRST)

2. Identify the backend file

3. Add translation

Track record

Benchmark

Adoption

SkillSafety

Source

Other skills for the same job

Related skills