database-slow-query-logging-optimization
/database-slow-query-logging-optimization
Use this skill when capturing, analyzing, and tuning slow database queries using slow query logs and automated index recommendations.
- Author
- nextboxis ↗
- Repository
- library-skill-agents ↗
- Licence
- MIT
- Last repository change
- 28.10.2026
Assessment and security
- Files in this package
- 1
- Scripts
- 0
- HTML comments
- 0
- URLs in SKILL.md
- 0
No signals detected. Repository changed on 28.10.2026, without references to retired models or APIs.
MIT, open: use and modify while retaining author attribution.
What it does and when to use it
Use this skill when capturing, analyzing, and tuning slow database queries using slow query logs and automated index recommendations.
Original author description
Use this skill when capturing, analyzing, and tuning slow database queries using slow query logs and automated index recommendations.
How it works
- When to use
- Prerequisites
- Step-by-step workflow
- Commands / code examples
- Common mistakes & pitfalls
- Verification checklist
- Related skills
SKILL.md preview
--- name: database-slow-query-logging-optimization description: Use this skill when capturing, analyzing, and tuning slow database queries using slow query logs and automated index recommendations. --- # Database Slow Query Logging & Query Tuning ## When to use Use this skill when you need to capturing, analyzing, and tuning slow database queries using slow query logs and automated index recommendations. ## Prerequisites - Working knowledge of systems administration, site reliability engineering, or accessibility standards. - Appropriate administrative tooling, terminal shell, or screen reader testing environment. ## Step-by-step workflow 1. **Analyze operational context**: Inspect host system telemetry, access controls, or UI accessibility trees. 2. **Formulate implementation plan**: Draft declarative configurations, automation scripts, or remediation markup. 3. **Apply changes**: Execute modifications following standard operating procedures and least-privilege principles. 4. **Audit and verify outcomes**: Run diagnostics, automated audits (axe, Lighthouse, sar), or command assertions. 5. **Establish ongoing telemetry**: Configure monitoring rules, periodic health checks, or CI regression gates. ## Commands / code examples ```bash # Operational command and verification workflow for database-slow-query-logging-optimization echo "Executing verification check for database-slow-query-logging-optimization" ``` ## Common mistakes & pitfalls - Disabling security controls or bypassing accessibility standards to achieve rapid fixes. - Modifying production systems without automated verification checks or rollback scripts. - Relying on manual testing instead of embedding automated assertions into CI/CD pipelines. ## Verification checklist - [ ] Implementations satisfy security, accessibility, or observability standards. - [ ] Automated checks pass with zero high-severity warnings or failures. - [ ] Diagnostic logs and telemetry confirm expected operational state. - [ ] Operational runbooks and documentation are updated. ## Related skills - wcag-22-guidelines-conformance-levels - linux-permissions-chmod-chown-acls - distributed-tracing-opentelemetry-sdk - site-reliability-engineering-slo-sla-error-budgets
Versions
The database has no other skills named database-slow-query-logging-optimization.
Database snapshot: 13.11.2026 · package version 906b9465ce40 (SHA-256 digest of the entire package)
Downloads in the last 30 days: 0 · ranking
Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.
Similar skills
- 100database-optimizer
Database performance tuning and query optimization across platforms. Use when analyzing slow queries, designing indexing strategies, tuning database configurations, or scaling database systems. - 100sql-optimization-patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database... - 90sql-optimization-patterns
Provides SQL optimization patterns for query performance, indexing strategies, schema design, and database tuning. Use when optimizing slow queries, designing indexes, or tuning database performance. - 95database
Guide database design, migration, and query optimization. Use when: schema design, migration planning, query optimization, index strategy. Not for: application code migration or framework upgrades — use /migrate; the API contract over the data — use /api-design. Keywords:… - 100sql-optimization
Diagnoses and fixes slow SQL using real query plans, index design, sargable rewrites, keyset pagination and ORM fixes such as N+1 queries. Use when a query, endpoint, report or job is slow, database CPU or IO is high, an EXPLAIN plan needs reading, an index needs designing, or… - 100database-optimizer
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.