Does SQL Pro support specific database dialects?

Yes, it supports major engines including PostgreSQL, MySQL, and SQL Server, handling specific syntax nuances and feature availability for each.

How does it handle complex data analysis?

It leverages advanced SQL features like Common Table Expressions (CTEs) and window functions to perform complex aggregations and analytics efficiently using set-based operations.

Can it help with performance tuning for slow queries?

Absolutely. It analyzes execution plans (EXPLAIN) to identify bottlenecks like sequential scans and recommends specific indexing strategies or query rewrites.

Is it capable of designing new database architectures?

Yes, it can design fully normalized schemas from scratch, defining tables, relationships, keys, and constraints based on your data requirements.

SQL Pro

Name: SQL Pro
Author: newkayak12

bynewkayak12

0•

Database Management

Optimizes complex SQL queries, designs normalized database schemas, and performs dialect migrations across major database engines.

SQL Pro is a specialized Claude Code skill designed for high-performance database engineering. It assists developers in authoring complex joins, CTEs, window functions, and recursive queries while ensuring peak performance through execution plan analysis and indexing strategies. Whether you are normalizing a legacy schema, migrating between PostgreSQL and MySQL, or fixing slow-running queries that cause full table scans, this skill provides production-grade SQL implementations and detailed optimization rationale to ensure sub-100ms targets.

Key Features

01Schema Design & Normalization

02Dialect Migration (PostgreSQL, MySQL, SQL Server)

03EXPLAIN Plan Analysis & Query Tuning

04Advanced Query Authoring (CTEs, Window Functions, Recursion)

05Indexing Strategy Recommendation

060 GitHub stars

Use Cases

01Designing a scalable, normalized database schema for new application features.

02Migrating existing SQL queries and logic between different database engines.

03Rewriting slow analytical queries to eliminate full table scans and improve execution time.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add newkayak12/claude-skills sql-pro

For use in Claude.ai and ChatGPT