Skip to content
Skills Library
Programming · Analysis

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.

Licence
MIT
Last repository change
28.10.2026

Assessment and security

100/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content35 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
1
Scripts
0
HTML comments
0
URLs in SKILL.md
0
Deprecation

No signals detected. Repository changed on 28.10.2026, without references to retired models or APIs.

Licence

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

  1. When to use
  2. Prerequisites
  3. Step-by-step workflow
  4. Commands / code examples
  5. Common mistakes & pitfalls
  6. Verification checklist
  7. Related skills
Original SKILL.md headings · 39 lines, 247 words
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.

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.