skills.rest
tmorrowdev
tmorrowdevCOMMUNITY
Explore all skills by this author →
GitHub

sql-queries

Translates and optimizes SQL queries across Snowflake, BigQuery, Redshift, Databricks, and PostgreSQL dialects.

1|Updated Feb 26, 2026
Search Tags:#postgresql#sql#query-optimization#bigquery#snowflake#databricks#dialect-translation
One-click install
npx skills add https://github.com/tmorrowdev/data-plugin --skill sql-queries-tmorrowdev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-queries
Source: https://github.com/tmorrowdev/data-plugin/tree/main/skills/sql-queries
Command: npx skills add https://github.com/tmorrowdev/data-plugin --skill sql-queries-tmorrowdev

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Translate and optimize SQL queries across dialects to ensure correctness and performance.

Core Features & Use Cases

  • Cross-dialect syntax adaptation for Snowflake, BigQuery, Redshift, Databricks, and PostgreSQL.
  • Support for advanced patterns: CTEs, window functions, JSON access, and complex joins.
  • Practical guidance for writing portable, efficient analytics queries in real-world workflows.

Quick Start

Write a Snowflake query that computes monthly revenue by region from the sales table.

Frequently Asked Questions about sql-queries

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

FAQPage Schema
How do I translate a PostgreSQL query to Snowflake syntax?▼

You can convert SQL queries across dialects by adjusting syntax for functions, data types, and JSON access. This Skill adapts queries for Snowflake, BigQuery, Redshift, Databricks, and PostgreSQL to ensure correctness.

What is the best way to optimize SQL queries using CTEs and window functions?▼

Optimizing SQL with CTEs and window functions requires structuring complex analytics logically and following dialect best practices. This Skill enforces performance considerations and provides guidance for writing efficient, portable queries.

Does this approach support BigQuery and Databricks dialect translation?▼

Yes, BigQuery and Databricks dialect translation is fully supported. The Skill covers multiple engines including Snowflake, Redshift, and PostgreSQL, ensuring cross-dialect syntax adaptation for correct and fast analytics.

How do I handle dialect-specific data types and error handling in SQL?▼

Handling dialect-specific data types and error handling in SQL requires enforcing engine-specific syntax rules. This Skill provides practical guidance on these constraints to ensure query correctness across different database platforms.

Why does my cross-dialect SQL query fail when moving from Redshift to BigQuery?▼

Cross-dialect SQL queries fail from Redshift to BigQuery due to differences in syntax, data types, and JSON access methods. The Skill addresses these limitations by translating and enforcing dialect-specific syntax for correctness.

Related Skills

Explore More Data & Analytics Skills→
theslashdojotheslashdojo

drizzle-schema

Define type-safe database schemas in TypeScript for Drizzle ORM.

Official
Intermediate
fuziix266fuziix266

sql-pro

Optimize SQL queries and design database schemas across PostgreSQL, MySQL, and SQL Server.

Community
Advanced
iankikuiankiku
18

data

Design analytics systems, generate SQL queries, plan event tracking, and build dashboards.

Community
Advanced
giadaf-booshagiadaf-boosha
10

sql-queries

Guide writing optimized SQL queries across Snowflake, BigQuery, Databricks, PostgreSQL, and Redshift.

Community
Advanced