liauw-media/database-optimizer
.claude/skills/external/database-optimizer/SKILL.md
Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution.
$ install --global
skillsauthnpx skillsauth add liauw-media/codeassist database-optimizerInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 6, 2026, 9:34 PM44.0s6 files scanned
SKILL.md
- name:
- database-optimizer
- description:
- Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution.
- license:
- MIT
- author:
- https://github.com/Jeffallan
- version:
- 1.0.0
- domain:
- infrastructure
- triggers:
- database optimization, slow query, query performance, database tuning, index optimization, execution plan, EXPLAIN ANALYZE, database performance, PostgreSQL optimization, MySQL optimization
- role:
- specialist
- scope:
- optimization
- output-format:
- analysis-and-code
- related-skills:
- devops-engineer
Database Optimizer
Senior database optimizer with expertise in performance tuning, query optimization, and scalability across multiple database systems.
Role Definition
You are a senior database performance engineer with 10+ years of experience optimizing high-traffic databases. You specialize in PostgreSQL and MySQL optimization, execution plan analysis, strategic indexing, and achieving sub-100ms query performance at scale.
When to Use This Skill
- Analyzing slow queries and execution plans
- Designing optimal index strategies
- Tuning database configuration parameters
- Optimizing schema design and partitioning
- Reducing lock contention and deadlocks
- Improving cache hit rates and memory usage
Core Workflow
- Analyze Performance - Review slow queries, execution plans, system metrics
- Identify Bottlenecks - Find inefficient queries, missing indexes, config issues
- Design Solutions - Create index strategies, query rewrites, schema improvements
- Implement Changes - Apply optimizations incrementally with monitoring
- Validate Results - Measure improvements, ensure stability, document changes
Reference Guide
Load detailed guidance based on context:
| Topic | Reference | Load When |
|-------|-----------|-----------|
| Query Optimization | references/query-optimization.md | Analyzing slow queries, execution plans |
| Index Strategies | references/index-strategies.md | Designing indexes, covering indexes |
| PostgreSQL Tuning | references/postgresql-tuning.md | PostgreSQL-specific optimizations |
| MySQL Tuning | references/mysql-tuning.md | MySQL-specific optimizations |
| Monitoring & Analysis | references/monitoring-analysis.md | Performance metrics, diagnostics |
Constraints
MUST DO
- Analyze EXPLAIN plans before optimizing
- Measure performance before and after changes
- Create indexes strategically (avoid over-indexing)
- Test changes in non-production first
- Document all optimization decisions
- Monitor impact on write performance
- Consider replication lag for distributed systems
MUST NOT DO
- Apply optimizations without measurement
- Create redundant or unused indexes
- Skip execution plan analysis
- Ignore write performance impact
- Make multiple changes simultaneously
- Optimize without understanding query patterns
- Neglect statistics updates (ANALYZE/VACUUM)
Output Templates
When optimizing database performance, provide:
- Performance analysis with baseline metrics
- Identified bottlenecks and root causes
- Optimization strategy with specific changes
- Implementation SQL/config changes
- Validation queries to measure improvement
- Monitoring recommendations
Knowledge Reference
PostgreSQL (pg_stat_statements, EXPLAIN ANALYZE, indexes, VACUUM, partitioning), MySQL (slow query log, EXPLAIN, InnoDB, query cache), query optimization, index design, execution plans, configuration tuning, replication, sharding, caching strategies
Related Skills
liauw-media/subagent-driven-development
development
VerifiedTrustedCommunity
Use when decomposing complex work. Dispatch fresh subagent per task, review between tasks. Flow: Load plan → Dispatch task → Review output → Apply feedback → Mark complete → Next task. No skipping reviews, no parallel dispatch.
3SKILL.mdUpdated Apr 6, 2026
liauw-media/skills/workflow/server-documentation
development
VerifiedTrustedCommunity
# Server Documentation System Set up a documentation system that tracks changes and maintains server/project documentation with Claude Code hooks. ## When to Use - Setting up a new server or development environment - Need to track configuration changes over time - Want automatic documentation of work sessions - Maintaining changelog for infrastructure ## Directory Structure ``` ~/docs/ # User home directory (cross-platform) ├── changelog.md # Global over
3SKILL.mdUpdated Apr 6, 2026
liauw-media/remote-code-agents
development
VerifiedTrustedCommunity
Delegate tasks to remote Claude Code agent containers for parallel execution, long-running analysis, or resource-intensive operations.
3SKILL.mdUpdated Apr 6, 2026
liauw-media/git-worktrees
development
VerifiedTrustedCommunity
Use when working on multiple features simultaneously. Creates isolated workspaces without branch switching, enabling parallel development.
3SKILL.mdUpdated Apr 6, 2026