메뉴
Spin up a throwaway local Postgres cluster for DB-gated tests that skip without PG_TEST_DSN. Use when SQL/integration tests print "skipping" and you want to run them locally instead of leaving them skipped.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
| name | live-pg-tester |
| version | 1.1.0 |
| description | Spin up a throwaway local Postgres cluster for DB-gated tests that skip without PG_TEST_DSN. Use when SQL/integration tests print "skipping" and you want to run them locally instead of leaving them skipped. |
Requires Homebrew Postgres (brew install postgresql@16). The tool checks
prerequisites at runtime.
bin/pg-test-harness start # spin up, print DSN
bin/pg-test-harness run -- uv run pytest tests/sql/ -v # start, run, tear down
bin/pg-test-harness stop # tear down
bin/pg-test-harness status # check if running
run starts the cluster if needed, sets PG_TEST_DSN, runs the command, and
tears down only if it started the cluster. See bin/pg-test-harness for
implementation.
pg_jsonschema or other third-party extensions. Use the project's Docker
setup (make test-db-up) for those tests.PGDATA under iCloud dirs (~/Documents, ~/Desktop); /tmp
avoids hidden-flag issues. See the unhide-icloud-files skill.Author and build multi-page Asciidoctor documentation sets in the house style. Use this skill when the user wants to: - Bootstrap a new docs/ directory (Asciidoctor + asciidoctor-diagram + asciidoctor-revealjs, multi-page HTML output). - Add a new page to an existing wiki and have it follow the conventions (Diátaxis filename prefix, H1 per file, xref pattern, shared includes, docnav footer). - Add or restyle a mermaid / plantuml / state / Gantt diagram so it matches the project's mermaid.css palette. - Wire up between-page navigation (the `// docnav-start` / `// docnav-end` footer block) so xrefs feel like a book. - Build the wiki locally (mise + bundler + Make). Do NOT use this skill for general prose editing, README rewrites that do not touch the build/conventions, or non-Asciidoctor doc systems (Sphinx, MkDocs, Docusaurus, etc.).
Use when a migration phase produces wrong results silently, a gate fires green when it should not, parity reports RED but the process exits 0, pgloader completes but data is missing, or any situation where the pipeline "succeeds" but the output is wrong. Covers the systematic approach to root-causing silent-failure bugs specific to this codebase.
Use when auditing the hand-authored AsciiDoc prose under docs/ for accuracy and staleness, verifying a doc claim against source of truth, or before a release/cutover when the docs must be trustworthy. The repo moved many facts into generated partials and a verify-doc-facts net, but hand-authored prose still drifts silently because nothing checks it. Covers the source-of-truth audit method, the recurring staleness patterns in these docs, and how to report and fix findings.
Use when reviewing or changing credential handling, SQL interpolation, Secrets Manager integration, pgloader configuration, connection string redaction, healthz probing, or any code that touches sensitive data in this migration pipeline. Covers the specific security surfaces this codebase exposes: f-string SQL injection, credential leaks in logs, trust of external tool exit codes, and non-interactive guards.
Use when implementing or fixing migration phase logic, SQL transforms, gate behavior, or parity checks in this repo. Applies TDD to the specific failure patterns this codebase has: silent exits on failure, gate bypasses, data quietly dropped, and exit-0-on-RED bugs. Required before writing any phase module change, SQL file, or fix commit.
Run ad-hoc, read-only analysis queries against a MySQL database using DuckDB's MySQL extension, without installing a Python MySQL driver and without exposing the password. Use when you need to explore/profile a source MySQL DB (counts, distributions, distinct values, free-text categorization) for a migration or investigation, especially when the project already depends on DuckDB but has no pymysql/mysqlclient/connector, or when you only have a connection URL in a .env file.