sql-pro

Name: sql-pro
Availability: InStock
Author: Herdiansah

Optimize SQL queries and database schemas for cloud-native OLTP/OLAP systems.

23|2|Updated Jan 19, 2026

Search Tags:#database #data modeling #sql #cloud #performance tuning #olap #oltp

Ready to run

npx skills add https://github.com/herdiansah/Antigravity-Skills-Master --skill sql-pro-herdiansah

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/herdiansah/Antigravity-Skills-Master/tree/main/.agent/skills/sql-pro
Command: npx skills add https://github.com/herdiansah/Antigravity-Skills-Master --skill sql-pro-herdiansah

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill addresses the complexity of modern SQL databases, enabling users to optimize performance, design efficient schemas, and leverage advanced query techniques for cloud-native and hybrid analytical systems.

Core Features & Use Cases

Performance Tuning: Optimize queries, indexes, and database configurations for maximum efficiency.
Advanced Querying: Write complex analytical queries, utilize window functions, and handle hierarchical data.
Cloud Database Expertise: Work with platforms like Snowflake, BigQuery, Aurora, and hybrid OLTP/OLAP systems.
Use Case: Optimize a slow-running analytical query on a multi-billion row table in BigQuery to reduce execution time from hours to minutes.

Quick Start

Optimize the provided SQL query for performance on a Snowflake data warehouse.

Frequently Asked Questions about sql-pro

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

FAQPage Schema

How do I optimize SQL queries for cloud databases like Snowflake or BigQuery?▼

Performance tuning for hybrid OLTP/OLAP systems requires analyzing query execution plans, applying advanced index strategies, and refining data modeling for scalable enterprise applications. This approach reduces execution time from hours to minutes on multi-billion row tables.

What is the best way to design database schemas for hybrid analytical and transactional systems?▼

Designing database schemas for hybrid OLTP/OLAP systems involves structuring data models to support both transactional integrity and analytical querying. This requires modern data architecture techniques tailored for cloud-native platforms like Aurora and Snowflake.

Can I use advanced SQL window functions for performance tuning on multi-billion row tables?▼

Yes, using advanced SQL window functions and handling hierarchical data are core techniques for performance tuning on massive tables. When combined with proper index strategies, these analytical queries run efficiently across cloud data warehouses.

Does performance tuning work differently for OLTP compared to OLAP cloud architectures?▼

Performance tuning differs significantly between OLTP and OLAP cloud architectures. OLTP focuses on transactional throughput and fast indexed lookups, while OLAP emphasizes complex analytical queries, efficient data modeling, and large-scale scan performance.

Why does my slow-running analytical query take hours to execute on BigQuery?▼

A slow-running analytical query on BigQuery often indicates poor query plan analysis, inefficient data modeling, or inadequate index strategies. Optimizing SQL for cloud-native systems targets these bottlenecks to reduce execution time to minutes.