Jeden Skill in Manus ausführen
mit einem Klick

Jeden Skill in Manus mit einem Klick ausführen

live-pg-tester

Sterne4

Forks0

Aktualisiert10. Juli 2026 um 15:34

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.

Installation

Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.

In Manus ausführen

Quelle

Enterprise-CMCS

Enterprise-CMCS/demos

GitHub-Repository öffnen Creator-Repositorys ansehen

Download

In Manus ausführen

Verwandte BerufeSOC

Basierend auf der SOC-Berufsklassifikation

Softwarequalitätssicherungsanalysten und -testerInformatik- und Mathematikberufe·SOC 15-1253

SKILL.md

readonly

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.

Live PG tester

Requires Homebrew Postgres (brew install postgresql@16). The tool checks prerequisites at runtime.

CLI tool

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.

Gotchas

No pg_jsonschema or other third-party extensions. Use the project's Docker setup (make test-db-up) for those tests.
Don't target a real/shared database; the DSN points only at the disposable local cluster on port 54329.
Don't put PGDATA under iCloud dirs (~/Documents, ~/Desktop); /tmp avoids hidden-flag issues. See the unhide-icloud-files skill.

Mehr aus diesem Repository

gleiches Repository

asciidoc-wiki

Enterprise-CMCS/demos

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.).

2026-07-104

migration-debugging

Enterprise-CMCS/demos

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.

2026-07-104

migration-docs-audit

Enterprise-CMCS/demos

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.

2026-07-104

migration-security

Enterprise-CMCS/demos

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.

2026-07-104

migration-tdd

Enterprise-CMCS/demos

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.

2026-07-104

mysql-ducksplorer

Enterprise-CMCS/demos

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.

2026-07-104

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.

Live PG tester

Requires Homebrew Postgres (brew install postgresql@16). The tool checks prerequisites at runtime.

CLI tool

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.

Gotchas

No pg_jsonschema or other third-party extensions. Use the project's Docker setup (make test-db-up) for those tests.
Don't target a real/shared database; the DSN points only at the disposable local cluster on port 54329.
Don't put PGDATA under iCloud dirs (~/Documents, ~/Desktop); /tmp avoids hidden-flag issues. See the unhide-icloud-files skill.