skills.rest
bcastelino
bcastelinoCOMMUNITY
Explore all skills by this author →
Website𝕏@cas7elinoGitHub

sql-pro

Optimize complex SQL queries using indexes and execution plans.

2|Updated Feb 6, 2026
Search Tags:#query optimization#analytics#database#sql#performance tuning#cloud databases
One-click install
npx skills add https://github.com/bcastelino/agent-skills-kit --skill sql-pro-bcastelino
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/bcastelino/agent-skills-kit/tree/main/skills/sql-pro
Command: npx skills add https://github.com/bcastelino/agent-skills-kit --skill sql-pro-bcastelino

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill empowers users to write complex SQL queries, optimize performance, and design advanced analytical patterns across a wide range of modern database systems and cloud platforms.

Core Features & Use Cases

  • Advanced Query Writing: Craft sophisticated SQL for complex analytical needs.
  • Performance Optimization: Tune queries for maximum efficiency using indexes and execution plans.
  • Cloud Database Expertise: Work with cloud-native databases like Snowflake, BigQuery, and Redshift.
  • Use Case: You need to write a complex analytical query involving window functions and CTEs for a large dataset in Google BigQuery and ensure it runs efficiently.

Quick Start

Use the sql-pro skill to optimize a complex analytical query for a billion-row 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 large datasets in cloud databases?▼

You can write complex SQL queries using window functions and CTEs for large datasets in cloud databases. This Skill provides expert SQL assistance to craft sophisticated analytical patterns and ensure efficient execution across modern database systems.

Does this SQL optimization approach work with Snowflake, BigQuery, and Redshift?▼

To optimize a complex analytical query, provide schema details, query plans, and statistics for effective performance tuning. The Skill uses these inputs to help you write efficient SQL, design advanced analytical patterns, and tune performance using indexes.

What's the best way to tune a slow analytical query in a hybrid OLTP/OLAP environment?▼

The best way to tune a slow analytical query in a hybrid OLTP/OLAP environment is to analyze execution plans and apply targeted indexes. This Skill helps you optimize complex queries and design efficient analytical patterns across these systems.

What schema details do I need to provide for SQL performance tuning?▼

You need to provide schema details, query plans, and statistics for effective SQL performance tuning. The Skill requires these inputs to accurately optimize complex queries and design advanced analytical patterns across modern database systems.

Why does my complex SQL query run slowly on a billion-row table?▼

Your complex SQL query runs slowly on a billion-row table due to unoptimized execution plans or missing indexes. This Skill helps you optimize performance by analyzing query plans and tuning indexes for large datasets in cloud-native databases.

Related Skills

Explore More Data & Analytics Skills→
gaebalaigaebalai
2

db-index-suggest

Analyzes SQL queries, slow query logs, and execution plans to suggest database index improvements.

Community
Advanced
cyyehcyyeh
1

sql-queries

Write performant SQL queries for analytical databases across multiple dialects.

Community
Advanced
delta-and-betadelta-and-beta

analyst-business-intelligence

Configure BI dashboards and reporting pipelines using Braze data exports.

Community
Intermediate
agentmattersagentmatters
3

clickhouse-io

Optimize ClickHouse analytics workflows with table design and query patterns.

Official
Advanced