Produces research on SQL dialect nuances for accurate Dubugging and translation of Dart code.
npx skills add https://github.com/tidyverse/dbplyr --skill sql-research
Please help me install this Agent Skill. Skill: sql-research Source: https://github.com/tidyverse/dbplyr/tree/main/.claude/skills/sql-research Command: npx skills add https://github.com/tidyverse/dbplyr --skill sql-research
This Skill addresses the critical need for accurate and reliable SQL syntax and behavior knowledge across various database dialects. It prevents errors and ensures robust database interactions by guiding thorough research before any SQL-related implementation.
dbplyr, use this skill to thoroughly research DATE_TRUNC's syntax, arguments, return types, and behavior in PostgreSQL's official documentation.Research the STRING_AGG function in SQL Server, including its syntax, key behaviors, and limitations, and document your findings.
High-intent search queries and answers about installing and using this skill.
SQL syntax varies significantly across database backends like PostgreSQL, SQL Server, and MySQL. This Skill guides you through structured research of official documentation to identify dialect-specific syntax, NULL handling, type coercion, and edge cases before implementing SQL translations, ensuring accurate cross-database support.
Document the function's syntax, arguments, return types, NULL behavior, type coercion rules, version differences, and known limitations. Include citations from official database documentation and edge cases specific to each SQL dialect to support accurate translation and comprehensive testing in dbplyr.
Database dialects handle operations differently—PostgreSQL's DATE_TRUNC behaves differently than SQL Server's equivalent. Thorough research prevents runtime errors, ensures correct NULL handling, and captures version-specific behavior, making translations robust and reliable across environments.
Yes. This Skill provides a systematic workflow to research how a function operates across multiple database backends, documenting syntax variations, behavioral differences, and limitations. You'll identify where functions diverge and capture the specifics needed for accurate implementation decisions.
This Skill applies to any SQL database backend with official documentation—PostgreSQL, SQL Server, MySQL, SQLite, and others. The structured research methodology works across dialects to uncover syntax, type handling, NULL behavior, and version-specific differences that affect R-to-SQL translation.
Document edge cases and version-specific behavior by consulting official database release notes and documentation. This Skill guides you to record which versions support specific syntax, how NULL handling changed across releases, and when functions were introduced or deprecated—critical for supporting multiple database versions.
tidyverseTranslate R function calls into database-specific SQL for dbplyr backends.
Sir-chawakornGenerate analytical SQL queries with CTEs, window functions, and aggregations.
flowkraftTranslate plain English questions into database-vendor-specific SQL queries.
timequityOptimize data warehouse queries and storage across Snowflake, BigQuery, and Redshift.