📋 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 Export weekly cryptographic proof of PR approvals, production branch protections, and database encryption to Notion and Google Drive. Built and battle-tested in production workflows by **@simonw** (Simon Willison (@simonw)). ### 2. Target Architecture & Required Stack - **GitHub MCP** - **Supabase MCP** - **Notion MCP** - **Google Drive MCP** ### 3. Step-by-Step Implementation Blueprint 1. Configure and authenticate the required MCP connectors (GitHub MCP, Supabase MCP, Notion MCP, Google Drive MCP) in your agent workspace. 2. Run the initial read-only inspection pass for 'Automated SOC2 Type II Continuous Evidence Collection' to gather baseline telemetry, schemas, and context. 3. Execute the multi-step analysis and transformation pipeline with strict schema validation and zero fabricated identifiers. 4. Review the staged diff or approval card and verify completion via automated regression and status checks. ### 4. Copy-Paste Agent Execution Prompt ```markdown Run the 'Automated SOC2 Type II Continuous Evidence Collection' (soc2-type2-continuous-github-and-cloud-evidence) implementation blueprint using GitHub MCP, Supabase MCP, Notion MCP, Google Drive MCP. Objective: Export weekly cryptographic proof of PR approvals, production branch protections, and database encryption to Notion and Google Drive. Step 1: Perform a read-only audit of current state and recent logs. Step 2: Generate a deterministic execution plan with exact diffs, SQL/CLI commands, or drafted payloads. Step 3: Request human confirmation before applying any production writes or external sends. ``` ### 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: #github-mcp#supabase-mcp#notion-mcp#blueprint#security-ops

View All 37 Items by @simonw →

mcp · ⚡ 80

PostgreSQL Read/Write & Schema Introspection MCP Server

Connect AI agents directly to PostgreSQL databases for live table schema inspection, `EXPLAIN ANALYZE` query benchmarking, and safe read-only or transactio

mcp · ⚡ 93

SQLite & Datasette Local Analytics & Schema MCP Server

Query local SQLite databases, run full-text FTS5 searches, create analytical views, and synthesize structured data memos directly from your agent workspace

mcp · ⚡ 79

PostgreSQL Analytics & Read-Replica Inspector MCP (mcp-postgres)

Zero-mutation PostgreSQL read-replica MCP server enforcing `SET TRANSACTION READ ONLY` on every query for safe executive BI, cohort analysis, and schema ex