sql-data-analysis

Validate and optimize SQL queries for analytics across data warehouses.

1|Updated May 19, 2026

Search Tags:#analytics #performance optimization #reporting #sql #data-warehouse

Ready to run

npx skills add https://github.com/victormacaubas/data-engineering-skills --skill sql-data-analysis

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sql-data-analysis
Source: https://github.com/victormacaubas/data-engineering-skills/tree/main/skills/sql-data-analysis
Command: npx skills add https://github.com/victormacaubas/data-engineering-skills --skill sql-data-analysis

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill ensures the creation of correct, readable, and performant SQL queries for analytics and reporting, reducing errors and improving efficiency.

Core Features & Use Cases

SQL Standards: Adheres to canonical SQL standards for analytics, reporting, and transformation.
Cross-Warehouse Compatibility: Works across BigQuery, Snowflake, Redshift, Postgres, and more.
Use Case: When writing or reviewing SQL for data analysis tasks, use this Skill to ensure adherence to best practices and optimize performance.

Quick Start

Analyze SQL performance and correctness using the sql-data-analysis skill on your query.

Frequently Asked Questions about sql-data-analysis

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

FAQPage Schema

How do I optimize SQL queries for analytics and reporting?▼

To optimize SQL queries for analytics and reporting, you must validate correctness, readability, and performance while ensuring cost-effectiveness across your specific data warehouse environment. This involves adhering to canonical SQL standards for transformations.

Does this SQL analysis approach work with BigQuery, Snowflake, and Redshift?▼

Yes, cross-warehouse compatibility works across BigQuery, Snowflake, Redshift, Postgres, and other environments. It ensures query correctness and performance optimization regardless of the specific data warehouse platform you use.

What is the best way to validate SQL query correctness before running reporting tasks?▼

The best way to validate SQL query correctness is to review it against canonical SQL standards for analytics and reporting. This process identifies errors, improves efficiency, and ensures your transformations are readable and performant.

Do I need prior knowledge of data warehouse environments to optimize SQL performance?▼

Yes, optimizing SQL performance requires existing knowledge of SQL and data warehouse environments. You must understand your specific platform's mechanics to effectively address query cost-effectiveness and cross-warehouse compatibility.

Why does my data warehouse SQL query fail performance optimization checks?▼

Your SQL query fails performance optimization checks when it deviates from canonical SQL standards, leading to poor readability or high execution costs. Validating against best practices identifies bottlenecks and improves efficiency.

When do I need to use canonical SQL standards for data transformation?▼

You need to use canonical SQL standards for data transformation whenever writing or reviewing SQL for data analysis tasks. This ensures adherence to best practices, prevents errors, and maintains query performance and cost-effectiveness.