writing-sql
OfficialWrite correct SQL for Celigo RDBMS sync.
Software Engineering#troubleshooting#snowflake#sql generation#rdbms integration#handlebars templating#delta export#upsert merge
Authorceligo
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Writing RDBMS export and import SQL for Celigo often fails due to dialect differences, incorrect Handlebars templating, wrong query shapes, or mismatched queryType settings.
Core Features & Use Cases
- Correct Handlebars SQL templating: uses the required record. prefix and triple braces to prevent broken quoting and numeric corruption.
- Right query structure per queryType: generates the proper array-of-strings format and aligns INSERT/UPDATE/UPSERT/MERGE patterns to per_record, per_page, bulk_insert, and bulk_load strategies.
- Database-dialect safe patterns: provides practical syntax guidance across Snowflake, Postgres, MySQL/MariaDB, SQL Server/Azure Synapse, Oracle, BigQuery, and Redshift, including delta and once/mark-as-processed flows.
- Troubleshooting and guardrails: includes common error causes and a pre-submit checklist for typical runtime and syntax failures.
Quick Start
Use the writing-sql skill to generate an export SELECT query using the correct record. templating and the right delta token for your target database.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: writing-sql Download link: https://github.com/celigo/ai/archive/main.zip#writing-sql Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.