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

0•

Database Management

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

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

01Relational schema design with 1NF, 2NF, and 3NF normalization

02Performance tuning via EXPLAIN plan analysis and indexing strategies

03Multi-dialect support for PostgreSQL, MySQL, SQLite, and SQL Server

04Safe migration patterns for zero-downtime database changes

050 GitHub stars

06Advanced query construction using JOINs, CTEs, and window functions

Use Cases

01Creating safe, rollback-ready migration scripts for production environments

02Architecting complex database schemas for new applications or features

03Refactoring slow-performing legacy queries into optimized, indexed versions

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add icartsh/icartsh_plugin sql-expert

For use in Claude.ai and ChatGPT

Download Skill