Summary
A solid reference for OLTP performance work across PostgreSQL, MySQL, SQL Server, Oracle, and SQLite. The core value is in the structured approach: measurement-first triage using pg_stat_statements or slow query logs, EXPLAIN plan interpretation with platform-specific guidance, and index design that explicitly warns against over-indexing. The templates cover the operational reality of schema migrations (Flyway/Liquibase), replication setup, and backup/recovery workflows. What stands out is the separation between OLTP optimization (here) and OLAP workloads (punted to a separate data lake skill), which reflects how these problems actually differ in practice. Best for teams running transactional databases who need checklists and decision trees rather than theory.
Install to Claude Code
npx -y skills add vasilyu1983/ai-agents-public --skill data-sql-optimization --agent claude-codeInstalls into .claude/skills of the current project.
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →
Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
Files
SKILL.md
Select a file.
Featured
Plug Mailtrap into your AI workflow and let it handle the email.
Connect Mailtrap MCP →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →Make coding agent sessions - Searchable, Shareable, Vendor-neutral & Scored.
Try For Free →Your agent targets a perfect 10 Code Health score. Deterministic. Every commit.
Try For Free →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
