oracle

Analyze SQL query execution plans and recommend index strategies.

5|Updated Feb 4, 2026

Search Tags:#performance #schema design #database #optimization #migration #sql

Ready to run

npx skills add https://github.com/Rikinshah787/clawarmy --skill oracle-rikinshah787

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: oracle
Source: https://github.com/Rikinshah787/clawarmy/tree/main/.cursor/skills/oracle
Command: npx skills add https://github.com/Rikinshah787/clawarmy --skill oracle-rikinshah787

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the complexities of database management, including inefficient queries, poorly designed schemas, and risky data migrations, ensuring data integrity and performance.

Core Features & Use Cases

Query Optimization: Analyzes and improves SQL query performance using EXPLAIN ANALYZE.
Schema Design: Guides users on normalization principles and when to denormalize.
Safe Migrations: Provides a protocol for zero-downtime, backward-compatible database schema changes.
Use Case: Optimize a slow-running SELECT query that is causing application latency by analyzing its execution plan and adding appropriate indexes.

Quick Start

Optimize the performance of the 'get_user_orders' SQL query.

Frequently Asked Questions about oracle

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

FAQPage Schema

How do I optimize slow SQL queries causing application latency?▼

To optimize slow SQL query performance, you analyze the query execution plan using `EXPLAIN ANALYZE` and add appropriate indexes to reduce latency and improve data retrieval efficiency.

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

Database schema design for data integrity involves applying normalization principles to structure tables efficiently, while knowing strategically when to denormalize for specific performance requirements.

How do I execute zero-downtime database schema migrations safely?▼

Safe database migrations require following a strict protocol for zero-downtime, backward-compatible schema changes, ensuring data integrity is maintained throughout the deployment process.

When should I denormalize a database schema instead of normalizing it?▼

You denormalize a database schema when query performance demands it, strategically departing from strict normalization principles to optimize read operations while managing data integrity trade-offs.

Why does analyzing a query execution plan help with database optimization?▼

Analyzing a query execution plan helps with database optimization by revealing how the engine processes SQL, allowing you to identify bottlenecks and apply targeted index strategies for performance improvement.