메뉴
Run read-only MySQL queries against the Thomas local Docker MySQL or the dev Aurora hmmall/thomas databases. Use when the user wants quick schema inspection, SQL lookups, NATION/STATE mapping checks, or direct read-only validation without relying on MCP.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
코드 분석/탐색 시 토큰을 최소화하면서 정확도를 최대화하는 도구 선택과 검색 전략. ast-grep(sg) 구문 인식 검색, ripgrep, fd, LSP, Glob의 우선순위·조합 가이드. 코드 검색, 심볼 탐색, 리팩토링, 패턴 찾기, "어디서 쓰이는지", "구현체 찾아줘" 등의 요청 시 자동 적용. 출처: msbaek/dotfiles `<tool_preferences>` 패턴을 로컬 환경에 어댑테이션.
Save the current Codex session's work summary before ending a conversation. Use when the user says /wrap, wrap, 세션 정리, 세션 저장, 작업 내용 저장, 메모리 저장, 세션 마무리, 오늘 여기까지, or asks to preserve progress for the next Codex session.
Upgrade all development tools via Homebrew, sync Brewfile packages, and verify RTK hooks. Use this skill whenever the user mentions daily upgrade, brew update, package upgrade, claude-code update, 데일리 업그레이드, 브루 업데이트, 패키지 업데이트, 일일 업그레이드, or any request to bring their dev environment up to date — even casual mentions like 'update everything' or '오늘 업데이트 좀'.
Use when the user asks to brainstorm, design before coding, refine requirements, or turn an idea into an approved spec before implementation. This skill explores intent, compares approaches, presents a design, writes a spec to `docs/specs/.local/`, and blocks code changes until the design is approved.
Analyze the current changes and conversation context, generate an intent-focused Git commit message, and run `git commit`. Use when the user asks to commit changes or wants commit automation around `git commit`, `commit`, `--amend`, `--push`, or `--no-verify`. The skill instructions are in English, but the generated commit message itself must be written in Korean.
Copy only the meaningful, paste-ready artifact from the current task to the clipboard, usually code, SQL, JSON, shell commands, or a clean text snippet without surrounding explanation. Use when the user asks to put something on the clipboard, copy only the useful part, copy just the query/code, remove commentary, or prepare a clean paste-ready result from recent work.
| name | mysql-read |
| description | Run read-only MySQL queries against the Thomas local Docker MySQL or the dev Aurora hmmall/thomas databases. Use when the user wants quick schema inspection, SQL lookups, NATION/STATE mapping checks, or direct read-only validation without relying on MCP. |
Use the bundled shell script for read-only MySQL access.
Default targets:
local: Docker MySQL started by the Thomas repo (compose.yml)dev: Aurora read endpoint using AWS CLI + Secrets Managerlocal for Docker data seeded by the repo.dev for shared Aurora data after aws sso login.~/.codex/skills/mysql-read/scripts/mysql-read.sh --target local --database hmmall --sql "SELECT 1"
~/.codex/skills/mysql-read/scripts/mysql-read.sh --target dev --database hmmall --sql "SELECT NATION_NO, COUNTRY_ID, DEF_NATION_NM FROM NATION WHERE COUNTRY_ID IN ('US','CA')"
SELECT, SHOW, DESCRIBE, DESC, EXPLAIN, and WITH ... SELECT queries are allowed.local uses a running Docker MySQL container and defaults to:
docker psuserpassdev defaults to:
defaultap-northeast-2MYSQL_READ_DEV_HOSTMYSQL_READ_DEV_SECRET_ARN--sql "SELECT NATION_NO, COUNTRY_ID, DEF_NATION_NM FROM NATION WHERE COUNTRY_ID = 'US'"--sql "SELECT NATION_NO, STATE_NM, STATE_CD FROM STATE WHERE STATE_NM = 'New York'"--sql "SHOW COLUMNS FROM STATE"dockerawsIf local is used, the Thomas MySQL container must be running.
If dev is used, run aws sso login first and set MYSQL_READ_DEV_HOST plus MYSQL_READ_DEV_SECRET_ARN.