Does this skill provide schema design advice?

Absolutely. It covers everything from standard normalization to advanced data warehousing patterns like Star Schemas and Slowly Changing Dimensions (SCD).

Can it help with complex SQL features like window functions?

Yes, SQL Pro specializes in advanced patterns including window functions, Common Table Expressions (CTEs), and recursive queries for complex data analysis.

How does this skill improve query performance?

It uses a structured workflow that includes execution plan analysis, set-based operation design, and the implementation of covering indexes to achieve sub-100ms targets.

Which database platforms does the SQL Pro skill support?

The skill provides expert guidance for all major database systems, specifically focusing on PostgreSQL, MySQL, SQL Server, and Oracle.

SQL Pro & Database Optimizer

Name: SQL Pro & Database Optimizer
Author: piotroq

bypiotroq

0•

データベース管理

Optimizes complex SQL queries and designs high-performance database schemas across all major database platforms.

SQL Pro is a specialized senior-level engineering skill designed to help Claude architect, optimize, and debug complex database environments. It provides expert-level guidance for PostgreSQL, MySQL, SQL Server, and Oracle, focusing on achieving sub-100ms query targets through deep execution plan analysis, strategic indexing, and advanced SQL patterns like CTEs and window functions. Whether you are migrating legacy queries, implementing data warehousing patterns, or troubleshooting performance bottlenecks, this skill ensures your database layer remains scalable and efficient.

主な機能

01Advanced query optimization using EXPLAIN and ANALYZE plans

02Strategic indexing and covering index design to eliminate table scans

030 GitHub stars

04Cross-platform dialect migration and platform-specific tuning

05Schema design for both OLTP and OLAP (Star Schema, SCD) environments

06Implementation of complex CTEs, window functions, and recursive patterns

ユースケース

01Designing scalable database schemas and normalization strategies for new features

02Refactoring slow-running legacy queries to meet high-performance benchmarks

03Tuning database performance by identifying and resolving indexing gaps

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add piotroq/adwokat-trzebnica-html-to-php-com sql-pro

For use in Claude.ai and ChatGPT

Download Skill