Database Optimizer Agent Skill

Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures. Masters advanced indexing, N+1 resolution, multi-tier caching, partitioning strategies, and cloud database optimization. Handles complex query analysis, migration strategies, and performance monitoring. Use PROACTIVELY for database optimization, performance issues, or scalability challenges.

3k tokens

context cost

the whole folder, loaded on every use

files

instructions only

copies elsewhere

how many repositories repackaged it

505

stars on the repo

on the repository, not the skill itself

Install

one command, takes just this skill from the repository

npx skills add https://github.com/Dokhacgiakhoa/Agent-Skills-4-Vibe-Coding-CLI --skill database-optimizer

What comes with it

8 706 bytes besides the instruction

sub-skills/advanced-caching-architectures.md

sub-skills/advanced-query-optimization.md

sub-skills/application-integration.md

sub-skills/cloud-database-optimization.md

sub-skills/cost-optimization.md

sub-skills/database-scaling-partitioning.md

sub-skills/modern-database-technologies.md

sub-skills/modern-indexing-strategies.md

sub-skills/n1-query-resolution.md

sub-skills/performance-analysis-monitoring.md

sub-skills/performance-testing-benchmarking.md

sub-skills/schema-design-migration.md

The instruction itself

18 sections, as written by the author

Use this skill when

Working on database optimizer tasks or workflows
Needing guidance, best practices, or checklists for database optimizer

Do not use this skill when

The task is unrelated to database optimizer
You need a different domain or tool outside this scope

Instructions

Clarify goals, constraints, and required inputs.
Apply relevant best practices and validate outcomes.
Provide actionable steps and verification.
If detailed examples are required, open resources/implementation-playbook.md.

You are a database optimization expert specializing in modern performance tuning, query optimization, and scalable database architectures.

Purpose

Expert database optimizer with comprehensive knowledge of modern database performance tuning, query optimization, and scalable architecture design. Masters multi-database platforms, advanced indexing strategies, caching architectures, and performance monitoring. Specializes in eliminating bottlenecks, optimizing complex queries, and designing high-performance database systems.

Capabilities

🧠 Knowledge Modules (Fractal Skills)

1. Advanced Query Optimization

2. Modern Indexing Strategies

3. Performance Analysis & Monitoring

4. N+1 Query Resolution

5. Advanced Caching Architectures

6. Database Scaling & Partitioning

7. Schema Design & Migration

8. Modern Database Technologies

9. Cloud Database Optimization

10. Application Integration

11. Performance Testing & Benchmarking

12. Cost Optimization

Other skills for the same job

different authors, same section of the catalogue

Biorxiv Database

by christophacham

×4

Efficient database search tool for bioRxiv preprint server. Use this skill when searching for life sciences preprints by keywords, authors, date ranges, or categories, retrieving paper metadata, downloading PDFs, or conducting literature reviews.

Access BRENDA enzyme database via SOAP API. Retrieve kinetic parameters (Km, kcat), reaction equations, organism data, and substrate-specific enzyme information for biochemical research and metabolic pathway analysis.

Access ClinPGx pharmacogenomics data (successor to PharmGKB). Query gene-drug interactions, CPIC guidelines, allele functions, for precision medicine and genotype-guided dosing decisions.

Query NCBI ClinVar for variant clinical significance. Search by gene/position, interpret pathogenicity classifications, access via E-utilities API or FTP, annotate VCFs, for genomic medicine.

Access COSMIC cancer mutation database. Query somatic mutations, Cancer Gene Census, mutational signatures, gene fusions, for cancer research and precision oncology. Requires authentication.

Query Ensembl genome database REST API for 250+ species. Gene lookups, sequence retrieval, variant analysis, comparative genomics, orthologs, VEP predictions, for genomic research.

Query openFDA API for drugs, devices, adverse events, recalls, regulatory submissions (510k, PMA), substance identification (UNII), for FDA regulatory data analysis and safety research.

Query NCBI Gene via E-utilities/Datasets API. Search by symbol/ID, retrieve gene info (RefSeqs, GO, locations, phenotypes), batch lookups, for gene annotation and functional analysis.

13k tokens scripts

How to use it

Copy the folder

Take dokhacgiakhoa/database-optimizer from the repository into ~/.claude/skills for personal use, or into .claude/skills inside a project.

Check the name does not clash

The agent identifies a skill by the name field in its header. Two skills with the same name cannot sit side by side — one of them will be ignored.