Why does the skill require documentation before implementation?

Requiring documentation first ensures that all edge cases and version-specific limitations are understood before any SQL-generating code is written, preventing bugs early.

What is the primary purpose of the SQL Research skill?

The skill is designed to facilitate the systematic investigation and documentation of SQL syntax and behavior across different database dialects to ensure code correctness.

How does this skill support dbplyr development?

It provides a specific workflow for researching how R functions should be translated into SQL, focusing on aspects like argument types, return values, and NULL handling.

Which databases can I research with this skill?

The skill is dialect-agnostic and can be used for any SQL database, including PostgreSQL, SQL Server, MySQL, SQLite, BigQuery, and more.

SQL Research Specialist

Name: SQL Research Specialist
Author: Activer007

byActiver007

データベース管理

Conducts systematic research on SQL syntax and database behaviors to ensure accurate implementation and translation.

概要

The SQL Research Specialist skill provides a structured framework for investigating SQL functions, commands, and dialect-specific behaviors before writing implementation code. Designed specifically for developers working on translation layers like dbplyr, this skill ensures that SQL-generating logic is grounded in official documentation and accounts for complex edge cases such as NULL handling, type coercion, and version-specific differences. It enforces a documentation-first workflow that prioritizes correctness and provides a standardized format for recording findings, making it an essential tool for cross-database development and maintenance.

主な機能

0 GitHub stars
Cross-referencing of official database documentation
Standardized SQL research documentation workflow
Version-specific feature and limitation tracking
Detailed analysis of NULL handling and return types
Dialect-specific syntax and behavior analysis

ユースケース

Investigating edge cases in complex window functions across dialects
Developing R-to-SQL translations for dbplyr database backends
Documenting database limitations before implementing new features

概要

主な機能

0 GitHub stars
Cross-referencing of official database documentation
Standardized SQL research documentation workflow
Version-specific feature and limitation tracking
Detailed analysis of NULL handling and return types
Dialect-specific syntax and behavior analysis

ユースケース

Investigating edge cases in complex window functions across dialects
Developing R-to-SQL translations for dbplyr database backends
Documenting database limitations before implementing new features