Run any Skill in Manus with one click

pinpoint-preview-deployments

Stars2

Forks0

UpdatedJuly 9, 2026 at 23:35

On-demand, TTL'd Supabase preview branches for PinPoint PRs — the /preview PR-comment control surface, sticky status comment, and hourly reaper. Use when setting up, debugging, or explaining Vercel preview deployments or the /preview command.

Installation

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.

Run Skill in Manus

Source

timothyfroehlich

timothyfroehlich/PinPoint

View GitHub Repository View Creator Repositories

Download

Run Skill in Manus

Related occupationsSOC

Based on SOC occupation classification

Software DevelopersComputer and Mathematical Occupations·SOC 15-1252

SKILL.md

readonly

name	pinpoint-preview-deployments
description	On-demand, TTL'd Supabase preview branches for PinPoint PRs — the /preview PR-comment control surface, sticky status comment, and hourly reaper. Use when setting up, debugging, or explaining Vercel preview deployments or the /preview command.

PinPoint Preview Deployments

Native Supabase auto-branching is disabled — no PR gets a preview by default (zero branches, zero cost). Previews are created on demand via PR comment commands and torn down on a TTL.

Control surface = PR comments (from authors with write access only):
- /preview — create (or restart after expiry) a branch, migrate + seed it, wire creds into the Vercel preview, and post a sticky status comment with the live URL + 48h expiry.
- /preview extend — push expiry +48h (no DB work). /preview stop — tear down now.
State: one sticky bot comment per PR (keyed ) holds the Expires: timestamp — the TTL source of truth.
Reaper: Preview Reaper runs hourly; deletes branches past expiry or on closed/merged PRs, and flips the sticky comment to "expired — comment /preview to restart."
Implementation (workflows, the Vercel git-integration wiring, and required secrets): .github/workflows/preview-control.yaml, preview-reaper.yaml, scripts/workflow/preview/*.sh.

Vercel preview migrations: preview deployments skip migrate:production (branch DB user lacks CREATE SCHEMA). The on-demand Preview Controller workflow migrates + seeds the branch DB before building the preview. Production deploys still migrate.

More from this repository

same repository

pinpoint-security

timothyfroehlich/PinPoint

Security patterns, CSP nonces, input validation, auth checks, Supabase SSR patterns. Use when implementing authentication, forms, security features, or when user mentions security/validation/auth.

2026-07-112

pinpoint-superpowers-bridge

timothyfroehlich/PinPoint

Use when running the superpowers plugin lifecycle inside PinPoint — brainstorming, writing-plans, subagent-driven-development, requesting/receiving-code-review, or finishing-a-development-branch — and when a superpowers step wants to merge a branch locally, remove a worktree by hand, run generic npm/pytest tests, dispatch subagents without a scale gate, or write a spec/plan from the read-only root. Also when deciding which bead field a spec, plan, acceptance criterion, or landing note belongs in.

2026-07-102

pinpoint-orchestrator

timothyfroehlich/PinPoint

Orchestrate parallel subagent work in git worktrees — task selection, end-to-end dispatch, monitoring, follow-up, and cleanup.

2026-07-092

pinpoint-pr-workflow

timothyfroehlich/PinPoint

Full PR lifecycle for PinPoint — commit, push, CI monitoring, Copilot + human review handling (via MCP), readiness labeling, gate-enforced merge. Use when committing changes, opening PRs, watching CI, addressing review comments, or merging.

2026-07-092

pinpoint-audit-override

timothyfroehlich/PinPoint

Per-PR /audit-override escape hatch for unrelated pnpm audit failures blocking CI Gate. Use when a PR's audit job goes red on a freshly-published advisory unrelated to the PR's own changes, or when explaining/debugging the /audit-override command.

2026-07-092

pinpoint-db-connections

timothyfroehlich/PinPoint

Supabase/Postgres pooler and connection-string reference for PinPoint — Supavisor transaction vs session pooler, IPv4/IPv6, prepared statements, and the resolved PP-d8l8 silent-commit-loss incident. Use when touching src/server/db/**, scripts/migrate-production.ts, scripts/lib/pg-client.mjs, or any DB connection/pooler config.

2026-07-092

name	pinpoint-preview-deployments
description	On-demand, TTL'd Supabase preview branches for PinPoint PRs — the /preview PR-comment control surface, sticky status comment, and hourly reaper. Use when setting up, debugging, or explaining Vercel preview deployments or the /preview command.

PinPoint Preview Deployments

Native Supabase auto-branching is disabled — no PR gets a preview by default (zero branches, zero cost). Previews are created on demand via PR comment commands and torn down on a TTL.

Control surface = PR comments (from authors with write access only):
- /preview — create (or restart after expiry) a branch, migrate + seed it, wire creds into the Vercel preview, and post a sticky status comment with the live URL + 48h expiry.
- /preview extend — push expiry +48h (no DB work). /preview stop — tear down now.
State: one sticky bot comment per PR (keyed ) holds the Expires: timestamp — the TTL source of truth.
Reaper: Preview Reaper runs hourly; deletes branches past expiry or on closed/merged PRs, and flips the sticky comment to "expired — comment /preview to restart."
Implementation (workflows, the Vercel git-integration wiring, and required secrets): .github/workflows/preview-control.yaml, preview-reaper.yaml, scripts/workflow/preview/*.sh.