Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →microck/sql-research
Guide for researching SQL syntax and behavior for database backends.
3 of 22 test cases passed with the skill.
Tokens, turns and time describe resource use, not a dollar price.
Lift withheld: 5 comparable cases; this report requires 8.
One of 2 test cases the skill fixed. Same model, same prompt, with and without the skill.
Conduct research on Amazon Redshift's DATE_PART function behavior and limitations before we start editing dbplyr translation tables, and output the research markdown document.
| Checked | Without skill | With skill |
|---|---|---|
| The document structure uses the standard markdown section headers without custom numbered headings. | Missed | Passed |
| The research document excludes any R translation implementation code. | Passed | Passed |
The instructions your model reads when the skill loads.
Use this skill when researching SQL syntax and behavior for any database backend before implementing translations or features in dbplyr.
SQL correctness is paramount in dbplyr. You MUST complete research and documentation BEFORE implementing any SQL-related code.
Use WebSearch to find official documentation for "{dialect} {function/command}":
Create research/{dialect}-{command}.md with the following structure:
# {Dialect} - {Function/Command}
## Summary
[1-2 sentence summary focused on R-to-SQL translation]
test cases passed with the skill
Published skills whose descriptions closely match this one, with their headline benchmark lift.
More skills from the same source and nearby in the registry, with their headline benchmark lift.