sql-expert

Name: sql-expert
Availability: InStock
Author: icartsh

Write optimized SQL queries and schemas across PostgreSQL, MySQL, SQLite, and SQL Server.

4|Updated Dec 7, 2025

Search Tags:#query optimization #indexing #schema design #database #migrations #sql

Ready to run

npx skills add https://github.com/icartsh/icartsh_plugin --skill sql-expert-icartsh

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sql-expert
Source: https://github.com/icartsh/icartsh_plugin/tree/main/icartsh-plugin/skills/sql-expert
Command: npx skills add https://github.com/icartsh/icartsh_plugin --skill sql-expert-icartsh

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires SQLAlchemy, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides expert guidance to craft complex SQL across PostgreSQL, MySQL, SQLite, and SQL Server, covering advanced query patterns, data modeling, and performance tuning.

Core Features & Use Cases

Query writing: JOINs, CTEs, window functions, and recursive queries to fetch and compute insights.
Query optimization: EXPLAIN analysis, indexing strategies, and performance improvement patterns.
Schema design & migrations: Normalization and safe migration patterns to evolve your data model.

Quick Start

Use this Skill to generate and optimize a representative SQL query against your database; for example, ask: "Show me a report of total revenue per customer for the last month, with a computed running total."

Frequently Asked Questions about sql-expert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I optimize slow SQL queries?▼

Query optimization uses EXPLAIN analysis to identify bottlenecks, then applies indexing strategies and query restructuring—such as rewriting JOINs or adding window functions—to reduce execution time and resource consumption across PostgreSQL, MySQL, SQLite, and SQL Server.

What's the best way to design a normalized database schema?▼

Schema design applies normalization principles to eliminate redundancy and enforce data integrity, then implements appropriate indexing strategies and migration patterns to support complex queries like JOINs, CTEs, and subqueries without performance degradation.

How do I write complex SQL queries with JOINs and window functions?▼

Complex query construction combines JOINs, subqueries, CTEs, and window functions to fetch and compute insights from multiple tables, with parameterized queries and transaction handling ensuring correctness across PostgreSQL, MySQL, SQLite, and SQL Server.

Can I safely migrate my database schema without downtime?▼

Safe migration patterns evolve your data model incrementally using appropriate transaction handling and isolation levels, allowing schema changes to existing production databases while maintaining data integrity and query compatibility.

Does this cover query optimization for large datasets?▼

Yes—indexing strategies, EXPLAIN analysis, and query restructuring techniques address data-intensive applications, enabling efficient retrieval and computation across millions of rows using JOINs, window functions, and CTEs in PostgreSQL, MySQL, SQLite, and SQL Server.