How does this skill assist with dbplyr development?

It focuses specifically on the details needed for R-to-SQL translation, such as index handling (0-based vs 1-based), return types, and window function specifications.

Does this skill automatically write SQL code?

No, it focuses on the research phase. It helps gather the necessary facts and documentation so that the subsequent implementation of SQL-generating code is accurate and robust.

Where are the research findings stored?

The skill follows a pattern of creating standardized Markdown files within a 'research/' directory, organized by dialect and command name.

Which databases does this skill support?

It is dialect-agnostic and can be used to research any SQL database, including PostgreSQL, SQL Server, MySQL, SQLite, Oracle, and BigQuery.

What is the primary goal of the SQL Research skill?

The primary goal is to ensure SQL correctness by requiring thorough research and documentation of database-specific syntax and behaviors before any code is implemented.

SQL Research & Documentation

Name: SQL Research & Documentation
Author: Activer007

byActiver007

0•

データベース管理

Researches and documents database-specific SQL syntax and behaviors to ensure accurate R-to-SQL translations for dbplyr.

The SQL Research skill provides a rigorous, standardized workflow for investigating SQL dialects and features before implementation. It guides the AI through searching official documentation, identifying critical edge cases like NULL handling and 0-vs-1 indexing, and creating structured research files. By enforcing a 'documentation-first' principle, it ensures that SQL-generating code, particularly for tools like dbplyr, is built on a foundation of verified technical facts across diverse backends such as PostgreSQL, SQL Server, and BigQuery.

主な機能

01Standardized research templates for SQL functions and commands

02Comprehensive checklists for SQL correctness and reliability

030 GitHub stars

04Focus on R-to-SQL translation nuances like type coercion

05Multi-source verification workflow for database edge cases

06Version-specific feature tracking and documentation

ユースケース

01Documenting database-specific limitations and NULL behaviors

02Researching syntax differences between various SQL dialects

03Developing and maintaining dbplyr database backends

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add activer007/ordinary-claude-skills sql-research

For use in Claude.ai and ChatGPT

Download Skill