skills.rest
Harmitx7
Harmitx7COMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/Harmitx7/tribunal-kit --skill sql-pro-harmitx7
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
fuziix266fuziix266

sql-pro

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

Community
Advanced
pointwarepointware

sql

Optimize slow SQL queries with indexing and schema guidance.

Community
Advanced
Mentor-WizardMentor-Wizard
10

postgresql-optimization

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

Official
Advanced
AndrejMX13AndrejMX13

sql-pro

Optimize SQL queries and design schemas for relational databases.

Community
Advanced