Can this skill help with database performance tuning?

Yes, it includes patterns for query analysis using EXPLAIN, indexing strategies, and optimized join structures to reduce latency.

Is data integrity addressed in the design patterns?

Yes, the skill emphasizes the use of primary keys, foreign key constraints, check constraints, and safe transaction patterns to ensure data consistency.

Does it cover complex data relationships?

Absolutely, it provides templates for one-to-many, many-to-many junction tables, and recursive CTEs for hierarchical data structures.

Which SQL dialects does this skill support?

This skill provides patterns compatible with major relational databases, with specific advanced syntax examples for PostgreSQL and MySQL.

SQL Query & Schema Design

Name: SQL Query & Schema Design
Author: miles990

bymiles990

•

Gestión de Bases de Datos

Provides expert SQL patterns for complex database querying, efficient schema design, and performance optimization.

This skill empowers Claude to act as a database specialist, offering a comprehensive library of SQL implementation patterns across major dialects like PostgreSQL and MySQL. It covers everything from fundamental CRUD operations and complex joins to advanced window functions, recursive CTEs, and robust schema design with constraints and indexing. Whether you are architecting a new database, writing complex analytical reports, or optimizing slow-running queries, this skill ensures best practices for data integrity and performance through standardized patterns.

Características Principales

01Advanced analytical patterns including Window Functions and Common Table Expressions (CTEs)

02Standardized templates for complex joins, subqueries, and lateral joins

03Performance optimization techniques using indexing strategies and EXPLAIN ANALYZE

041 GitHub stars

05Safe data manipulation patterns including bulk inserts and conflict handling (Upsert)

06Best practices for relational schema design, constraints, and many-to-many relationships

Casos de Uso

01Generating complex analytical reports involving hierarchical data or running totals

02Designing and implementing normalized database schemas for new application features

03Refactoring and optimizing existing slow queries for better production performance

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add miles990/claude-software-skills sql

For use in Claude.ai and ChatGPT

Download Skill