skills.rest
AltimateAI
AltimateAIOFFICIAL
Explore all skills by this author →
WebsiteGitHub

sql-translate

Translate SQL queries between database dialects using sqlglot transpilation.

792|138|Updated Feb 27, 2026
Search Tags:#sql#migrate#translate#dialects#transpile#sql-translation#sqlglot
One-click install
npx skills add https://github.com/AltimateAI/altimate-code --skill sql-translate
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-translate
Source: https://github.com/AltimateAI/altimate-code/tree/main/.opencode/skills/sql-translate
Command: npx skills add https://github.com/AltimateAI/altimate-code --skill sql-translate

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Translate SQL across dialects to ensure compatibility and smooth migration between database platforms.

Core Features & Use Cases

  • Sqlglot-powered transpilation: convert queries between Snowflake, BigQuery, PostgreSQL, MySQL, and more.
  • Interactive and inline translation: supports both guided prompts and direct inline translations.
  • Validation and guidance: returns warnings for lossy translations and compatibility issues, with guidance for manual tweaks.

Quick Start

Provide the source and target dialects along with the SQL to translate, then review the translated result.

Frequently Asked Questions about sql-translate

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I translate SQL queries between different database dialects?▼

You translate SQL queries by providing the source SQL, the target dialect, and the original database dialect. The engine parses the input and transpiles it into the target dialect syntax, returning the translated code for immediate use.

Can I migrate SQL from Snowflake to BigQuery or PostgreSQL?▼

Yes, you can migrate SQL from Snowflake to BigQuery, PostgreSQL, and MySQL. The transpilation engine converts source query syntax to the target dialect, ensuring compatibility and smooth migration across supported database platforms.

Does the SQL translation process warn me about compatibility issues?▼

Yes, the SQL translation process returns warnings for lossy translations and compatibility issues. It parses the SQL, performs dialect transpilation, and flags potential problems while providing guidance for any necessary manual tweaks.

What is the best way to convert SQL syntax for cross-database migration?▼

The best way to convert SQL syntax for cross-database migration is using a transpilation engine. It automatically parses the source SQL and rewrites it into the target dialect, handling syntax differences to ensure accurate database platform transitions.

How does sqlglot handle transpiling SQL between different dialects?▼

Sqlglot handles SQL transpilation by parsing the source query into an abstract syntax tree and regenerating it in the target dialect. This ensures the translated SQL adheres to the specific syntactic rules of the destination database platform.

Related Skills

Explore More Data & Analytics Skills→
cwidacwida
8

explain-lpts

Document the LPTS pipeline converting DuckDB logical plans to CTE-based SQL strings.

Official
Advanced
fakhriaditiarahmanfakhriaditiarahman
1

sql-pro

Optimize SQL queries and design data models for Snowflake, BigQuery, and PostgreSQL.

Community
Advanced
yunqiqiliangyunqiqiliang
8

clickzetta-sql-syntax-guide

Document ClickZetta Lakehouse SQL syntax for DDL, DML, and DQL migrations.

Community
Advanced
openyakopenyak
704

write-query

Translate natural-language data needs into dialect-specific SQL for Snowflake, BigQuery, and Postgres.

Official
Advanced