Can it analyze execution plans?

Yes, it is trained to interpret database execution plans to identify bottlenecks and suggest specific indexing or query rewrites to improve speed.

Does this skill support specific SQL dialects?

Yes, while it prioritizes standard SQL for portability, it is designed to assist with vendor-specific extensions and performance tuning across all major database systems.

Can it help with database schema design?

Absolutely. It provides guidance on normalization for data integrity and strategic denormalization for performance based on your specific application needs.

How does it improve query readability?

It advocates for modern practices like using Common Table Expressions (CTEs), explicit joins, and consistent formatting to make complex logic easier to maintain.

SQL Expert & Data Modeling

Name: SQL Expert & Data Modeling
Author: pointware

bypointware

0•

Database Management

Optimizes database performance through advanced query tuning, strategic indexing, and production-grade data modeling.

This skill transforms Claude into a database specialist capable of architecting efficient schemas and debugging complex performance bottlenecks. It focuses on modern SQL standards, utilizing Common Table Expressions (CTEs) and window functions to replace inefficient subqueries and self-joins. Whether you are building high-throughput data pipelines or optimizing slow analytics queries, this toolkit provides domain-specific guidance to balance data integrity with read/write performance across various database environments.

Key Features

010 GitHub stars

02Query performance tuning and execution plan analysis

03Strategic indexing strategies for high-scale databases

04Advanced SQL techniques including CTEs and window functions

05Best practices for handling nulls and three-valued logic

06Efficient data modeling and schema normalization

Use Cases

01Designing scalable database schemas for new applications

02Migrating complex subqueries into readable CTE-based logic

03Refactoring slow legacy queries for better execution times

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add pointware/custom-marketplace sql

For use in Claude.ai and ChatGPT

Download Skill