skills.rest
belokonm
belokonmCOMMUNITY
Explore all skills by this author →
GitHub

sql-pro

Analyze and optimize SQL queries and schemas across PostgreSQL, MySQL, SQL Server, and Oracle.

8|11|Updated Feb 15, 2026
Search Tags:#performance#database#postgresql#sql#mysql#query-optimization#schema-design
One-click install
npx skills add https://github.com/belokonm/claude-supercode-skills --skill sql-pro-belokonm
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/belokonm/claude-supercode-skills/tree/main/sql-pro-skill
Command: npx skills add https://github.com/belokonm/claude-supercode-skills --skill sql-pro-belokonm

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Write robust, high-performance SQL across PostgreSQL, MySQL, SQL Server, and Oracle by combining design, optimization, and cross-platform patterns to reduce latency and improve maintainability.

Core Features & Use Cases

  • Schema analysis and normalization guidance for scalable databases.
  • Query optimization, indexing strategies, and execution plan interpretation.
  • Cross-platform migrations and compatibility checks for ANSI SQL benchmarks.
  • Real-world use: optimize a slow join-heavy query on Postgres or migrate a schema between DBs.

Quick Start

Analyze a slow query and generate an optimization plan for PostgreSQL.

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 and analyze execution plans for PostgreSQL?▼

Optimize slow SQL queries by analyzing execution plans, applying indexing strategies, and enforcing platform-specific best practices for PostgreSQL to reduce latency and improve maintainability in production environments.

What is the best way to migrate a database schema across MySQL and SQL Server?▼

Migrate database schemas across MySQL, SQL Server, Oracle, and PostgreSQL by running cross-platform compatibility checks against ANSI SQL benchmarks to ensure data integrity and validate structural equivalence.

Does this approach support schema design and normalization for high-performance databases?▼

Schema design and normalization guidance supports scalable databases by analyzing existing architectures and enforcing best practices to improve data integrity and query performance across multiple database platforms.

How do I interpret execution plans and apply indexing strategies for complex query optimization?▼

Interpret execution plans and apply indexing strategies for complex query optimization by rigorously validating data integrity, reducing latency on join-heavy queries, and enforcing cross-platform best practices.

Can I use this for performance tuning on Oracle and SQL Server in production environments?▼

Performance tuning applies to Oracle, SQL Server, PostgreSQL, and MySQL in production environments by interpreting execution plans, validating indexing strategies, and enforcing platform-specific optimizations for complex query design.

Related Skills

Explore More Software Engineering Skills→
EanLeeEanLee

sql-optimization-patterns

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

Community
Advanced
agnaldo4jagnaldo4j
1

db-migrations

Manage PostgreSQL schema lifecycles with versioned Flyway migrations and HikariCP pooling.

Community
Advanced
HieubkavHieubkav

database-performance

Analyze database indexes and query execution plans to recommend optimizations.

Community
Advanced
cyperx84cyperx84
2

Query Optimization

Analyze EXPLAIN plans and recommend indexing strategies for SQL queries.

Community
Advanced