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

⚡ 1-Click Agent & Developer Install

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

### 1. The Workflow Bottleneck & Problem Statement Running unbenchmarked SQL migrations directly against staging or production risks table locks and sudden query plan regressions. ### 2. Synthesized Agent Architecture & Connected Stack **Automated PR Database Migration Benchmarking on Ephemeral Neon Branches** (`neon-ephemeral-branch-migration-tester`) is a verified production blueprint curated from **@mattpocockuk**'s real-world implementation. - **Primary Capability:** Spins up an isolated copy-on-write Neon Postgres branch for every PR containing SQL migrations, runs `EXPLAIN ANALYZE` benchmarks, and comments on the PR. - **Connected Tool Stack:** Neon Serverless Postgres MCP, GitHub MCP, Postgres MCP - **Execution Governance:** `Read-Only Discovery` → `Deterministic Policy Check` → `Ask-First Human Approval` - **Certified Builder Source:** [@mattpocockuk](https://github.com/neondatabase/mcp-server-neon) ### 3. Step-by-Step Implementation Blueprint 1. **Trigger & Data Ingestion:** Configure your agent routine to watch **Neon Serverless Postgres MCP** on a scheduled cadence or event webhook. Treat all external text as untrusted data inside XML fences. 2. **Cross-System Enrichment & Verification:** Query **GitHub MCP** to validate live capacity, account status, or code state before generating recommendations. 3. **Human-in-the-Loop Action Staging:** Post a structured summary card to **Postgres MCP** with 1-click approve/edit controls so your team retains full oversight. ### 4. Copy-Paste System Prompt & Routine Configuration ```text Implement the 'Automated PR Database Migration Benchmarking on Ephemeral Neon Branches' workflow curated with @mattpocockuk. 1. OBJECTIVE: Spins up an isolated copy-on-write Neon Postgres branch for every PR containing SQL migrations, runs `EXPLAIN ANALYZE` benchmarks, and comments on the PR. 2. CONNECTED TOOL STACK: Neon Serverless Postgres MCP, GitHub MCP, Postgres MCP 3. STEP-BY-STEP EXECUTION LOOP: - Step A (Ingest & Ground): Query live inputs from Neon Serverless Postgres MCP and cross-reference state in GitHub MCP. - Step B (Analyze & Validate): Apply strict filtering rules, verify schema/policy constraints, and flag any anomalies or missing fields. - Step C (Stage & Report): Prepare the structured output, draft replies/tickets in Postgres MCP, and request human confirmation before executing any external send or production write. ``` ### 5. Measured ROI & Production Impact - **Verified Outcome:** Verifies every schema migration against production-scale data clones with zero risk to live traffic. - **Builder Portfolio:** [Explore all capabilities by @mattpocockuk →](/u/mattpocockuk)

Tags: #neon-ephemeral-branch-migration-tester#use-case#engineering#mattpocockuk#neon-serverless-postgres-mcp#github-mcp

View All 9 Items by @mattpocockuk →

mcp · ⚡ 93

Neon Serverless Postgres Branching & Instant Read-Clone MCP

Official Neon Serverless Postgres MCP server: create ephemeral database branches for testing migrations, run SQL queries, and compare branch schema diffs.

use case · ⚡ 83

End-to-End API Schema & OpenAPI Contract Drift Enforcer

Audits backend route handlers, Zod schemas, and frontend fetch clients on every PR to prevent undocumented breaking API changes.

skill · ⚡ 86

Prisma & Drizzle Zero-Downtime Expand/Contract Migration Skill

Execute expand-and-contract Postgres schema migrations without table locks: nullable column addition, batched background backfill, concurrent index creatio