skills.rest
Design-System-ET
Design-System-ETOFFICIAL
Explore all skills by this author →
GitHub

sql-pro

Optimize SQL queries and database schemas across multiple dialects.

Updated Jun 16, 2026
Search Tags:#performance#indexing#database#postgresql#optimization#schema#sql
One-click install
npx skills add https://github.com/Design-System-ET/genexus-dev-opencode --skill sql-pro-design-system-et
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/Design-System-ET/genexus-dev-opencode/tree/main/skills/sql-pro
Command: npx skills add https://github.com/Design-System-ET/genexus-dev-opencode --skill sql-pro-design-system-et

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses database performance bottlenecks and complex schema design challenges, ensuring your data layer remains efficient and scalable.

Core Features & Use Cases

  • Query Optimization: Analyzes execution plans to eliminate slow sequential scans and implement covering indexes.
  • Schema Design: Provides expert guidance on normalization, foreign key integrity, and partitioning strategies.
  • Dialect Support: Handles specific syntax and performance nuances across PostgreSQL, MySQL, SQL Server, and Oracle.

Quick Start

Use the sql-pro skill to analyze the provided query execution plan and suggest an optimized indexing strategy.

Frequently Asked Questions about sql-pro

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

FAQPage Schema
How do I optimize SQL queries to eliminate slow sequential scans?▼

SQL query optimization analyzes execution plans to eliminate slow sequential scans and implements covering indexes to resolve database performance bottlenecks. It ensures your data layer remains efficient and scalable across multiple dialects.

What is the best way to design a database schema for performance and data integrity?▼

Database schema design provides expert guidance on normalization, foreign key integrity, and partitioning strategies to ensure data integrity. It addresses complex schema design challenges to keep your data layer efficient and scalable.

Does this approach support query tuning for PostgreSQL, MySQL, and SQL Server?▼

Yes, query tuning handles specific syntax and performance nuances across PostgreSQL, MySQL, SQL Server, and Oracle. It applies complex query tuning and performance benchmarking across these multiple database dialects.

How do I analyze an execution plan to implement a covering index?▼

Analyzing execution plans identifies slow sequential scans, allowing you to implement covering indexes for set-based processing. Provide the execution plan to get an optimized indexing strategy that resolves performance bottlenecks.

When do I need partitioning strategies for database schema migration?▼

Partitioning strategies are needed during database schema migration to resolve performance bottlenecks and ensure data integrity at scale. They are applied alongside normalization and foreign key integrity for complex schema design.

Related Skills

Explore More Software Engineering Skills→
HieubkavHieubkav

database-performance

Analyze database indexes and query execution plans to recommend optimizations.

Community
Advanced
ROLLED740ROLLED740
1

postgres-patterns

Optimizes PostgreSQL schema, indexing, queries, and Row Level Security configurations.

Community
Intermediate
pratikrath126pratikrath126
42

database-design

Assess database schema designs and indexing strategies for integrity and query performance.

Community
Intermediate
Chengxufeng1994Chengxufeng1994

sql-optimization

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

Community
Advanced