database-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.

Install with Tessl CLI

npx tessl i github:jeffallan/claude-skills --skill database-optimizer

What are skills?

Review — 62%

Does it follow best practices?

If you maintain this skill, you can automatically optimize it using the tessl CLI to improve its score:

npx tessl skill review --optimize ./path/to/skill

Learn more

Evaluation — 93%

Agent success when using this skill

Validation — 11 / 11 Passed

Validation for skill structure

SKILL.md

Review

Evals

Evaluation results

90%

-1%

Customer Dashboard Report Optimization

Query plan analysis and rewriting

Criteria

Without context

With context

EXPLAIN before optimize

70%

90%

Baseline metrics

87%

Bottleneck identification

100%

Window function rewrite

100%

EXISTS or CTE rewrite

87%

50%

Keyset pagination

100%

OR to UNION rewrite

100%

No SELECT *

100%

Date function avoidance

100%

87%

Validation queries

100%

Write performance note

25%

Monitoring recommendations

100%

Without context: $0.2912 · 1m 55s · 7 turns · 8 in / 6,372 out tokens

With context: $0.5649 · 2m 37s · 17 turns · 16 in / 9,342 out tokens

92%

-8%

E-Commerce Search and Browse Index Audit

Strategic index design

Criteria

Without context

With context

Query pattern analysis

100%

Equality before range ordering

100%

High selectivity first

100%

Covering index / INCLUDE

100%

Partial index usage

100%

Expression index for LOWER()

100%

GIN index for array/tags

100%

No redundant indexes

100%

Write performance discussion

100%

CONCURRENTLY usage

100%

Unused index monitoring

100%

VACUUM/ANALYZE cadence

100%

Validation / EXPLAIN reference

100%

Without context: $0.3976 · 2m 50s · 10 turns · 11 in / 8,234 out tokens

With context: $0.5882 · 2m 45s · 20 turns · 19 in / 7,636 out tokens

98%

17%

PostgreSQL Configuration Tuning for New Dedicated Server

PostgreSQL server configuration tuning

Criteria

Without context

With context

shared_buffers formula

100%

work_mem formula

50%

100%

effective_cache_size formula

100%

default_statistics_target

100%

random_page_cost for SSD

100%

WAL/checkpoint config

100%

Autovacuum enabled

100%

pg_stat_statements monitoring

100%

Cache hit ratio validation

100%

Replication lag consideration

62%

100%

Document reasoning

100%

Incremental change advice

25%

50%

Without context: $0.4090 · 2m 49s · 11 turns · 11 in / 8,863 out tokens

With context: $0.5782 · 2m 44s · 17 turns · 16 in / 8,343 out tokens

Evaluated: about 6 hours ago
Agent: Claude Code

Table of Contents

Customer Dashboard Report Optimization E-Commerce Search and Browse Index Audit PostgreSQL Configuration Tuning for New Dedicated Server

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.