New: 97,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

Database Guide

by hmislk in hmislk/hmis

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

GPL-3.0Auto-check passedDatabases

Install Database Guide

skills CLI
$ npx skills add hmislk/hmis --skill database-guide -a claude-code

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

GitHub CLI
$ gh skill install hmislk/hmis database-guide --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/database-guide .claude/skills/database-guide && 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
database-guide
GitHub stars
236
Token cost
~664 tokens
SKILL.md length
174 words
Files
1
Skills in repo
33
Repo updated
First seen
Licence
GPL-3.0

At a glance

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

  • Working with database queries
  • SKILL.md covers Security Policy, Common Database Operations, Local Development Databases and Persistence Configuration
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
  • Database schema investigation

What it does

Database Guide is an agent skill from hmislk/hmis. MySQL database development guide for the HMIS project. Use when working with database queries, SQL debugging, database schema investigation, MySQL performance tuning, credential management, or database connection troubleshooting.

Its SKILL.md is about 660 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 Database schema design and SQL. It works with MySQL and SQL. 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

  • Working with database queries
  • Database schema investigation
  • MySQL performance tuning
  • Credential management

Example prompts

  • “/database-guide”

What it can do on your machine

Read from SKILL.md and the folder at commit 1820c4a. 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 (its code samples are sql and java).

    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

Database Guide loads about 664 tokens when it runs. Until then it costs about 61 tokens; SKILL.md has 174 words of instructions outside code blocks.

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

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 1820c4a, republished under its GPL-3.0 licence (© hmislk). 174 words, ~664 tokens.

Download SKILL.mdSave it as .claude/skills/database-guide/SKILL.md (or your agent's skills folder).
name
database-guide
description
MySQL database development guide for the HMIS project. Use when working with database queries, SQL debugging, database schema investigation, MySQL performance tuning, credential management, or database connection troubleshooting.
user-invocable
true

MySQL Developer Guide

Security Policy

  • MySQL credentials MUST NEVER be committed to git
  • Credentials stored in separate folder outside the project directory
  • Windows: C:\Credentials\credentials.txt
  • Linux/Mac: ~/.config/hmis/credentials.txt

Common Database Operations

Structure Investigation
sql
SHOW TABLES LIKE '%bill%';
DESCRIBE bill;
SHOW CREATE TABLE bill;
SELECT COUNT(*) FROM bill WHERE retired = 0;
JPQL Query Patterns
java
// Standard entity query
String jpql = "SELECT b FROM Bill b WHERE b.retired = false AND b.department = :dept";

// DTO constructor query (use findLightsByJpql)
String jpql = "SELECT new com.divudi.core.data.dto.MyDTO(b.id, b.name) FROM Bill b WHERE ...";
List<MyDTO> results = (List<MyDTO>) facade.findLightsByJpql(jpql, params, TemporalType.TIMESTAMP);

// Aggregate query
String jpql = "SELECT SUM(b.netTotal) FROM Bill b WHERE ...";
Performance Tips
  • Always include b.retired = false in queries
  • Use indexed columns in WHERE clauses
  • Use DTOs instead of full entities for display
  • Limit result sets with pagination

Local Development Databases

Each developer machine may have different Payara JDBC pool names and JNDI names. Common local databases:

  • rh — primary dev database (JNDI typically jdbc/rhDS)
  • ruhunu — useful as a testing environment with richer data coverage

When a restored database has lowercase table names, it must be converted to uppercase before the app can use it. Generate and run the rename script:

sql
SELECT CONCAT('RENAME TABLE `', table_name, '` TO `temp_', table_name, '`; ',
              'RENAME TABLE `temp_', table_name, '` TO `', UPPER(table_name), '`;')
FROM information_schema.tables
WHERE table_schema = '<db_name>' AND table_name != UPPER(table_name);

Then pipe the output into mysql for that database. See src/main/webapp/resources/sql/UpperCase.sql for reference (note: that file targets a specific schema — always generate fresh from the actual database).

Persistence Configuration

  • Development: Use hardcoded JNDI (machine-specific — check your local Payara setup)
  • Before push: Must use environment variables (${JDBC_DATASOURCE})

For complete reference, read developer_docs/database/mysql-developer-guide.md.

© 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/database-guide of hmislk/hmis.

Open the folder on GitHubat commit 1820c4a

Compare with similar skills

Database Guide 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.

Database Guide compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Database Guide this skillhmislk/hmis236—~664Automated safety check: PassGPL-3.0
Golang Databaseunxed/f42402 repos~2.9kAutomated safety check: PassMIT
Expert DatabaseReJeCtAll/ExpertTeam-Codex113—~692Automated safety check: PassMIT
SQL ProJeffallan/claude-skills12k—~1.3kAutomated safety check: PassMIT
Mysqlsanjay3290/ai-skills430—~1kAutomated safety check: PassApache-2.0
SQL Queriesphuryn/pm-skills27k—~907Automated safety check: PassMIT

Similar skills

  • Golang Database

    unxed/f4

    Comprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context…

    240 GitHub starsUsed in 2 repos~2.9k tokens
    DatabasesAuto-check passed

  • Expert Database

    ReJeCtAll/ExpertTeam-Codex

    数据库优化专家入口。用于 Codex CLI 的 $expert-database 调用. An agent skill from ReJeCtAll/ExpertTeam-Codex.

    113 GitHub stars~692 tokensUpdated 3 mo ago
    DatabasesAuto-check passed

  • SQL Pro

    Jeffallan/claude-skills

    Optimizes SQL queries and designs schemas using CTEs, window functions, covering indexes and EXPLAIN ANALYZE, with notes on dialect differences between major databases.

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

  • Mysql

    sanjay3290/ai-skills

    Execute read-only SQL queries against multiple MySQL databases.

    430 GitHub stars~1k tokensUpdated 26 days ago
    DatabasesAuto-check passed

  • SQL Queries

    phuryn/pm-skills

    Generate SQL queries from natural language descriptions. An agent skill from phuryn/pm-skills.

    27k GitHub stars~907 tokensUpdated 22 days ago
    DatabasesAuto-check passed

  • Agent SQL Pro

    xiaoyuge886/aigc

    Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle.

    198 GitHub stars~315 tokensUpdated 2 mo ago
    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

  • 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

  • Dev Issue

    hmislk/hmis

    Run a GitHub issue through its full lifecycle end-to-end: investigate, discuss the approach, gather test context (department/data), implement, rebuild + local redeploy, verify with Playwright and…

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

Works with

Categories

Questions about Database Guide

What does Database Guide do?

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

When should I use Database Guide?

Database Guide fits situations like: working with database queries; database schema investigation; mySQL performance tuning; credential management.

How do I install Database Guide in Claude Code?

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

How do I install Database Guide in Codex?

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

Can I use Database Guide 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 database-guide -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/database-guide, .gemini/skills/database-guide, .github/skills/database-guide and .opencode/skills/database-guide in your project.

What does Database Guide need to run?

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

Does Database Guide 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 Database Guide 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 Database Guide use?

Database Guide 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 Database Guide use?

About 664 tokens (SKILL.md is roughly 2.7k 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 Database Guide?

Skills that share tags, products or a category with Database Guide: Golang Database (unxed/f4, 240 stars), Expert Database (ReJeCtAll/ExpertTeam-Codex, 113 stars), SQL Pro (Jeffallan/claude-skills, 12k stars) and Mysql (sanjay3290/ai-skills, 430 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Database Guide?

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