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

Ready to run

npx skills add https://github.com/Axel-DaMage/opencode-config --skill sql-pro-axel-damage

💬 Prompt for ChatGPT / Claude Chat▼

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.