skills.rest
Axel-DaMage
Axel-DaMageCOMMUNITY
Explore all skills by this author →
GitHub

sql-pro

Optimize SQL queries and design database schemas with indexing strategies.

2|Updated Jun 29, 2026
Search Tags:#database design#query optimization#sql#performance analysis#sql server
One-click install
npx skills add https://github.com/Axel-DaMage/opencode-config --skill sql-pro-axel-damage
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/Axel-DaMage/opencode-config/tree/main/skills/sql-pro
Command: npx skills add https://github.com/Axel-DaMage/opencode-config --skill sql-pro-axel-damage

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill addresses the challenges of SQL query optimization, performance troubleshooting, and database schema design, enabling users to write more efficient queries and maintain robust database structures.

Core Features & Use Cases

  • SQL Query Optimization: Analyze and optimize SQL queries for performance, using techniques like indexing, query rewriting, and execution plan analysis.
  • Database Schema Design: Guide users through database schema design best practices, normalization, and indexing strategies.
  • Use Case: When faced with slow query performance or the need to design a new database schema, this Skill can help identify bottlenecks, recommend improvements, and provide best practices for schema design.

Quick Start

Invoke the sql-pro skill and run a complex SQL query, e.g., "SELECT * FROM orders WHERE order_date > '2023-01-01' AND status = 'shipped'".

Frequently Asked Questions about sql-pro

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

FAQPage Schema
How do I optimize slow SQL queries?▼

SQL query optimization involves analyzing execution plans, rewriting complex statements, and applying indexing strategies to reduce latency. This Skill identifies bottlenecks and recommends improvements to enhance query performance.

What is the best way to design a database schema for normalization?▼

Database schema design applies normalization and indexing strategies to structure data efficiently. This Skill guides you through schema design best practices to maintain robust database structures and optimal performance.

Does this SQL optimization guidance work with PostgreSQL and MySQL?▼

Yes, dialect-specific considerations are provided for PostgreSQL, MySQL, SQL Server, and Oracle. The Skill requires knowledge of common database management systems to deliver accurate query optimization and performance troubleshooting.

Why does my SQL query performance drop when filtering large datasets?▼

SQL query performance drops on large datasets due to missing indexes or inefficient execution plans. Performance analysis identifies these bottlenecks and recommends indexing strategies or query rewrites to resolve the degradation.

When do I need database indexing strategies for performance troubleshooting?▼

Database indexing strategies are needed during slow query performance troubleshooting or new schema design. They resolve bottlenecks and improve data retrieval efficiency by guiding indexing decisions for robust database structures.

Related Skills

Explore More Software Engineering Skills→
Chengxufeng1994Chengxufeng1994

sql-optimization

Analyze SQL execution plans and optimize queries across MySQL, PostgreSQL, SQL Server, and Oracle.

Community
Advanced
AngelP17AngelP17
1

sql-optimization-patterns

Analyze EXPLAIN output and apply indexing strategies to optimize slow SQL queries.

Community
Advanced
m16khbm16khb
1

codd

Analyze and optimize relational database schemas and SQL queries.

Community
Advanced
Serg28Serg28

sql-pro

Analyze SQL execution plans and recommend indexing strategies.

Community
Advanced