Guide 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.
The sql-research skill is designed to assist in researching SQL syntax, behavior, and edge cases across different database backends before implementing SQL translations or features in dbplyr. It focuses on ensuring SQL correctness by providing a structured approach to research, emphasizing official documentation and authoritative sources. This skill helps streamline the process of understanding and implementing database-specific SQL commands in R, ensuring the translations between R code and SQL queries are accurate and efficient.
Use this skill before implementing any SQL translation for a database backend, when documenting database-specific SQL features, or before writing SQL-generating code in dbplyr.
The workflow includes searching for official documentation, documenting findings in a structured format, verifying research by cross-referencing multiple sources, and only proceeding to implementation once research and documentation are complete.
Yes, the skill requires documentation to be minimal, focused on dbplyr use cases, and citations must be included. Additionally, any uncertainties or ambiguities should be clearly documented, and version-specific differences must be noted.
Verify your findings by cross-referencing multiple authoritative sources, checking for version-specific differences, and testing the functionality in the actual database if possible.
Quick Setup:
.claude/skills/Repository
tidyverse/dbplyr