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

•

数据库管理

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.

主要功能

Advanced analytical patterns including Window Functions and Common Table Expressions (CTEs)
Standardized templates for complex joins, subqueries, and lateral joins
Performance optimization techniques using indexing strategies and EXPLAIN ANALYZE
1 GitHub stars
Safe data manipulation patterns including bulk inserts and conflict handling (Upsert)
Best practices for relational schema design, constraints, and many-to-many relationships

使用场景

Generating complex analytical reports involving hierarchical data or running totals
Designing and implementing normalized database schemas for new application features
Refactoring and optimizing existing slow queries for better production performance

关于

主要功能

Advanced analytical patterns including Window Functions and Common Table Expressions (CTEs)
Standardized templates for complex joins, subqueries, and lateral joins
Performance optimization techniques using indexing strategies and EXPLAIN ANALYZE
1 GitHub stars
Safe data manipulation patterns including bulk inserts and conflict handling (Upsert)
Best practices for relational schema design, constraints, and many-to-many relationships

使用场景

Generating complex analytical reports involving hierarchical data or running totals
Designing and implementing normalized database schemas for new application features
Refactoring and optimizing existing slow queries for better production performance