📋 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 Offload audit and telemetry rows older than 90 days from primary Postgres into compressed ZSTD Parquet files on Cloudflare R2. Built and battle-tested in production workflows by **@rauchg** (Guillermo Rauch (@rauchg)). ### 2. Target Architecture & Required Stack - **Postgres MCP** - **Cloudflare MCP** - **GitHub MCP** ### 3. Step-by-Step Implementation Blueprint 1. Connect Postgres MCP, Cloudflare MCP, GitHub MCP and verify read-only access to the target workspace. 2. Run the discovery query for 'Hot Postgres to Cold R2 Parquet Nightly Archiver via DuckDB' 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 'Hot Postgres to Cold R2 Parquet Nightly Archiver via DuckDB' (data-postgres-to-duckdb-parquet-nightly-archiver) blueprint with Postgres MCP, Cloudflare MCP, GitHub MCP. Goal: Offload audit and telemetry rows older than 90 days from primary Postgres into compressed ZSTD Parquet files on Cloudflare R2. 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#cloudflare-mcp#github-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.