skills.rest
AndyAnh174
AndyAnh174COMMUNITY
Explore all skills by this author →
WebsiteGitHub

sql-pro

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

Updated Feb 26, 2026
Search Tags:#performance#database#optimization#sql#cloud#data-modeling#htap
One-click install
npx skills add https://github.com/AndyAnh174/wellness --skill sql-pro-andyanh174
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/AndyAnh174/wellness/tree/main/.agent/skills/sql-pro
Command: npx skills add https://github.com/AndyAnh174/wellness --skill sql-pro-andyanh174

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

SQL performance optimization challenges across cloud-native databases and HTAP environments require expert guidance to tune queries, design scalable schemas, and ensure efficient resource usage.

Core Features & Use Cases

  • Performance optimization: advanced query tuning, indexing strategies, and execution plan analysis for OLTP and OLAP workloads.
  • Data modeling: normalization/denormalization, dimensional modeling, and HTAP-friendly schemas.
  • Cloud-native architecture: deployment patterns, cross-region replication, and serverless considerations for cloud databases.
  • Use Case: Optimize a slow analytical query on Snowflake, BigQuery, or Redshift datasets using partitioning, window functions, and parallelism.

Quick Start

Provide a concise description of your current SQL workload and target platform to generate a tailored optimization plan.

Frequently Asked Questions about sql-pro

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

FAQPage Schema
How do I optimize slow analytical queries on cloud-native databases like Snowflake or BigQuery?▼

Optimize slow analytical queries on cloud-native databases by applying partitioning strategies, leveraging window functions, and configuring parallelism to refine execution plans and reduce compute overhead.

What is the best way to design data models for HTAP environments?▼

Design data models for HTAP environments by balancing normalization for OLTP transaction integrity with denormalization and dimensional modeling to support efficient OLAP analytical queries.

How do I analyze execution plans for SQL performance tuning?▼

Analyze execution plans for SQL performance tuning by evaluating indexing strategies and query structures to identify bottlenecks in OLTP or OLAP workloads and improve database throughput.

Does this approach work for serverless database deployment patterns?▼

Yes, this approach supports serverless database deployment patterns by addressing cross-region replication, cloud-native architecture considerations, and resource usage efficiency across OLTP and OLAP workloads.

When should I use partitioning instead of indexing for query optimization?▼

Use partitioning instead of indexing for query optimization when managing large analytical datasets on cloud platforms, where partition pruning reduces data scanned more effectively than secondary indexes.

Related Skills

Explore More Data & Analytics Skills→
hung-phanhung-phan

oltp-vs-olap

Analyze workload characteristics to select between OLTP and OLAP databases.

Community
Advanced
AmidVoshakulAmidVoshakul

database-optimizer

Analyze execution plans and implement indexing strategies to optimize database performance.

Community
Advanced
BoraPerusicBoraPerusic

sql-pro

Optimize SQL workloads for cloud-native OLTP/OLAP databases.

Community
Advanced
ArdurAIArdurAI
1

god-database-mastery

Guide database architecture, performance optimization, and ACID/BASE concepts.

Official
Advanced