{"id":"185356e8-36c2-446f-af07-3b99a540923c","shortId":"LVy85A","kind":"skill","title":"Translate and validate SQL across dialects with SQLGlot","tagline":"Use SQLGlot when an agent needs to parse, transpile, or sanity-check SQL before moving queries between engines or trusting generated SQL.","description":"# Translate and validate SQL across dialects with SQLGlot\n\nUse SQLGlot when an agent needs to parse, transpile, or sanity-check SQL before moving queries between engines or trusting generated SQL.\n\n## Prerequisites\n\nPython 3.8+, SQLGlot, and any agent or script that needs SQL parsing, transpilation, or validation.\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- # Optionally prefix with UV=1 to use uv for the installation\n- make install\n- make install-dev\n- make docs-serve\n\nRequirements and caveats from upstream:\n- It is a very comprehensive generic SQL parser with a robust [test suite](https://github.com/tobymao/sqlglot/blob/main/tests/). It is also quite [performant](#benchmarks), while being written purely in Python.\n- # Pure python version\n- Like parsing, generating SQL also requires the target dialect to be specified, otherwise the SQLGlot dialect will be used by default. For example, to transpile a query from Spark SQL to DuckDB, do parse_one(sql, diale...\n\nBasic usage or getting-started notes:\n- SQLGlot can detect a variety of [syntax errors](#parser-errors), such as unbalanced parentheses, incorrect usage of reserved keywords, and so on. These errors are highlighted and dialect incompatibilities can warn or...\n- [Run Tests and Lint](#run-tests-and-lint)\n- From PyPI:\n\n- Source: https://github.com/tobymao/sqlglot\n- Extracted from upstream docs: https://raw.githubusercontent.com/tobymao/sqlglot/HEAD/README.md\n\n## Documentation\n\n- https://sqlglot.com/sqlglot.html\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/translate-and-validate-sql-across-dialects-with-sqlglot/)","tags":["translate","and","validate","sql","across","dialects","with","sqlglot","skills","agentskillexchange","agent-skills","ai-agents"],"capabilities":["skill","source-agentskillexchange","skill-translate-and-validate-sql-across-dialects-with-sqlglot","topic-agent-skills","topic-ai-agents","topic-ai-tools","topic-awesome-list","topic-claude-code","topic-codex","topic-cursor","topic-llm","topic-mcp","topic-npx-skills","topic-openclaw","topic-skills-catalog"],"categories":["skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/agentskillexchange/skills/translate-and-validate-sql-across-dialects-with-sqlglot","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add agentskillexchange/skills","source_repo":"https://github.com/agentskillexchange/skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,665 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T19:12:53.294Z","embedding":null,"createdAt":"2026-05-18T13:20:00.290Z","updatedAt":"2026-05-18T19:12:53.294Z","lastSeenAt":"2026-05-18T19:12:53.294Z","tsv":"'/skills/translate-and-validate-sql-across-dialects-with-sqlglot/)':257 '/sqlglot.html':250 '/tobymao/sqlglot':239 '/tobymao/sqlglot/blob/main/tests/).':132 '/tobymao/sqlglot/head/readme.md':246 '1':95 '3.8':65 'across':5,36 'agent':13,44,69,252 'agentskillexchange.com':256 'agentskillexchange.com/skills/translate-and-validate-sql-across-dialects-with-sqlglot/)':255 'also':135,152 'basic':185 'benchmark':138 'caveat':114 'check':21,52 'comprehens':121 'default':168 'detect':194 'dev':107 'dial':184 'dialect':6,37,156,163,220 'doc':110,243 'docs-serv':109 'document':247 'duckdb':179 'engin':27,58 'environ':90 'error':199,202,216 'exampl':170 'exchang':254 'extract':240 'generat':30,61,150 'generic':122 'get':189 'getting-start':188 'github.com':131,238 'github.com/tobymao/sqlglot':237 'github.com/tobymao/sqlglot/blob/main/tests/).':130 'highlight':218 'incompat':221 'incorrect':207 'instal':79,83,101,103,106 'install-dev':105 'keyword':211 'like':148 'lint':228,233 'make':102,104,108 'match':88 'move':24,55 'need':14,45,73 'note':191 'one':182 'option':91 'otherwis':160 'parenthes':206 'pars':16,47,75,149,181 'parser':124,201 'parser-error':200 'path':86 'perform':137 'prefix':92 'prerequisit':63 'pure':142,145 'pypi':235 'python':64,144,146 'queri':25,56,174 'quit':136 'raw.githubusercontent.com':245 'raw.githubusercontent.com/tobymao/sqlglot/head/readme.md':244 'requir':112,153 'reserv':210 'robust':127 'run':225,230 'run-tests-and-lint':229 'saniti':20,51 'sanity-check':19,50 'script':71 'serv':111 'setup':85 'skill':253 'skill-translate-and-validate-sql-across-dialects-with-sqlglot' 'sourc':236,251 'source-agentskillexchange' 'spark':176 'specifi':159 'sql':4,22,31,35,53,62,74,123,151,177,183 'sqlglot':8,10,39,41,66,162,192 'sqlglot.com':249 'sqlglot.com/sqlglot.html':248 'start':190 'suit':129 'syntax':198 'target':155 'test':128,226,231 'topic-agent-skills' 'topic-ai-agents' 'topic-ai-tools' 'topic-awesome-list' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-llm' 'topic-mcp' 'topic-npx-skills' 'topic-openclaw' 'topic-skills-catalog' 'translat':1,32 'transpil':17,48,76,172 'trust':29,60 'unbalanc':205 'upstream':82,116,242 'usag':186,208 'use':9,40,80,97,166 'uv':94,98 'valid':3,34,78 'varieti':196 'version':147 'warn':223 'written':141","prices":[{"id":"29062b24-ba5d-4a48-a50c-29f672cf46ba","listingId":"185356e8-36c2-446f-af07-3b99a540923c","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"agentskillexchange","category":"skills","install_from":"skills.sh"},"createdAt":"2026-05-18T13:20:00.290Z"}],"sources":[{"listingId":"185356e8-36c2-446f-af07-3b99a540923c","source":"github","sourceId":"agentskillexchange/skills/translate-and-validate-sql-across-dialects-with-sqlglot","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/translate-and-validate-sql-across-dialects-with-sqlglot","isPrimary":false,"firstSeenAt":"2026-05-18T13:20:00.290Z","lastSeenAt":"2026-05-18T19:12:53.294Z"}],"details":{"listingId":"185356e8-36c2-446f-af07-3b99a540923c","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"translate-and-validate-sql-across-dialects-with-sqlglot","github":{"repo":"agentskillexchange/skills","stars":8,"topics":["agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor","llm","mcp","npx-skills","openclaw","skills-catalog"],"license":"mit","html_url":"https://github.com/agentskillexchange/skills","pushed_at":"2026-05-18T19:02:17Z","description":"The open catalog of AI agent skills — 2,000+ security-scanned skills for Claude Code, Cursor, Codex, and more.","skill_md_sha":"7aef54d0135aa8e5bb691a9fbe8d9142e135f98d","skill_md_path":"skills/translate-and-validate-sql-across-dialects-with-sqlglot/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/translate-and-validate-sql-across-dialects-with-sqlglot"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"Translate and validate SQL across dialects with SQLGlot","description":"Use SQLGlot when an agent needs to parse, transpile, or sanity-check SQL before moving queries between engines or trusting generated SQL."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/translate-and-validate-sql-across-dialects-with-sqlglot"},"updatedAt":"2026-05-18T19:12:53.294Z"}}