skills.rest
mtsatryan
mtsatryanCOMMUNITY
Explore all skills by this author →
GitHub

sql-pro

Optimize SQL queries and database design across PostgreSQL, MySQL, SQL Server, and Oracle.

1|Updated Apr 23, 2026
Search Tags:#indexing#postgresql#sql#mysql#performance-tuning#query-optimization#execution-plans
One-click install
npx skills add https://github.com/mtsatryan/openclaw-ai-agents --skill sql-pro-mtsatryan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/mtsatryan/openclaw-ai-agents/tree/main/sql-pro
Command: npx skills add https://github.com/mtsatryan/openclaw-ai-agents --skill sql-pro-mtsatryan

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Complex SQL queries and data models can bottleneck performance and hinder scalable data access across multiple database platforms. This skill provides systematic analysis, rewriting, and optimization to achieve faster, more reliable queries.

Core Features & Use Cases

  • Query optimization and execution plan analysis for PostgreSQL, MySQL, SQL Server, and Oracle.
  • Intelligent indexing and data modeling guidance to reduce latency and improve throughput.
  • Cross-platform standards enforcement and safe migrations for production systems.

Quick Start

Provide a representative schema and a slow query to optimize.

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 in PostgreSQL or MySQL?▼

Optimize slow SQL queries by analyzing execution plans, rewriting complex statements, and applying intelligent indexing strategies to reduce latency and improve throughput. Provide your schema and slow query to start.

What is the best way to analyze an execution plan for large-scale workloads?▼

Analyze execution plans by evaluating query paths, enforcing ANSI SQL compliance, and selecting indexing strategies to handle large-scale workloads efficiently across PostgreSQL, MySQL, SQL Server, and Oracle.

Does this SQL query optimization approach work with both SQL Server and Oracle?▼

Yes, this query optimization approach supports SQL Server and Oracle, alongside PostgreSQL and MySQL, handling schema review, query tuning, indexing, and data model improvements across platforms.

How do I improve database design and schema review for scalable data access?▼

Improve database design by conducting schema reviews, defining integrity constraints, and applying intelligent data modeling guidance to ensure reliable, scalable data access across production systems.

When do I need to enforce ANSI SQL compliance during database migrations?▼

Enforce ANSI SQL compliance during database migrations to ensure safe transitions across production systems, maintaining data integrity constraints and preventing platform-specific query bottlenecks.

Related Skills

Explore More Software Engineering Skills→
EanLeeEanLee

sql-optimization-patterns

Analyze EXPLAIN output and implement indexing strategies for SQL query optimization.

Community
Advanced
wonderslifewonderslife
13

expert-performance

Diagnose bottlenecks and generate optimization plans with measurable baselines.

Community
Advanced
dige04dige04

databases

Analyze and optimize MongoDB and PostgreSQL performance across production workloads.

Community
Intermediate
brenordvbrenordv

nosql-database

Model NoSQL database systems using query-driven structures and horizontal scalability.

Community
Advanced