skills.rest
saschadudkin-sketch
saschadudkin-sketchCOMMUNITY
Explore all skills by this author →
GitHub

sql-pro

Optimize SQL queries and design efficient database schemas.

Updated Mar 28, 2026
Search Tags:#database design#query optimization#sql#database schema#performance tuning
One-click install
npx skills add https://github.com/saschadudkin-sketch/rezidence4 --skill sql-pro-saschadudkin-sketch
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/saschadudkin-sketch/rezidence4/tree/main/.agents/skills/sql-pro
Command: npx skills add https://github.com/saschadudkin-sketch/rezidence4 --skill sql-pro-saschadudkin-sketch

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill unit is designed to solve complex SQL query optimization and database design challenges, providing tools and knowledge to enhance database performance and ensure data integrity.

Core Features & Use Cases

  • Query Optimization: Analyze and optimize SQL queries for performance.
  • Database Design: Assist in designing and refactoring database schemas for efficiency.
  • Use Case: If a user is experiencing slow database performance and needs help identifying and addressing the cause, the SQL Pro Skill can assist in creating optimized queries and indexing strategies.

Quick Start

Invoke the sql-pro skill with the specific query or schema issue you are facing for an analysis and optimization suggestion.

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 query performance and identify execution plan bottlenecks?▼

To optimize SQL query performance, you analyze execution plans to identify bottlenecks and apply indexing strategies. This troubleshoots slow database performance by restructuring queries and refining database schema design for efficiency.

What is the best way to design a database schema for efficiency and data integrity?▼

Designing a database schema for efficiency involves structuring tables to ensure data integrity while minimizing performance overhead. This requires analyzing data access patterns and applying normalization or refactoring techniques to optimize storage.

Does this SQL optimization approach support dialect-specific features for PostgreSQL and MySQL?▼

Yes, SQL optimization covers dialect-specific features for PostgreSQL, MySQL, SQL Server, and Oracle. It adjusts indexing strategies and query tuning to match the specific database management system and its unique execution plan behaviors.

How do I use window functions and CTEs to improve complex SQL queries?▼

Using window functions and CTEs improves complex SQL queries by structuring logic clearly for the execution planner. This technique helps avoid nested subqueries and enables more efficient data aggregation and sorting.

When should I apply indexing strategies to troubleshoot database performance issues?▼

You should apply indexing strategies when query plan analysis reveals full table scans or high sorting overhead. This targets performance bottlenecks by allowing the database management system to locate rows without scanning entire tables.

Related Skills

Explore More Software Engineering Skills→
TeiNamTeiNam
12

clickhouse-io

Provide ClickHouse best practices for schema design and query optimization workflows.

Community
Advanced
Mentor-WizardMentor-Wizard
10

postgresql-optimization

Analyze PostgreSQL queries with EXPLAIN ANALYZE and tune indexes and configuration.

Official
Advanced
EmmraanEmmraan

database-performance

Diagnose and optimize PostgreSQL database performance issues across the lifecycle.

Community
Advanced
HouseGarofaloHouseGarofalo
3

database-architect-agent

Guide database architecture, data modeling, schema optimization, and query performance tuning.

Official
Advanced