Which database systems does the SQL Expert skill support?

The skill provides comprehensive support for PostgreSQL, MySQL/MariaDB, SQLite, and SQL Server, including dialect-specific syntax and features.

Does it provide guidance on database security?

Absolutely. It emphasizes critical security practices such as using parameterized queries to prevent SQL injection and implementing proper transaction isolation.

Can this skill help me fix slow database queries?

Yes, it specializes in optimization by analyzing EXPLAIN plans, identifying sequential scans, and recommending appropriate indexing or query refactoring.

Can I use this skill to design a database from scratch?

Yes, it assists with full schema design, applying normalization principles (1NF, 2NF, 3NF) and establishing correct one-to-many or many-to-many relationships.

How does it handle database migrations?

The skill suggests safe migration patterns, such as multi-step processes for adding non-null columns and batching updates to avoid downtime on large tables.

SQL Expert

Name: SQL Expert
Author: icartsh

byicartsh

Database Management

Simplifies complex SQL query writing, database schema design, and performance optimization across major relational database systems.

About

The SQL Expert skill transforms Claude into a specialized database consultant capable of handling advanced architectural and optimization tasks. It provides domain-specific guidance for PostgreSQL, MySQL, SQLite, and SQL Server, helping developers write sophisticated queries using CTEs and window functions, design highly normalized schemas, and diagnose performance bottlenecks using execution plans. By incorporating best practices for security, transactions, and zero-downtime migrations, this skill ensures your database layer is robust, scalable, and efficient.

Key Features

Relational schema design with 1NF, 2NF, and 3NF normalization
Performance tuning via EXPLAIN plan analysis and indexing strategies
Multi-dialect support for PostgreSQL, MySQL, SQLite, and SQL Server
Safe migration patterns for zero-downtime database changes
0 GitHub stars
Advanced query construction using JOINs, CTEs, and window functions

Use Cases

Creating safe, rollback-ready migration scripts for production environments
Architecting complex database schemas for new applications or features
Refactoring slow-performing legacy queries into optimized, indexed versions

About

Key Features

Relational schema design with 1NF, 2NF, and 3NF normalization
Performance tuning via EXPLAIN plan analysis and indexing strategies
Multi-dialect support for PostgreSQL, MySQL, SQLite, and SQL Server
Safe migration patterns for zero-downtime database changes
0 GitHub stars
Advanced query construction using JOINs, CTEs, and window functions

Use Cases

Creating safe, rollback-ready migration scripts for production environments
Architecting complex database schemas for new applications or features
Refactoring slow-performing legacy queries into optimized, indexed versions