skills.rest
fuziix266
fuziix266COMMUNITY
Explore all skills by this author →
WebsiteGitHub

sql-pro

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

Updated Dec 22, 2025
Search Tags:#schema design#database#optimization#sql#performance tuning#query analysis
One-click install
npx skills add https://github.com/fuziix266/mavoo-laminas --skill sql-pro-fuziix266
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/fuziix266/mavoo-laminas/tree/main/instrucciones/.agents/skills/sql-pro
Command: npx skills add https://github.com/fuziix266/mavoo-laminas --skill sql-pro-fuziix266

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines complex database tasks, from optimizing slow queries and designing robust schemas to fine-tuning database performance for maximum efficiency.

Core Features & Use Cases

  • Query Optimization: Analyze and rewrite inefficient SQL queries for faster execution.
  • Database Schema Design: Create well-structured, normalized, and performant database schemas.
  • Performance Tuning: Identify and resolve bottlenecks in database operations, indexing, and configuration.
  • Use Case: You have a critical report that takes minutes to run. Use this Skill to analyze its execution plan, suggest index improvements, and rewrite the query to return results in seconds.

Quick Start

Use the sql-pro skill to optimize the following PostgreSQL query: SELECT * FROM users WHERE last_login < NOW() - INTERVAL '1 year';

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?▼

To optimize slow SQL queries, you must analyze the execution plan to identify bottlenecks, implement targeted indexing strategies, and rewrite complex query patterns for faster execution across major RDBMS like PostgreSQL and MySQL.

What is the best way to design a normalized database schema?▼

Database schema design involves creating well-structured, normalized tables that eliminate data redundancy. Proper schema design ensures data integrity while structuring relationships to support performant query execution patterns.

Can I analyze query execution plans for SQL Server using this approach?▼

Yes, query plan analysis supports major RDBMS including SQL Server. It examines how the SQL execution engine processes queries, revealing performance metrics to guide indexing and query rewriting decisions.

Why does my database query take minutes to run and how do I fix it?▼

A database query takes minutes due to missing indexes, inefficient complex query patterns, or poor schema normalization. Fix it by analyzing the execution plan, adding proper indexes, and rewriting the query to return results in seconds.

Related Skills

Explore More Software Engineering Skills→
GDSDNGDSDN
3

db-explain

Analyze PostgreSQL query plans with EXPLAIN ANALYZE to identify bottlenecks.

Community
Advanced
HieubkavHieubkav

database-performance

Analyze database indexes and query execution plans to recommend optimizations.

Community
Advanced
brianoniealbrianonieal

performance

Audit frontend Lighthouse scores, backend latency, and database query performance.

Community
Intermediate
cyperx84cyperx84
2

Query Optimization

Analyze EXPLAIN plans and recommend indexing strategies for SQL queries.

Community
Advanced