skills.rest
404kidwiz
404kidwizCOMMUNITY
Explore all skills by this author →
𝕏@404kidwiz2GitHub

sql-pro

Optimizes SQL queries and designs database schemas for multiple platforms.

Updated Aug 23, 2026
Search Tags:#schema design#database#optimization#sql#performance tuning#administration
One-click install
npx skills add https://github.com/404kidwiz/claude-supercode-skills --skill sql-pro-404kidwiz
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/404kidwiz/claude-supercode-skills/tree/main/sql-pro-skill
Command: npx skills add https://github.com/404kidwiz/claude-supercode-skills --skill sql-pro-404kidwiz

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses complex SQL development needs, including query optimization, database schema design, performance tuning, and administration across multiple database platforms.

Core Features & Use Cases

  • Query Optimization: Analyzes and rewrites slow SQL queries for significant performance gains.
  • Database Design: Designs efficient, scalable database schemas and indexes.
  • Cross-Platform Expertise: Works with PostgreSQL, MySQL, SQL Server, and Oracle.
  • Use Case: A user has a critical report that takes 10 minutes to run. They can use this skill to analyze the query, identify bottlenecks, and provide an optimized version that runs in seconds.

Quick Start

Use the sql-pro skill to optimize the provided slow-running SQL query.

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 for better performance?▼

Database schema design creates efficient, scalable relational structures by defining normalized tables and strategic indexes, ensuring optimal data integrity and query performance across PostgreSQL, MySQL, SQL Server, and Oracle.

What is the best way to tune database performance across multiple platforms?▼

The best way to tune database performance across multiple platforms is applying ANSI SQL standards alongside platform-specific optimizations for PostgreSQL, MySQL, SQL Server, and Oracle to maximize efficiency and architecture scalability.

How do I design a scalable database schema and indexes?▼

Database schema design creates efficient, scalable relational structures by defining normalized tables and strategic indexes, ensuring optimal data integrity and query performance across PostgreSQL, MySQL, SQL Server, and Oracle.

Does this SQL optimization approach work with PostgreSQL and MySQL?▼

To optimize slow SQL queries, analyze execution plans to identify bottlenecks like missing indexes, then rewrite the query using ANSI SQL standards and platform-specific tuning for significant performance gains and scalability.

Why does my complex SQL report take so long to run?▼

Complex SQL reports run slowly due to unoptimized query design, missing indexes, or inefficient joins, requiring expert analysis and rewriting to identify bottlenecks and provide an optimized version that runs in seconds.

Related Skills

Explore More Software Engineering Skills→
saajunaidsaajunaid

database-design

Design database schemas, migrations, and optimization patterns for relational and NoSQL databases.

Community
Advanced
h4vzzh4vzz
33

sql-query-generation

Generate optimized SQL queries from natural language with EXPLAIN analysis.

Community
Intermediate
adiytharpansaadiytharpansa

database-operator

Manage queries, schemas, and performance across SQL and NoSQL databases.

Community
Intermediate
Harmitx7Harmitx7
3

sql-pro

Design and optimize SQL queries across PostgreSQL, MySQL, SQL Server, and Oracle.

Community
Advanced