sql-translation

3 stars 1 forks
81
B

Guide for adding SQL function translations to dbplyr backends. Use when implementing new database-specific R-to-SQL translations for functions like string manipulation, date/time, aggregates, or window functions.

Also in: azure

Third-Party Agent Skill: Review the code before installing. Agent skills execute in your AI assistant's environment and can access your files. Learn more about security

Installation for Agentic Skill

View all platforms →
skilz install Microck/ordinary-claude-skills/sql-translation
skilz install Microck/ordinary-claude-skills/sql-translation --agent opencode
skilz install Microck/ordinary-claude-skills/sql-translation --agent codex
skilz install Microck/ordinary-claude-skills/sql-translation --agent gemini

First time? Install Skilz: pip install skilz

Works with 14 AI coding assistants

Cursor, Aider, Copilot, Windsurf, Qwen, Kimi, and more...

View All Agents
Download Agent Skill ZIP

Extract and copy to ~/.claude/skills/ then restart Claude Desktop

1. Clone the repository:
git clone https://github.com/Microck/ordinary-claude-skills
2. Copy the agent skill directory:
cp -r ordinary-claude-skills/skills_all/sql-translation ~/.claude/skills/

Need detailed installation help? Check our platform-specific guides:

Related Agentic Skills

Agentic Skill Details

Stars
3
Forks
1
Type
Technical
Meta-Domain
data ai
Primary Domain
database
Market Score
81

Agent Skill Grade

B
Score: 81/100 Click to see breakdown

Score Breakdown

Spec Compliance
12/15
PDA Architecture
21/30
Ease of Use
20/25
Writing Style
8/10
Utility
15/20
Modifiers: +5

Areas to Improve

  • No Reference Files for Complex Content
  • Missing Input/Output Example Pairs
  • Workflow References External Skill Without Bundling

Recommendations

  • Add trigger phrases to description for discoverability
  • Add table of contents for files over 100 lines

Graded: 2026-01-19

Developer Feedback

I took a look at your sql-translation skill and wanted to share some thoughts.

Links:

The TL;DR

You're at 81/100, solid B territory. This is based on Anthropic's best practices for skill design. Your strongest area is Spec Compliance (12/15)—the frontmatter is clean and the naming is right. Where you're losing points: Progressive Disclosure Architecture (21/30) and Utility (15/20). You've got good fundamentals here, but there's meaningful room to push this into A territory.

What's Working Well

  • Solid trigger terms: dbplyr, SQL translation, R-to-SQL—these are discoverable and specific enough that the right developers will find this skill
  • Clear workflow structure: Seven numbered steps with a validation checklist at the end gives developers a concrete path forward
  • Comprehensive translation patterns: You cover scalar, aggregate, and window function translations, which hits the main SQL translation use cases people actually need

The Big One: Missing Reference Files

Here's what's holding you back most—everything is crammed into a single 189-line SKILL.md file. For a skill this detailed, that's a lot of cognitive load in one place.

Why it matters: The grading rubric values Progressive Disclosure Architecture (30 points), and bundling everything together costs you 9 points here. When developers load your skill, they should get the essentials first, then progressively unfold complexity.

The fix: Create a references/ folder with two files:

  • references/translation-patterns.md — Move your code examples and helper functions here
  • references/testing-guide.md — Extract the testing secti...

Report Security Issue

Found a security vulnerability in this agent skill?