skills.rest
AmidVoshakul
AmidVoshakulCOMMUNITY
Explore all skills by this author →
GitHub

sql-pro

Analyze SQL execution plans and optimize indexing strategies for databases.

Updated Dec 29, 2025
Search Tags:#performance#analytics#database#optimization#sql#modeling#cloud-native
One-click install
npx skills add https://github.com/AmidVoshakul/chatorai --skill sql-pro-amidvoshakul
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/AmidVoshakul/chatorai/tree/main/assets/skills/sql-pro
Command: npx skills add https://github.com/AmidVoshakul/chatorai --skill sql-pro-amidvoshakul

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill addresses the complexity of managing high-performance database systems, helping you optimize slow queries, design scalable schemas, and implement robust data architectures.

Core Features & Use Cases

  • Performance Tuning: Analyze execution plans and optimize indexing strategies for massive datasets.
  • Advanced Modeling: Design efficient schemas for both OLTP and OLAP workloads, including star and snowflake patterns.
  • Use Case: Use this skill to refactor a slow-running analytical query on a billion-row table or to design a multi-tenant database schema that ensures GDPR compliance.

Quick Start

Use the sql-pro skill to analyze the provided query execution plan and suggest specific index improvements for the users table.

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 SQL queries on massive datasets?▼

Optimizing slow SQL queries involves analyzing execution plans and refining indexing strategies for massive datasets. This process identifies performance bottlenecks to ensure scalable data retrieval.

What is the best way to design a scalable database schema for OLAP workloads?▼

Designing scalable database schemas for OLAP workloads involves implementing star or snowflake patterns. This data modeling approach structures analytical data efficiently for high-performance querying.

Can I use this approach to design a multi-tenant database schema with GDPR compliance?▼

Yes, designing a multi-tenant database schema with GDPR compliance is achievable through advanced data modeling. This ensures robust data architectures maintain security compliance across isolated tenants.

Do I need workload statistics and schema definitions for SQL performance tuning?▼

Yes, SQL performance tuning requires access to schema definitions, query execution plans, and workload statistics. These inputs are essential to accurately analyze and deliver scalable data solutions.

Does SQL performance optimization work for cloud-native and hybrid environments?▼

SQL performance optimization works effectively for cloud-native and hybrid environments. It specifically tunes complex queries and database schemas to handle high-performance data workloads across distributed infrastructures.

Related Skills

Explore More Data & Analytics Skills→
Veloxia-agencyVeloxia-agency

database-designer

Design and optimize database schemas, indexes, and migrations.

Community
Advanced
oborchersoborchers
28

security-monitoring-from-day-one

Deploy managed cloud security services for threat detection and compliance scanning.

Community
Advanced
teradata-labsteradata-labs
7

monitor-workloads

Monitor Teradata workload definitions, query distribution, and TASM statistics.

Official
Advanced
aegnticaegntic
4

postgres-expert

Optimize PostgreSQL queries, indexing, schema design, and database administration.

Community
Advanced