skills.rest
Lautaro073
Lautaro073COMMUNITY
Explore all skills by this author →
GitHub

sql-pro

Identifies and optimizes SQL queries for cloud-native databases in OLTP and OLAP workloads.

Updated Mar 23, 2026
Search Tags:#performance#database#sql#cloud#query-optimization#tuning#htap
One-click install
npx skills add https://github.com/Lautaro073/zCorvus_agents --skill sql-pro-lautaro073
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/Lautaro073/zCorvus_agents/tree/main/AI_Workspace/Agents/Backend/skills/sql-pro
Command: npx skills add https://github.com/Lautaro073/zCorvus_agents --skill sql-pro-lautaro073

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps developers and DBAs optimize SQL performance on cloud-native and HTAP databases by identifying bottlenecks, tuning queries, and ensuring scalable data processing across OLTP and OLAP workloads.

Core Features & Use Cases

  • Modern database systems and platforms knowledge for cloud-native databases: Amazon Aurora, Google Cloud SQL, Azure SQL Database, Snowflake, Google BigQuery, Amazon Redshift, Databricks, CockroachDB, TiDB, and more.
  • Advanced query techniques and optimization: window functions, recursive CTEs, complex joins, plan analysis, and parallel query execution.
  • Performance tuning and optimization: indexing strategies, statistics maintenance, partitioning, memory configuration, and I/O considerations.
  • Cloud database architecture: multi-region deployment, auto-scaling, backup, disaster recovery, and data migration strategies.
  • Data modeling and schema design: normalization vs denormalization, star/snowflake schemas, SCDs, and HTAP schema considerations.

Quick Start

Provide an optimized SQL example suite for a high-traffic OLTP/OLAP workload and explain the rationale behind each improvement.

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 HTAP workloads in cloud-native databases?▼

To optimize SQL queries for HTAP workloads, you must analyze query plans, apply advanced indexing strategies, and tune statistics maintenance to ensure scalable data processing across OLTP and OLAP environments. This requires schema details and workload characteristics.

What is the best way to tune performance for complex SQL joins and window functions?▼

Tuning performance for complex SQL joins and window functions involves analyzing execution plans, leveraging parallel query execution, and adjusting memory configuration and I/O considerations to eliminate bottlenecks in high-traffic scenarios.

Does this approach work with both Amazon Aurora and Snowflake for query optimization?▼

Yes, this query optimization approach applies to modern database systems including Amazon Aurora, Snowflake, Google BigQuery, Amazon Redshift, Databricks, CockroachDB, and TiDB, covering multi-region deployment and auto-scaling architectures.

How do I design a database schema for HTAP scenarios?▼

Designing a schema for HTAP scenarios requires balancing normalization versus denormalization, implementing star or snowflake schemas, and handling Slowly Changing Dimensions (SCDs) to support both OLTP and OLAP workloads efficiently.

Why does my SQL query performance degrade during cloud database auto-scaling events?▼

SQL query performance degrades during auto-scaling due to misconfigured partitioning, outdated data statistics, or suboptimal memory configuration, requiring workload characteristic analysis and versioned data statistics to restore efficient execution.

Related Skills

Explore More Software Engineering Skills→
AmidVoshakulAmidVoshakul

sql-pro

Analyze SQL execution plans and optimize indexing strategies for databases.

Community
Advanced
oguzhanguvenkayaoguzhanguvenkaya

Kubernetes Operations

Provide Kubernetes operational guidance for deploying, managing, and troubleshooting clusters.

Community
Advanced
HouseGarofaloHouseGarofalo
3

database-mode

Guide relational and NoSQL database design, modeling, and query optimization.

Official
Advanced
AndyAnh174AndyAnh174

sql-pro

Optimize SQL queries and schemas for cloud-native HTAP databases.

Community
Advanced