skills.rest
BoraPerusic
BoraPerusicCOMMUNITY
Explore all skills by this author →
GitHub

sql-pro

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

Updated Apr 12, 2026
Search Tags:#performance#optimization#sql#cloud#modeling#databases#htap
One-click install
npx skills add https://github.com/BoraPerusic/agents --skill sql-pro-boraperusic
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/BoraPerusic/agents/tree/main/skills/to%20try/sql-pro
Command: npx skills add https://github.com/BoraPerusic/agents --skill sql-pro-boraperusic

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Helps database professionals optimize SQL workloads in cloud-native environments, addressing performance bottlenecks, complex query tuning, and HTAP architecture challenges.

Core Features & Use Cases

  • Design and optimize SQL schemas for OLTP/OLAP workloads across cloud platforms
  • Analyze and tune queries with EXPLAIN plans, indexing strategies, and partitioning
  • Best practices for HTAP configurations and cross-database integration

Quick Start

Run a sample performance audit on a cloud-native SQL instance to generate an optimized query 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 SQL workloads for cloud-native databases?▼

Optimize SQL workloads by analyzing EXPLAIN plans, applying indexing strategies, and partitioning data. This process targets performance bottlenecks and schema design specifically for OLTP/OLAP environments across cloud platforms.

What is HTAP architecture and when do I need it for SQL performance tuning?▼

HTAP (Hybrid Transactional/Analytical Processing) architecture combines OLTP and OLAP workloads in a single system. You need HTAP configurations when requiring real-time analytics on transactional data without moving data between separate databases.

How do I analyze query plans to fix performance bottlenecks in cloud databases?▼

Analyze query plans by running EXPLAIN outputs to identify execution inefficiencies. Use this analysis to implement indexing strategies, tune queries, and refine schema design for cross-cloud deployment considerations.

Can I use this for both OLTP and OLAP schema design across different cloud platforms?▼

Yes, you can design and optimize SQL schemas for both OLTP and OLAP workloads. It addresses cross-cloud deployment considerations, ensuring data modeling and performance tuning adapt to diverse cloud-native database environments.

What's the best way to tune SQL queries for cross-database integration in HTAP environments?▼

The best way to tune SQL queries for HTAP environments is applying indexing strategies and partitioning while analyzing EXPLAIN plans. This approach handles cross-database integration and balances transactional with analytical processing loads.

Related Skills

Explore More Data & Analytics Skills→
EstomEstom

sql-pro

Optimize SQL queries and database schemas for PostgreSQL, MySQL, SQL Server, and Oracle.

Community
Advanced
Lautaro073Lautaro073

sql-pro

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

Community
Advanced
AndyAnh174AndyAnh174

sql-pro

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

Community
Advanced
bcastelinobcastelino
2

sql-pro

Optimize complex SQL queries using indexes and execution plans.

Community
Advanced