New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Performance Optimization

by hmislk in hmislk/hmis

Performance optimization patterns for the HMIS project. An agent skill from hmislk/hmis.

GPL-3.0Auto-check passedDatabases

Install Performance Optimization

skills CLI
$ npx skills add hmislk/hmis --skill performance-optimization -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install hmislk/hmis performance-optimization --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/hmislk/hmis.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.codex/skills/performance-optimization .claude/skills/performance-optimization && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
performance-optimization
GitHub stars
236
Token cost
~499 tokens
SKILL.md length
203 words
Files
1
Skills in repo
33
Repo updated
First seen
Licence
GPL-3.0

At a glance

Performance optimization patterns for the HMIS project. An agent skill from hmislk/hmis.

  • Works in 4 steps: Use DTOs throughout - Avoid converting… → Cache autocomplete results - Preserve… → Skip unnecessary operations - Use… → …
  • Optimizing slow queries
  • SKILL.md covers Core Principles, Autocomplete Optimization…, Query Optimization and MySQL Performance, plus 1 more section
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Performance Optimization is an agent skill from hmislk/hmis. Performance optimization patterns for the HMIS project. Use when optimizing slow queries, improving autocomplete performance, tuning database queries, reducing page load times, optimizing report generation, or investigating performance issues.

Its SKILL.md is about 500 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering Performance optimization and Query optimization. It works with MySQL. The repository describes itself as: This is an Open Source Java EE based Hospital Information Management System. The licence is GPL-3.0.

When your agent uses it

  • Optimizing slow queries
  • Improving autocomplete performance
  • Tuning database queries
  • Reducing page load times

Example prompts

  • “/performance-optimization”

Workflow steps

4 steps, taken from the first numbered list in SKILL.md.

  1. Use DTOs throughout - Avoid converting to entities until necessary
  2. Cache autocomplete results - Preserve full DTO data for converters
  3. Skip unnecessary operations - Use configuration and conditional logic
  4. Defer expensive operations - Move to background or later in workflow

What it can do on your machine

Read from SKILL.md and the folder at commit d5d2020. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Performance Optimization loads about 499 tokens when it runs. Until then it costs about 67 tokens; SKILL.md has 203 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~67
When it runs · the whole SKILL.md, loaded when a task matches
~499

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from hmislk/hmis at commit d5d2020, republished under its GPL-3.0 licence (© hmislk). 203 words, ~499 tokens.

Download SKILL.mdSave it as .claude/skills/performance-optimization/SKILL.md (or your agent's skills folder).
name
performance-optimization
description
Performance optimization patterns for the HMIS project. Use when optimizing slow queries, improving autocomplete performance, tuning database queries, reducing page load times, optimizing report generation, or investigating performance issues.
user-invocable
true

Performance Optimization Guide

Core Principles

  1. Use DTOs throughout - Avoid converting to entities until necessary
  2. Cache autocomplete results - Preserve full DTO data for converters
  3. Skip unnecessary operations - Use configuration and conditional logic
  4. Defer expensive operations - Move to background or later in workflow

Autocomplete Optimization (85-90% improvement)

Key pattern from Pharmacy Retail Sale (639ms -> 50ms):

  1. Enhance DTO with fields needed for lightweight entity creation
  2. Cache autocomplete results in controller for converter reuse
  3. Skip discount calculations when no discount scheme active
  4. Defer item instructions loading to later in workflow

Query Optimization

  • Use DTO constructor queries instead of entity queries for display
  • Always include retired = false in WHERE clauses
  • Use indexed columns in WHERE and ORDER BY
  • Add pagination to limit result sets
  • Use JPQL aggregation (SUM, COUNT, GROUP BY) instead of Java loops

MySQL Performance

  • Enable slow query log for queries > 1 second
  • Use EXPLAIN to analyze query plans
  • Add indexes for frequently queried columns
  • Consider covering indexes for common queries

Report Optimization

  • Use DTO queries for report data
  • Pre-aggregate data in queries instead of Java
  • Implement lazy loading for large datasets
  • Cache report results when data doesn't change frequently

For detailed guides, read:

© hmislk, GPL-3.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in .codex/skills/performance-optimization of hmislk/hmis.

Open the folder on GitHubat commit d5d2020

Compare with similar skills

Performance Optimization next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Performance Optimization compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Performance Optimization this skillhmislk/hmis236—~499Automated safety check: PassGPL-3.0
Database OptimizerJeffallan/claude-skills12k—~1.6kAutomated safety check: PassMIT
SQL Optimizationgithub/awesome-copilot40k2 repos~2.3kAutomated safety check: PassMIT
WooCommerce PHP Performance Patternswoocommerce/woocommerce11k—~395Automated safety check: PassCustom licence
Performance OptimizationHack23/cia239—~1.9kAutomated safety check: PassApache-2.0
Django Filter Benchmarksaleor/saleor23k—~2.3kAutomated safety check: PassBSD-3-Clause

Similar skills

  • Database Optimizer

    Jeffallan/claude-skills

    Tunes PostgreSQL and MySQL performance by analyzing slow queries and execution plans, designing indexes, rewriting queries and adjusting configuration, one validated change at a time.

    12k GitHub stars~1.6k tokensUpdated 4 days ago
    DatabasesAuto-check passed

  • SQL Optimization

    github/awesome-copilot

    Official

    Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server…

    40k GitHub starsUsed in 2 repos~2.3k tokens
    DatabasesAuto-check passed

  • WooCommerce PHP Performance Patterns

    woocommerce/woocommerce

    Flags and fixes performance issues in WooCommerce PHP code: missing post cache priming, uncached option lookups in loops, and inefficient SQL query patterns.

    11k GitHub stars~395 tokensUpdated today
    DatabasesAuto-check passed

  • Performance Optimization

    Hack23/cia

    Application performance tuning, JVM optimization, database query tuning, Vaadin UI performance

    239 GitHub stars~1.9k tokensUpdated today
    DatabasesAuto-check passed

  • Django Filter Benchmark

    saleor/saleor

    Benchmarks Django ORM filters in Saleor by generating bulk data, extracting the SQL and running EXPLAIN ANALYZE to check index usage.

    23k GitHub stars~2.3k tokensUpdated today
    DatabasesAuto-check passed

  • MySQL Schema and Query Tuning

    planetscale/database-skills

    Official

    Guides safe, measurable MySQL and InnoDB changes across schema design, indexing, query tuning, transactions, locking and replication, with rollout steps.

    705 GitHub starsUsed in 3 repos~1.4k tokens
    DatabasesAuto-check passed

More from hmislk/hmis

All 33 skills in this repo

  • API Usage

    hmislk/hmis

    Reference for calling existing HMIS REST APIs. An agent skill from hmislk/hmis.

    236 GitHub stars~1.1k tokensUpdated today
    Auto-check passed

  • App Configuration

    hmislk/hmis

    Application configuration options reference for the HMIS project.

    236 GitHub stars~474 tokensUpdated today
    Auto-check passed

  • Caveman

    hmislk/hmis

    Ultra-compressed communication mode. An agent skill from hmislk/hmis.

    236 GitHub starsUsed in 21 repos~946 tokens
    Auto-check passed

  • Database Guide

    hmislk/hmis

    MySQL database development guide for the HMIS project. An agent skill from hmislk/hmis.

    236 GitHub stars~664 tokensUpdated today
    Auto-check passed

  • Demo Video

    hmislk/hmis

    A skill your agent uses when asked to make a demo, training, how-to or tutorial video with sound or voice-over showing an HMIS function or configuration (e.g.

    236 GitHub stars~3.9k tokensUpdated today
    Auto-check passed

  • Deploy QA

    hmislk/hmis

    Sync development into QA/testing environment branches (QA1-QA4, local RH staging) via PR + merge on GitHub.

    236 GitHub stars~2.1k tokensUpdated today
    Auto-check: notes

Works with

Categories

Questions about Performance Optimization

What does Performance Optimization do?

Performance optimization patterns for the HMIS project. An agent skill from hmislk/hmis. Performance Optimization is an agent skill from hmislk/hmis. Performance optimization patterns for the HMIS project.

When should I use Performance Optimization?

Performance Optimization fits situations like: optimizing slow queries; improving autocomplete performance; tuning database queries; reducing page load times.

How do I install Performance Optimization in Claude Code?

Run `npx skills add hmislk/hmis --skill performance-optimization -a claude-code`. Or copy the skill folder (.codex/skills/performance-optimization in hmislk/hmis) into .claude/skills/performance-optimization in your project. Claude Code loads it when a task matches its description.

How do I install Performance Optimization in Codex?

Run `npx skills add hmislk/hmis --skill performance-optimization -a codex`. Or copy the skill folder (.codex/skills/performance-optimization in hmislk/hmis) into .agents/skills/performance-optimization in your project. Codex loads it when a task matches its description.

Can I use Performance Optimization in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add hmislk/hmis --skill performance-optimization -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/performance-optimization, .gemini/skills/performance-optimization, .github/skills/performance-optimization and .opencode/skills/performance-optimization in your project.

What does Performance Optimization need to run?

SKILL.md names no scripts, command-line tools or credentials: Performance Optimization is instructions for the agent only.

Does Performance Optimization access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Performance Optimization safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Performance Optimization use?

Performance Optimization is published under the GPL-3.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Performance Optimization use?

About 499 tokens (SKILL.md is roughly 2k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Performance Optimization?

Skills that share tags, products or a category with Performance Optimization: Database Optimizer (Jeffallan/claude-skills, 12k stars), SQL Optimization (github/awesome-copilot, 40k stars), WooCommerce PHP Performance Patterns (woocommerce/woocommerce, 11k stars) and Performance Optimization (Hack23/cia, 239 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Performance Optimization?

hmislk (a GitHub organization) maintains it in hmislk/hmis, which has 236 GitHub stars. The repository holds 33 skills in this directory. The repository was last updated on October 8, 2026.

Source: hmislk/hmis on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.