📋 Copy Blueprint Command { } Inspect JSON API Ground-Truth Source ↗

⚡ 1-Click Agent & Developer Install

Zero Auth · Ready for Grok Bot, Claude Code & Cursor

### 1. Problem & Operational Bottleneck Spin up an ephemeral restore branch from nightly Postgres backups every Sunday, run row-count and foreign-key integrity checks, and log SOC2 proof. Built and battle-tested in production workflows by **@rauchg** (Guillermo Rauch (@rauchg)). ### 2. Target Architecture & Required Stack - **Postgres MCP** - **Neon MCP** - **Notion MCP** ### 3. Step-by-Step Implementation Blueprint 1. Connect Postgres MCP, Neon MCP, Notion MCP and verify read-only access to the target workspace. 2. Run the discovery query for 'Automated Weekly Postgres Backup Restore & Checksum Drill' to establish baseline metrics and identify anomalies. 3. Generate a structured remediation or execution artifact with full source citations and diffs. 4. Stage any mutating actions behind an explicit human approval gate and verify final state. ### 4. Copy-Paste Agent Execution Prompt ```markdown Execute the 'Automated Weekly Postgres Backup Restore & Checksum Drill' (devops-database-backup-restore-drill-verifier) blueprint with Postgres MCP, Neon MCP, Notion MCP. Goal: Spin up an ephemeral restore branch from nightly Postgres backups every Sunday, run row-count and foreign-key integrity checks, and log SOC2 proof. First inspect live state in read-only mode, validate all identifiers and metrics, and output a concrete action plan with verification commands before making any changes. ``` ### 5. Verification & Safety Guardrails - **Human-in-the-Loop Gate:** All external communications, production database mutations, and billing actions stage an explicit review diff before execution. - **Deterministic Telemetry:** Every run logs structured JSON output, latency metrics, and source citations so operators can audit every decision.

Tags: #postgres-mcp#neon-mcp#notion-mcp#blueprint#engineering

View All 27 Items by @rauchg →

template · ⚡ 83

Stagehand — Staging-First Web & CMS Integrator

Applies layout, copy, and plugin changes strictly on staging environments first, runs visual and HTTP checks, and never touches production unapproved.

mcp · ⚡ 86

Browserbase & Stagehand Cloud Headless Browser Fleet MCP

Run stealth, residential-proxied cloud browser sessions with session replay, persistent authentication contexts, and Stagehand natural-language DOM actions

use case · ⚡ 87

Cloudflare Workers & Pages Zero-Regression Cutover Verification Loop

Verifies preview deployment HTTP status codes, canonical SEO tags, JSON-LD schemas, and p95 edge latency before promoting a build to production.