skills.rest
kortix-ai
kortix-aiOFFICIAL
Explore all skills by this author →
Website𝕏@kortixGitHub

sql-queries

Write dialect-specific SQL for PostgreSQL, Snowflake, BigQuery, and Redshift.

Updated Aug 23, 2026
Search Tags:#performance#queries#sql#bigquery#postgres#dialects#redshift
One-click install
npx skills add https://github.com/kortix-ai/computer --skill sql-queries-kortix-ai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-queries
Source: https://github.com/kortix-ai/computer/tree/main/packages/kortix-opencode/skills/GENERAL-KNOWLEDGE-WORKER/sql-queries
Command: npx skills add https://github.com/kortix-ai/computer --skill sql-queries-kortix-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Write correct, performant SQL across all major data warehouse dialects to ensure portability and reduce maintenance.

Core Features & Use Cases

  • Cross-dialect SQL templates for PostgreSQL, Snowflake, BigQuery, Redshift, and more.
  • Guidance on date/time, string functions, JSON, arrays, performance tips, and common pitfalls.
  • Use Case: Migrate analytics queries from one warehouse to another without rewriting logic.

Quick Start

Provide a ready-to-run SQL snippet tailored to your target dialect.

Frequently Asked Questions about sql-queries

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

FAQPage Schema
How do I write efficient SQL queries that work across different data warehouses?▼

To write efficient SQL across warehouses, use cross-dialect templates for PostgreSQL, Snowflake, BigQuery, and Redshift, applying performance tips to ensure portability and reduce maintenance.

How do I migrate analytics queries from BigQuery to Redshift without rewriting logic?▼

Migrate BigQuery analytics queries to Redshift by using cross-dialect SQL templates and dialect references to translate date, time, string, and JSON functions without altering the core logic.

Does this SQL generator support PostgreSQL and Snowflake dialects?▼

Yes, this SQL generator supports PostgreSQL and Snowflake dialects, providing specific dialect references, performance tips, and common pitfall guidance to ensure consistent query results.

What is the best way to handle date and time functions when writing portable SQL?▼

The best way to handle date and time functions in portable SQL is to consult cross-dialect guidance that maps these functions across PostgreSQL, BigQuery, and Redshift to avoid common pitfalls.

What are common SQL pitfalls when porting queries between warehouses?▼

Common SQL pitfalls when porting queries between warehouses include dialect-specific differences in JSON parsing, array handling, and date/time functions, which cross-dialect templates help navigate.

How do I optimize SQL performance for large datasets in Postgres and BigQuery?▼

Optimize SQL performance for Postgres and BigQuery by applying built-in performance tips and best practices tailored to each specific warehouse dialect during query development and data modeling.

Related Skills

Explore More Data & Analytics Skills→
AltimateAIAltimateAI
792

pii-audit

Classify PII columns and audit query exposure with risk reports.

Official
Intermediate
victormacaubasvictormacaubas
1

sql-data-analysis

Validate and optimize SQL queries for analytics across data warehouses.

Community
Advanced
ivanshamaevivanshamaev
14

dbt-macros

Build dbt Jinja macros for reusable SQL with adapter.dispatch and run_query guards.

Community
Intermediate
EpiphyticEpiphytic
7

sql-queries

Write correct and performant SQL queries across major data warehouse dialects.

Official
Advanced