Sql Pro

What it does

Sql Pro provides expert SQL development capabilities across major database platforms including PostgreSQL, MySQL, SQL Server, and Oracle. It specializes in complex query design, performance optimization, and database architecture, adhering to ANSI SQL standards and platform-specific optimizations for efficiency and scalability. This skill helps translate business requirements into efficient SQL queries and addresses cross-platform compatibility issues.

When to use it

• Writing complex SQL queries involving joins, Common Table Expressions (CTEs), window functions, or recursive queries.
• Designing new database schemas or refactoring existing ones.
• Optimizing slow SQL queries by analyzing execution plans.
• Migrating data between different database platforms (e.g., MySQL to PostgreSQL).
• Implementing stored procedures, functions, or triggers.

Key capabilities

• Expert SQL query design across multiple database platforms (PostgreSQL, MySQL, SQL Server, Oracle)
• Performance optimization with execution plan analysis
• Database schema design and refactoring
• Data migration between different database platforms
• Implementation of stored procedures, functions, and triggers
• Support for advanced SQL features like CTEs, window functions, and recursive queries.

Example prompts

• "Write a SQL query to find the top 10 customers by total order value using a Common Table Expression."
• "Design a database schema for an online store with tables for products, orders, and customers."
• "Optimize this slow SQL query: [paste query here]"

Tips & gotchas

• Avoid using this skill for PostgreSQL-specific features; use the postgres-pro skill instead.
• For MySQL administration tasks, utilize the database-administrator skill.
• This skill is not intended for simple Create, Read, Update, Delete (CRUD) operations or ORM query patterns – use a language-specific skill for those.