メニュー
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 ページを確認してインストールできます。
SOC 職業分類に基づく
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.
| 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.