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.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Files
SKILL.md
Select a file.
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
