sql-pro

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

3|1|Updated Feb 20, 2026

Search Tags:#database #postgresql #optimization #sql #performance tuning #mysql #query design

Ready to run

npx skills add https://github.com/Harmitx7/tribunal-kit --skill sql-pro-harmitx7

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/Harmitx7/tribunal-kit/tree/main/.agent/skills/sql-pro
Command: npx skills add https://github.com/Harmitx7/tribunal-kit --skill sql-pro-harmitx7

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the complexity and performance challenges of writing and optimizing SQL queries across diverse database systems, ensuring efficient and robust data management.

Core Features & Use Cases

Complex Query Design: Develop advanced SQL queries using CTEs, window functions, and platform-specific features.
Performance Optimization: Analyze and tune query execution plans, optimize indexing strategies, and prevent deadlocks.
Schema Architecture: Design efficient database schemas and implement data warehousing patterns.
Use Case: Optimize a slow-running PostgreSQL query by analyzing its execution plan, adding appropriate indexes, and rewriting it using window functions for better performance.

Quick Start

Use the sql-pro skill to optimize the provided 'sales_report_query.sql' 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 a slow PostgreSQL query using execution plans?▼

PostgreSQL query optimization involves analyzing execution plans, rewriting queries with window functions, and implementing appropriate indexing strategies to improve database performance and scalability.

What is the best way to design complex SQL queries across different database systems?▼

Complex SQL query design leverages CTEs, window functions, and platform-specific features while adhering to ANSI SQL standards to ensure compatibility and efficiency across major database systems.

Does SQL optimization support both MySQL and Oracle databases?▼

SQL optimization supports major database systems including MySQL, Oracle, PostgreSQL, and SQL Server, applying platform-specific tuning alongside general ANSI SQL standards for efficient data management.

How do I prevent deadlocks and improve database performance tuning?▼

Database performance tuning analyzes query execution plans, optimizes indexing strategies, and prevents deadlocks to ensure robust data management and efficient query execution across diverse systems.

When do I need to redesign database schema architecture for data warehousing?▼

Database schema architecture redesign is needed when implementing data warehousing patterns to ensure efficient data management, robust performance, and scalability across diverse database platforms.