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

Ready to run

npx skills add https://github.com/fuziix266/mavoo-laminas --skill sql-pro-fuziix266

💬 Prompt for ChatGPT / Claude Chat▼

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.