메뉴
Query and analyze the Gertrude PostgreSQL database. Use when answering questions about database schema, writing SQL queries, analyzing data, or debugging database-related issues.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
Write queries and mutations with Gertrude's custom Duet/DuetSQL ORM.
Update local Apple device artwork for the Dashboard_v2 from ipsw.dev. Use when asked to add, refresh, audit, crop, or wire up Mac, iPhone, or iPad model images in web/dashboard-v2/public/devices, especially after new Apple model releases.
Run or design an agentic persona usability eval of a Gertrude surface - drive a real interface as a zero-backstory user, think aloud, and score it on a rubric. Use when asked to usability/UX test a site or app, or to measure whether a change improves real-user comprehension. The working driver today is web (Playwright MCP); native apps are not yet supported.
Verify non-trivial database migrations (data backfill, column drops, FK retargets, type changes, dedup) by capturing pre-migration baseline state, running the up/down/up cycle through the user, and asserting expected outcomes at each step. Use when a migration touches data — not just schema.
Research and prepare a new public keychain for a website or service. Use when asked to create or prepare a public keychain for a domain.
SOC 직업 분류 기준
| name | database |
| description | Query and analyze the Gertrude PostgreSQL database. Use when answering questions about database schema, writing SQL queries, analyzing data, or debugging database-related issues. |
You have access to the Gertrude PostgreSQL database for querying and analysis.
For connection info, read ./swift/api/.env and use the values there.
You may READ and write to the LOCAL task database, as it is a task-specific, PII-scrubbed local snapshot. You may NEVER try to discover how to ssh into production or read/write remote databases for any reason. The snapshot is complete, not a subset of prod.
Important: although this repo has some docker-related files, all local development goes
through a local install of postgres and NOT through docker. Never use docker commands
when dealing with the database.
../migration-verification/SKILL.md.Data is spread across multiple non-public Postgres schemas (don't assume public). The
map below is orientation for where to look — discover the live tables/columns yourself
(\dn, \dt <schema>.*), since table-level detail drifts.