How does it handle complex data transformations?

The skill utilizes modern SQL features like Window Functions and Common Table Expressions (CTEs) to create readable and efficient multi-step data transformations.

Is it suitable for database schema design?

Yes, it provides comprehensive guidance on normalization for data integrity and strategic denormalization for read-heavy performance requirements.

Does this skill support specific SQL dialects?

Yes, while the skill prioritizes standard SQL for portability, it is designed to handle vendor-specific extensions and performance nuances across major platforms like PostgreSQL, MySQL, and SQL Server.

Does it follow security best practices?

Yes, it emphasizes explicit joins, proper data types, and constraint management to ensure data integrity and prevent common pitfalls.

Can it help me fix slow-running queries?

Absolutely. The skill specializes in identifying bottlenecks, analyzing execution plans, and suggesting refactors or indexing strategies to optimize performance.

SQL Development & Optimization

Name: SQL Development & Optimization
Author: mrlm-xyz

bymrlm-xyz

•

Database Management

Optimizes SQL development through expert query tuning, strategic indexing, and robust data modeling for high-performance analytics and pipelines.

This skill transforms Claude into a senior database engineer, providing deep expertise in SQL development and database architecture. It focuses on creating efficient, maintainable code for complex data pipelines while emphasizing execution plan analysis and strategic indexing to balance read and write performance. Whether you are refactoring legacy queries or designing new schemas from scratch, this skill ensures best practices such as Common Table Expressions (CTEs), window functions, and explicit join logic are utilized to handle production-scale data volumes with precision.

Key Features

01Advanced query performance optimization and execution plan analysis

02Implementation of complex analytical patterns using Window Functions and CTEs

03Strategic indexing strategies to minimize write overhead

04Expert data modeling including normalization and performance denormalization

05Explicit handling of three-valued logic and NULL value constraints

0621 GitHub stars

Use Cases

01Designing scalable database schemas for high-traffic applications

02Building maintainable SQL transformation layers for data analytics pipelines

03Refactoring slow-running legacy queries to improve execution speed

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add mrlm-xyz/demo-claude-marketplace sql

For use in Claude.ai and ChatGPT

Download Skill