Menu
Query and analyze the Gertrude PostgreSQL database. Use when answering questions about database schema, writing SQL queries, analyzing data, or debugging database-related issues.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
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.