SQL Optimization Patterns
ynulihao/AgentSkillOS
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.
Normalize graduate-application profile fields while preserving field evidence, source provenance, confidence, and confirmation status.
Install Profile Field Normalization
$ npx skills add Bubble252/offer-harvester --skill profile-field-normalization -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install Bubble252/offer-harvester profile-field-normalization --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/Bubble252/offer-harvester.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/profile-field-normalization .claude/skills/profile-field-normalization && rm -rf skills-srcUse ~/.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/
Install the "profile-field-normalization" agent skill from https://github.com/Bubble252/offer-harvester/tree/main/skills/profile-field-normalization into .claude/skills/profile-field-normalization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "profile-field-normalization", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/Bubble252/offer-harvester/tree/main/skills/profile-field-normalizationType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add Bubble252/offer-harvester --skill profile-field-normalization -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install Bubble252/offer-harvester profile-field-normalization --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Bubble252/offer-harvester.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/profile-field-normalization .agents/skills/profile-field-normalization && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "profile-field-normalization" agent skill from https://github.com/Bubble252/offer-harvester/tree/main/skills/profile-field-normalization into .agents/skills/profile-field-normalization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "profile-field-normalization", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add Bubble252/offer-harvester --skill profile-field-normalization -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install Bubble252/offer-harvester profile-field-normalization --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Bubble252/offer-harvester.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/profile-field-normalization .cursor/skills/profile-field-normalization && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "profile-field-normalization" agent skill from https://github.com/Bubble252/offer-harvester/tree/main/skills/profile-field-normalization into .cursor/skills/profile-field-normalization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "profile-field-normalization", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/Bubble252/offer-harvester.git --path skills/profile-field-normalization--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add Bubble252/offer-harvester --skill profile-field-normalization -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install Bubble252/offer-harvester profile-field-normalization --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Bubble252/offer-harvester.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/profile-field-normalization .gemini/skills/profile-field-normalization && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "profile-field-normalization" agent skill from https://github.com/Bubble252/offer-harvester/tree/main/skills/profile-field-normalization into .gemini/skills/profile-field-normalization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "profile-field-normalization", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install Bubble252/offer-harvester profile-field-normalizationInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add Bubble252/offer-harvester --skill profile-field-normalization -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/Bubble252/offer-harvester.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/profile-field-normalization .github/skills/profile-field-normalization && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "profile-field-normalization" agent skill from https://github.com/Bubble252/offer-harvester/tree/main/skills/profile-field-normalization into .github/skills/profile-field-normalization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "profile-field-normalization", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add Bubble252/offer-harvester --skill profile-field-normalization -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install Bubble252/offer-harvester profile-field-normalization --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Bubble252/offer-harvester.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/profile-field-normalization .opencode/skills/profile-field-normalization && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "profile-field-normalization" agent skill from https://github.com/Bubble252/offer-harvester/tree/main/skills/profile-field-normalization into .opencode/skills/profile-field-normalization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "profile-field-normalization", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
profile-field-normalization- GitHub stars
- 123
- Token cost
- ~377 tokens
- SKILL.md length
- 136 words
- Files
- 5 (incl. scripts, references)
- Skills in repo
- 7
- Repo updated
- First seen
- Licence
- MIT
At a glance
Normalize graduate-application profile fields while preserving field evidence, source provenance, confidence, and confirmation status.
- Works in 5 steps: Read references/field-contract.md before… → Normalize text conservatively; preserve… → Keep local uploads, user input, OCR… → …
- Merging resumes
- SKILL.md covers Hard Boundaries and 中文说明
- Runs Python scripts from its folder
What it does
Profile Field Normalization is an agent skill from Bubble252/offer-harvester. Normalize graduate-application profile fields while preserving field evidence, source provenance, confidence, and confirmation status. Use when extracting or merging resumes, transcripts, project notes, manual entries, OCR candidates, or web supplements into a reviewable profile candidate.
Its SKILL.md is about 380 tokens, which your agent loads only when the skill is triggered. The skill folder holds 7 other files, including scripts and reference files (for example `agents/openai.yaml`, `references/field-contract.md` and `scripts/fields_fixture.json`).
It sits in Databases, covering Database schema design. The licence is MIT.
When your agent uses it
- Merging resumes
- Web supplements into a reviewable profile candidate
Example prompts
- “/profile-field-normalization”
Requirements
- Python 3
Workflow steps
5 steps, taken from the first numbered list in SKILL.md.
- Read references/field-contract.md before changing field names or statuses.
- Normalize text conservatively; preserve original wording in source evidence.
- Keep local uploads, user input, OCR candidates, and web supplements distinct.
- Set extracted values to unconfirmed unless the user explicitly confirms them.
- Exclude rejected fields from all generated material candidates.
What it can do on your machine
Read from SKILL.md and the folder at commit c640922. 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
Ships 2 files in scripts/ (Python), which the agent can run.
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
Profile Field Normalization loads about 377 tokens when it runs, and up to ~505 if it reads all its reference files. Until then it costs about 80 tokens; SKILL.md has 136 words of instructions outside code blocks.
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); the scripts in this folder are not scanned.
SKILL.md
The full file from Bubble252/offer-harvester at commit c640922, republished under its MIT licence (© Bubble252). 136 words, ~377 tokens.
Download SKILL.mdSave it as
.claude/skills/profile-field-normalization/SKILL.md (or your agent's skills folder). This skill also uses 4 other files; get the full folder from GitHub.- name
- profile-field-normalization
- description
- Normalize graduate-application profile fields while preserving field evidence, source provenance, confidence, and confirmation status. Use when extracting or merging resumes, transcripts, project notes, manual entries, OCR candidates, or web supplements into a reviewable profile candidate.
Profile Field Normalization
- Read
references/field-contract.mdbefore changing field names or statuses. - Normalize text conservatively; preserve original wording in source evidence.
- Keep local uploads, user input, OCR candidates, and web supplements distinct.
- Set extracted values to
unconfirmedunless the user explicitly confirms them. - Exclude
rejectedfields from all generated material candidates.
Hard Boundaries
- Never silently merge a web supplement into the trusted profile.
- Never downgrade a user-confirmed field based on an unverified inference.
- Do not discard evidence refs, conflicting values, or negative user feedback.
- Return a candidate patch only; the control plane owns confirmed profile writes.
Run scripts/validate_fields.py --input <profile-fields.json> before adding a fixture or adapter output.
中文说明
- 修改字段名或状态前先阅读
references/field-contract.md。 - 保守规范化文本，并在来源证据中保留原始表述。
- 区分本地上传、用户输入、OCR 候选和网页补充资料。
- 除非用户显式确认，否则抽取值均标为
unconfirmed。 - 所有生成材料候选均排除
rejected字段。
强制边界
- 不得将网页补充资料静默合并到可信 profile。
- 不得基于未验证推断降低用户已确认字段。
- 不得丢弃证据引用、冲突值或用户负反馈。
- 只返回候选 patch；confirmed profile 只能由控制面写入。
© Bubble252, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
SKILL.md and 4 other files (scripts, references) in skills/profile-field-normalization of Bubble252/offer-harvester.
- SKILL.md
- agents/openai.yaml
- references/field-contract.md
- scripts/fields_fixture.json
- scripts/validate_fields.py
Open the folder on GitHubat commit c640922
Compare with similar skills
Profile Field Normalization 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.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Profile Field Normalization this skillBubble252/offer-harvester | 123 | — | ~377 | Automated safety check: Pass | MIT | |
| SQL Optimization Patternsynulihao/AgentSkillOS | 617 | 11 repos | ~3.3k | Automated safety check: Pass | None | |
| Add Mpk Taskmirage-project/mirage | 2.5k | — | ~4.5k | Automated safety check: Pass | Apache-2.0 | |
| Datamodellmnimbalyst/nimbalyst | 1.9k | — | ~713 | Automated safety check: Pass | MIT | |
| B200 Flash Attention4 Plannermirage-project/mirage | 2.5k | — | ~1.9k | Automated safety check: Pass | Apache-2.0 | |
| Experiment Auditwanshuiyin/Auto-claude-code-research-in-sleep | 17k | 1 repos | ~2.7k | Automated safety check: Notes | MIT |
Similar skills
Add Mpk Task
mirage-project/mirage
Step-by-step guide for adding a new task implementation to Mirage Persistent Kernel (MPK).
Datamodellm
nimbalyst/nimbalyst
Create visual data models for database schemas using Nimbalyst's DataModelLM editor.
B200 Flash Attention4 Planner
mirage-project/mirage
A skill your agent uses when the user wants to design or extend a FlashAttention-style forward kernel on B200/Blackwell, involving the two MMAs QKᵀ and PV, online softmax, S/P/O in TMEM, warp roles…
Experiment Audit
wanshuiyin/Auto-claude-code-research-in-sleep
Audit experiment integrity before claiming results. An agent skill from wanshuiyin/Auto-claude-code-research-in-sleep.
Sqlite Schema Design
fastrepl/anarlog
Design or review schemas for crates/cloudsync using SQLite Sync constraints, not generic SQLite advice.
More from Bubble252/offer-harvester
Grad Apply Workflow
Bubble252/offer-harvester
Evidence-grounded graduate application workflow protocols for this repository.
Evidence Claim Audit
Bubble252/offer-harvester
Audit graduate-application claims against supplied evidence and return supported, unsupported, stale, or confirmation-required findings.
Source Connector Authoring
Bubble252/offer-harvester
Design and validate safe source connector manifests for public graduate-admission, policy, advisor, lab, and community sources.
Advisor Due Diligence
Bubble252/offer-harvester
Build an evidence-grounded advisor review covering identity, research direction, recruitment signals, lab context, source gaps, and community risk signals.
Contact Email Coach
Bubble252/offer-harvester
Prepare evidence-grounded graduate-advisor contact email candidates with review and audit findings.
Recommendation Letter Helper
Bubble252/offer-harvester
Prepare evidence-grounded recommendation requests, recommender material packets, and clearly labeled reference drafts for graduate applications.
Related
Categories
Questions about Profile Field Normalization
What does Profile Field Normalization do?
Normalize graduate-application profile fields while preserving field evidence, source provenance, confidence, and confirmation status. Profile Field Normalization is an agent skill from Bubble252/offer-harvester. Normalize graduate-application profile fields while preserving field evidence, source provenance, confidence, and confirmation status.
When should I use Profile Field Normalization?
Profile Field Normalization fits situations like: merging resumes; web supplements into a reviewable profile candidate.
How do I install Profile Field Normalization in Claude Code?
Run `npx skills add Bubble252/offer-harvester --skill profile-field-normalization -a claude-code`. Or copy the skill folder (skills/profile-field-normalization in Bubble252/offer-harvester) into .claude/skills/profile-field-normalization in your project. Claude Code loads it when a task matches its description.
How do I install Profile Field Normalization in Codex?
Run `npx skills add Bubble252/offer-harvester --skill profile-field-normalization -a codex`. Or copy the skill folder (skills/profile-field-normalization in Bubble252/offer-harvester) into .agents/skills/profile-field-normalization in your project. Codex loads it when a task matches its description.
Can I use Profile Field Normalization 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 Bubble252/offer-harvester --skill profile-field-normalization -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/profile-field-normalization, .gemini/skills/profile-field-normalization, .github/skills/profile-field-normalization and .opencode/skills/profile-field-normalization in your project.
What does Profile Field Normalization need to run?
Going by SKILL.md and its folder, Profile Field Normalization needs Python for the scripts in its folder. Our summary lists: Python 3.
Does Profile Field Normalization 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 Profile Field Normalization 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. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.
What licence does Profile Field Normalization use?
Profile Field Normalization is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Profile Field Normalization use?
About 377 tokens (SKILL.md is roughly 1.5k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 128 tokens, read only when the agent opens those files.
What are the alternatives to Profile Field Normalization?
Skills that share tags, products or a category with Profile Field Normalization: SQL Optimization Patterns (ynulihao/AgentSkillOS, 617 stars), Add Mpk Task (mirage-project/mirage, 2.5k stars), Datamodellm (nimbalyst/nimbalyst, 1.9k stars) and B200 Flash Attention4 Planner (mirage-project/mirage, 2.5k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Profile Field Normalization?
Bubble252 (a GitHub user) maintains it in Bubble252/offer-harvester, which has 123 GitHub stars. The repository holds 7 skills in this directory. The repository was last updated on August 27, 2026.
Source: Bubble252/offer-harvester on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.