skills.rest
herdiansah
herdiansahCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

sql-pro

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
One-click install
npx skills add https://github.com/herdiansah/Antigravity-Skills-Master --skill sql-pro-herdiansah
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
salverius-techsalverius-tech

database-workflow

Provide database best practices for migrations, schema design, and query optimization.

Community
Advanced
xu-xiangxu-xiang
1.8k

clickhouse-io

Design ClickHouse tables and optimize queries with MergeTree family patterns.

Community
Advanced
hiddink-aihiddink-ai
1

snowflake-best-practices

Optimize Snowflake warehouse sizing, clustering, caching, and query performance.

Official
Intermediate
v1bh0rv1bh0r

nw-query-optimization

Analyze execution plans and design indexes for SQL and NoSQL queries.

Community
Intermediate