Skills
.Work. You
Rest

ops-database-sql

Community

Optimize SQL for blazing-fast database performance.

Data & Analytics#indexing#PostgreSQL#MySQL#DBA#SQL optimization#EXPLAIN ANALYZE#database tuning
Authorvasilyu1983
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Slow SQL queries, inefficient indexing, and poorly managed database operations can cripple application performance and user experience. This Skill provides production-grade SQL optimization and operational patterns across various database platforms.

Core Features & Use Cases

  • AI-Assisted Query Tuning: Analyze query plans with automated EXPLAIN ANALYZE interpretation and receive AI-powered optimization suggestions for PostgreSQL, MySQL, and more.
  • Intelligent Indexing: Design balanced indexing strategies, identify unused indexes, and optimize for selectivity to drastically improve query speeds without over-indexing.
  • Robust Database Operations: Manage schema migrations, implement backup/recovery, set up high availability (replication), and conduct security audits for reliable and secure databases.

Quick Start

Use the ops-database-sql skill to analyze the EXPLAIN ANALYZE output for a slow PostgreSQL query and suggest indexing improvements.

Dependency Matrix

Required Modules

None required

Components

referencesassets

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: ops-database-sql
Download link: https://github.com/vasilyu1983/AI-Agents-public/archive/main.zip#ops-database-sql

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository