sql-query-optimizer

Automatically detects and optimizes slow-running SQL queries by analyzing execution plans and suggesting index additions or query rewrites.

Usage

# Analyze a SQL query
echo "SELECT * FROM users WHERE UPPER(email) = 'TEST'" | python3 scripts/analyze.py --format text

# Analyze EXPLAIN output
echo "Seq Scan on users (cost=0.00..1234.00 rows=50000)" | python3 scripts/analyze.py --dialect postgresql

# Analyze ORM logs for N+1 patterns
python3 scripts/analyze.py --input slow.log --mode orm-log --orm django --format json

Installation

OpenClaw (recommended)

Copy the skill into your OpenClaw skills directory:

git clone https://github.com/NeoSkillFactory/sql-query-optimizer.git
cp -r sql-query-optimizer ~/.openclaw/skills/sql-query-optimizer

License

MIT © NeoSkillFactory