skills.rest
act70255
act70255COMMUNITY
Explore all skills by this author →
GitHub

sql-pro

Optimize SQL queries and database performance in cloud-native environments.

Updated Mar 11, 2026
Search Tags:#performance tuning#database performance#sql optimization#sql query#cloud-native databases
One-click install
npx skills add https://github.com/act70255/SkillsBundle --skill sql-pro-act70255
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/act70255/SkillsBundle/tree/main/dev-python/skills/sql-pro
Command: npx skills add https://github.com/act70255/SkillsBundle --skill sql-pro-act70255

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides advanced SQL optimization and performance tuning capabilities for cloud-native databases, addressing the challenges of modern, complex data environments.

Core Features & Use Cases

  • Modern Database Systems: Expertise in Amazon Aurora, Google Cloud SQL, Azure SQL Database, Snowflake, Google BigQuery, and more.
  • Advanced Query Techniques: Utilizes complex window functions, recursive CTEs, and advanced JOIN techniques.
  • Performance Tuning: Offers comprehensive index strategy design, query plan analysis, and execution optimization.
  • Use Case: For instance, optimizing a complex analytical query for a billion-row table in Snowflake to improve performance.

Quick Start

Optimize the query performance for the 'sales_data' table in Snowflake.

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 query performance for a billion-row table in Snowflake?▼

SQL optimization for billion-row Snowflake tables requires analyzing query plans, designing index strategies, and applying advanced analytical query execution techniques to improve performance in cloud-native databases.

What is the best way to tune database performance in cloud-native OLTP systems?▼

Database performance tuning in cloud-native OLTP systems involves comprehensive index strategy design, query plan analysis, and execution optimization. It targets hybrid architectures and cloud databases like Amazon Aurora and Azure SQL Database to reduce latency.

How do I use recursive CTEs and window functions for SQL optimization?▼

Using recursive CTEs and complex window functions for SQL optimization allows you to structure complex analytical queries efficiently. These advanced SQL techniques are crucial for improving execution speed in large-scale cloud database systems.

Does this SQL optimization approach work with both Amazon Aurora and Google BigQuery?▼

Yes, this SQL optimization approach works with Amazon Aurora, Google BigQuery, Google Cloud SQL, Azure SQL Database, and Snowflake. It provides comprehensive performance tuning across modern cloud-native database systems and hybrid architectures.

When do I need advanced SQL techniques for cloud-native databases?▼

You need advanced SQL techniques for cloud-native databases when facing complex data environments that require sophisticated query optimization, performance tuning, and hybrid architecture support. This is essential for managing modern OLTP and OLAP systems efficiently.

Related Skills

Explore More Software Engineering Skills→
bcastelinobcastelino
2

sql-pro

Optimize complex SQL queries using indexes and execution plans.

Community
Advanced
alexander-danilenkoalexander-danilenko
14

sql-pro

Optimize slow SQL queries and schemas with EXPLAIN plan analysis and index recommendations.

Community
Advanced
thehivegroup-aithehivegroup-ai

postgres-standards

Manage PostgreSQL schema design, migrations, and query optimization with psycopg2.

Official
Intermediate
Orvanta-CloudOrvanta-Cloud

write-script-mysql

Create, preview, and execute MySQL query scripts programmatically.

Official
Basic