changelog

Changes by date.

Generated from CHANGELOG.md. Each section is grouped under a YYYY-MM-DD date.

Changes for 2026-11-02

  • Added a checked PostgreSQL 15 plan-to-result walkthrough to the existing EXPLAIN guide: scoped fixture, selective/broad plan control, bounded-read interpretation, and verified explicit teardown. Clarified that TTL expiry alone does not delete databases; no runtime behavior changed.

Changes for 2026-11-01

  • Added a checked Prisma 6 shadow-database workflow to the existing migration-testing guide: separate scoped target/shadow sandboxes, versioned configuration, permission/drift/replay failure controls, and independent cleanup. Clarified Prisma command-version boundaries; no runtime behavior changed.

Changes for 2026-10-30

  • Added a checked, extension-free backfill assertion and deliberately failing control to the migration-testing guide. Documented psql error propagation, separate command/cleanup results, pgTAP runner prerequisites, and explicit expiry cleanup. No runtime behavior changed.

Changes for 2026-10-27

  • Added a checked single-worker pytest-django adapter to the existing integration-test guide: migrate the injected sandbox without granting CREATEDB, preserve test isolation, and verify session cleanup. Documented version and application/parallel-test limits; no runtime behavior changed.

Changes for 2026-10-26

  • Added version-matched first-run checks and explicit session/retained-database closeout to the connection-pool failure guide. Clarified expiry versus deletion in the cancellation guide and CLI recipe; existing driver harnesses, titles, and runtime behavior are unchanged.

Changes for 2026-10-25

  • Added version-matched runtime readiness and an explicit retained-sandbox recovery path to the serialization-retry guide. Clarified expiry versus deletion across related test guides and the owner-label evidence template; titles and SQL harnesses are unchanged. No runtime behavior changed.

Changes for 2026-10-24

  • Added a source-aware first-clone walkthrough to the existing Postgres clone guide: runtime/client readiness, schema-only request, bounded destination verification, and explicit cleanup. Clarified that schema-only copying is not sanitization and corrected TTL-only deletion wording in the clone guide and related local-extension guide. No runtime behavior changed.

Changes for 2026-10-23

  • Added a read-only inspection versus disposable-write decision guide to the existing Postgres MCP safety checklist, including honest existing-database tradeoffs and a scoped install-to-cleanup path. No runtime or analytics behavior changed.

Changes for 2026-10-22

  • Added a verified missing-column recovery walkthrough to the existing MCP error-handling guide: schema inspection, corrected readonly query, bounded-result interpretation, and explicit sandbox deletion. No runtime or analytics behavior changed.

Changes for 2026-10-21

  • Removed PostHog error tracking: runtime failures no longer emit $exception events and the website disables posthog-js exception autocapture. Product analytics, logs, traces, AI spans, and session replay are unchanged.

Changes for 2026-10-20

  • Added version-matched runtime readiness checks to the disposable integration-test guide, distinguishing a smoke test from application-suite proof.
  • Corrected retained-database TTL and cleanup instructions in the integration-test guide, related deadlock guide, and CLI recipe; no runtime behavior changed.
  • Updated SEO analytics locators to the existing PostHog project; historical observations are unchanged.

Changes for 2026-10-19

  • Added installation/runtime-readiness guidance and concrete MCP snapshot/diff requests to the schema-snapshot migration-review guide.
  • Clarified snapshot-before-database teardown and explicit expired cleanup, including the related migration-review evidence template; no runtime behavior changed.

Changes for 2026-10-18

  • Added installation and versioned runtime checks to the partial-index testing guide, separating smoke-test readiness from index proof and making cleanup outcomes explicit.
  • Clarified the managed-local PostgreSQL default in nine related proof-guide introductions; external profiles remain optional. No SQL harness or runtime behavior changed.

Changes for 2026-10-16

  • Build and push the website Docker image on the self-hosted runner, then deploy the commit-tagged image to CapRover instead of rebuilding there.
  • Moved website deployment to the isolated self-hosted runner VM with a dedicated PGSandbox registration, main-only execution, read-only repository permissions, and a bounded job timeout.
  • Added an installation and runtime-readiness path to the extension-upgrade guide, distinguishing a smoke test from extension-specific compatibility proof.
  • Clarified that TTL requires explicit expired-sandbox cleanup or a user-owned scheduler; no runtime behavior changed.

Changes for 2026-10-10

  • Corrected the Testcontainers comparison to describe managed-local PostgreSQL as the default, optional external profiles, and explicit expired-sandbox cleanup.
  • Added a direct installation and runtime-verification path without changing the comparison title or runtime behavior.

Changes for 2026-10-09

  • Added a Claude Code stdio registration walkthrough to the install guide, distinguishing it from Claude Desktop setup and separating runtime checks from agent tool verification.
  • Linked the Claude Code setup path from the docs hub; no runtime or analytics behavior changed.

Changes for 2026-10-08

  • Added IndexNow ownership verification and automatic sitemap submission after verified live website deployments.
  • Expanded the install guide with Cursor project/user setup, a first disposable-database check, cleanup guidance, and targeted troubleshooting.
  • Made the Cursor walkthrough discoverable from the documentation hub; no runtime or analytics behavior changed.

Changes for 2026-10-07

  • Added content-free CLI/MCP operation logs, correlated OTLP traces, grouped runtime failure events, and metadata-only MCP AI spans in the existing PostHog project.
  • Kept runtime opt-outs and bounded delivery; added explicit public-token/host overrides and QA tagging for verification.
  • Added private source-map uploads for website error tracking and documented the observability boundaries.

Changes for 2026-10-06

  • Replaced retired website analytics with PostHog pageviews, interactions, setup-prompt outcomes, outbound/docs clicks, web vitals, and browser errors.
  • Added one CLI invocation completion event across command paths, including failures, without capturing raw arguments.
  • Added website/CLI/MCP source dimensions and bounded MCP telemetry shutdown draining, retaining existing opt-outs.

Changes for 2026-09-24

  • Replaced internal editorial labels with direct technical explanations in 19 existing guides, preserving examples, sources, and URLs.
  • Updated the corrected guides’ modification dates and added a scoped content-language check.

Changes for 2026-09-21

  • Corrected extension-provisioning authority, profile allowlist, and ownership guidance across four existing blog guides.
  • Distinguished lifecycle-admin extension setup from restricted application SQL and updated the guides' modification dates.

Changes for 2026-09-20

  • Corrected website and guide claims about managed local PostgreSQL, supported package-manager installation, and explicit expired-sandbox cleanup.
  • Recorded content-specific modification dates for the corrected pages.
  • Completed the unified SEO foundation and private history migration while preserving legacy source records and analytics identity.

Changes for 2026-09-19

  • Fixed website 404 responses and proxy-safe trailing-slash redirects after the pgsandbox.dev migration.
  • Published the maintained agent workflow documentation on the website, linked it from the docs hub and navigation, and included it in the sitemap.
  • Updated documentation search descriptions, removed unrelated blog dates from static sitemap entries, and aligned SEO configuration and positioning with the current domain and local runtime.
  • Included the prebuilt site output in the Docker build context required by the production image.
  • Added production-container routing checks for missing pages, HTTPS-origin redirects, and the restored workflow guide.

Changes for 2026-08-01

  • Added the Astro Markdown guide "How to Test PostgreSQL Two-Phase Commit" with a deterministic Psycopg prepared-transaction harness, PostgreSQL and Psycopg primary-source citations, SEO ledger and link inventory updates, and inbound blog links.

Changes for 2026-07-31

  • Added the Astro Markdown guide "How to Test PostgreSQL Foreign Key Cascades" with a deterministic Psycopg referential-action harness, PostgreSQL and Psycopg primary-source citations, SEO ledger and link inventory updates, and inbound blog links.

Changes for 2026-07-30

  • Added the Astro Markdown guide "How to Test PostgreSQL Transaction Isolation Levels" with a deterministic Psycopg snapshot/write-skew harness, PostgreSQL and Psycopg primary-source citations, SEO ledger and link inventory updates, and inbound blog links.

Changes for 2026-07-29

  • Added the Astro Markdown guide "How to Test Postgres Advisory Locks Safely" with a deterministic two-connection Psycopg harness, PostgreSQL and Psycopg primary-source citations, SEO ledger and link inventory updates, and inbound blog links.

Changes for 2026-07-28

  • Added the Astro Markdown guide "How to Test Postgres Row-Level Security in a Disposable Database" with a deterministic Psycopg harness, PostgreSQL and Psycopg primary-source citations, SEO ledger and link inventory updates, and inbound blog links.

Changes for 2026-07-27

  • Added the Astro Markdown guide "How to Test Postgres Savepoints and Partial Rollbacks" with a deterministic Psycopg harness, PostgreSQL and Psycopg primary-source citations, SEO ledger and link inventory updates, and inbound blog links.

Changes for 2026-07-26

  • Added the Astro Markdown guide "How to Test Postgres Statement Timeouts and Query Cancellation" with a deterministic Psycopg harness, PostgreSQL and Psycopg primary-source citations, SEO ledger and link inventory updates, and inbound blog links.

Changes for 2026-07-25

  • Added the Astro Markdown guide "How to Test Postgres Serialization Failures and Retries" with a deterministic Psycopg harness, PostgreSQL primary-source citations, SEO ledger and link inventory updates, and inbound blog links.

Changes for 2026-07-24

  • Added the Astro Markdown guide "How to Test Postgres Connection Pool Failures Safely" with a deterministic node-postgres harness, PostgreSQL and driver primary-source citations, SEO ledger and link inventory updates, and inbound blog links.

Changes for 2026-07-23

  • Added the Astro Markdown guide "How to Test Postgres Deadlocks and Lock Timeouts Safely" with a deterministic two-connection harness, PostgreSQL primary-source citations, SEO ledger and link inventory updates, and inbound blog links.

Changes for 2026-07-22

  • Added the Astro Markdown guide "Run Integration Tests in a Disposable Postgres Database" with PostgreSQL primary-source citations, measured session-partition evidence, SEO ledger and link inventory updates, and inbound blog links.

Changes for 2026-07-21

  • Released pgsandbox v0.5.0 with one-shot agent test sessions, explicit cleanup policies, versioned credential-free results, recoverable extension lifecycle audits, and measured guidance for templates and large suites.
  • Added pgsandbox with-database for one-shot agent test sessions with PostgreSQL version and extension selection, explicit cleanup policies, signal/timeout exit translation, bounded credential-redacted child output, and versioned JSON results.
  • Added credential-free per-extension lifecycle audit outcomes, including clone provenance and rollback cleanup status.
  • Documented measured template and large-suite tradeoffs, including the Rowset frontend-build prerequisite and when fresh-sandbox partitioning is worthwhile.
  • Changed requested extension installation to run through PGSandbox's admin lifecycle while keeping returned sandbox roles non-superuser and without CREATEDB.
  • Added profile-level allowedExtensions authorization for privileged extension installation; managed-local profiles include a small built-in allowlist and explicit profiles default to none.
  • Fixed --postgres-version for sandbox CLI tool commands so numeric major versions retain the string type expected by the MCP contract.
  • Added the Astro Markdown blog post "How to Test pg_stat_statements in Agent Sandboxes" with PostgreSQL primary-source citations, an observability-boundary testing framework, SEO ledger and link inventory updates, and inbound blog links.

Changes for 2026-07-20

  • Added the Astro Markdown blog post "How to Test PostgreSQL Extension Upgrades Safely" with primary-source citations, a two-lane upgrade comparison, SEO ledger and link inventory updates, and inbound blog links.

Changes for 2026-07-19

  • Added the Astro Markdown blog post "How to Test PostgreSQL Extensions in Disposable Sandboxes" with SEO ledger, link inventory, primary-source citations, and inbound blog links.

Changes for 2026-07-18

  • Added the Astro Markdown blog post "Connect a Docker Container to Host PostgreSQL Safely" with SEO ledger, link inventory, inbound blog links, and a complete migration of repo-authored site URLs to the production domain.

Changes for 2026-07-17

  • Added the Astro Markdown blog post "PostgreSQL ROLE vs USER for Agent Database Access" with SEO ledger, link inventory, and inbound blog links.

Changes for 2026-07-16

  • Added the Astro Markdown blog post "Per-Sandbox Postgres Roles for Coding Agents" with SEO ledger, link inventory, and inbound blog links.

Changes for 2026-07-15

  • Added the Astro Markdown blog post "Postgres Sandbox Quotas for Coding Agents" with SEO ledger, link inventory, and inbound blog links.

Changes for 2026-07-14

  • Added the Astro Markdown blog post "Postgres Test Database Cleanup: Choosing Sandbox TTLs" with SEO ledger, link inventory, and inbound blog links.

Changes for 2026-07-13

  • Added the Astro Markdown blog post "Owner and Label Policy for Shared PGSandbox Profiles" with SEO ledger, link inventory, and inbound blog links.

Changes for 2026-07-12

  • Added the Astro Markdown blog post "cleanup_expired vs Manual Postgres Cleanup for Agent Sandboxes" with SEO ledger, link inventory, and inbound blog links.

Changes for 2026-07-11

  • Added the Astro Markdown blog post "How to Use cleanup_expired for Stale PGSandbox Resources" with SEO ledger, link inventory, and inbound blog links.
  • Released pgsandbox v0.4.9 with more reliable agent repo workflows: database-id-first profile resolution, bounded stdin, Docker URL env aliases, explicit untracked-change semantics, redacted/filterable command output, clearer expired listings, concise smoke-test results, and preserved command output on timeout.

Changes for 2026-07-10

  • Improved agent repo workflows with database-id-first profile resolution, bounded stdin, Docker URL env aliases, explicit untracked-change semantics, redacted/filterable command output, clearer expired listings, and concise smoke-test results.
  • Released pgsandbox v0.4.8 with the renamed pgsandbox CLI and package, CLI parity for the public MCP tools, safe uninstall support, and aligned GitHub release and Homebrew packaging.
  • Added the Astro Markdown blog post "How to Use Local Postgres Versions with Coding Agents" with SEO ledger, link inventory, and inbound blog links.

Changes for 2026-07-09

  • Added the Astro Markdown blog post "Postgres MCP Server Error Handling for Coding Agents" with SEO ledger, link inventory, and inbound blog links.

Changes for 2026-07-08

  • Released pgsandbox v0.4.7 with actionable local Postgres install diagnostics, consistent managed-local profile resolution, restore compatibility classification for filtered clone archives, and structured clone timeout cleanup details.
  • Added the Astro Markdown blog post "How to Run Agent SQL with Bounded Postgres Results" with SEO ledger, link inventory, and inbound blog links.

Changes for 2026-07-07

  • Released pgsandbox v0.4.6 with the upgrade command, sandbox extension workflows, resolved target version fields, managed-local auto-install helpers, clone/restore compatibility fixes, extension discovery, and Docker connection variants.
  • Released pgsandbox v0.4.5 with local Postgres discovery expanded through major version 13 and the new EXPLAIN plan agent SQL review guide.
  • Added the Astro Markdown blog post "How to Use Postgres EXPLAIN Plans for Agent SQL Review" with SEO ledger, link inventory, and inbound blog links.

Changes for 2026-07-06

  • Released pgsandbox v0.4.4 with simplified managed-local onboarding, scoped expired cleanup filters, typed multi-statement run_sql result sets, stricter readonly and row-limit validation, classified explain_query statement errors, clone-source repair hints, and clearer agent workflow docs.
  • Released pgsandbox v0.4.3 with normalized MCP response envelopes, structured unknown-profile errors, encrypted sandbox role password migration, split schema relation descriptions, tighter repo command timeout hints, compact doctor version diagnostics, and updated ReviewGate setup guidance.
  • Added the Astro Markdown blog post "How to Use Postgres Schema Snapshots for Agent Migration Reviews" with SEO ledger, link inventory, and inbound blog links.

Changes for 2026-07-05

  • Released pgsandbox v0.4.2 with safer connection-string redaction, schema command timeout hardening, repo command validation polish, normalized run_sql int8 serialization, unsupported-type nullability handling, invalid TTL rejection, and simpler schema introspection payloads.
  • Released pgsandbox v0.4.1 with the latest site content updates and Homebrew packaging metadata.
  • Added the Astro Markdown blog post "Database Migration Testing Before Agent PRs" with SEO ledger, link inventory, and inbound blog links.
  • Added the Astro Markdown blog post "Postgres Template Databases vs Task Sandboxes" with SEO ledger, link inventory, and inbound blog links.

Changes for 2026-07-03

  • Released pgsandbox v0.4.0 with generic agent-first repo workflow tools, bounded schema validation and snapshot timeouts, MCP doctor, SQLSTATE-aware errors, safer connection-string redaction, richer run_sql metadata, cross-profile database-name lookup, and opt-in dogfood reliability coverage.
  • Added the Astro Markdown blog post "Testcontainers vs Disposable Postgres Sandboxes for Agent Work" with SEO ledger, link inventory, and inbound blog links.

Changes for 2026-07-02

  • Added the Astro Markdown blog post "How to Create a Postgres Test Database for Agent SQL" with SEO ledger, link inventory, and inbound blog links.

Changes for 2026-07-01

  • Released pgsandbox v0.3.0 with agent-safe cross-profile databaseId lookup, all-version list/cleanup modes, clone downgrade preflight, structured version diagnostics, and regression coverage for the agent-facing version contract.
  • Released pgsandbox v0.2.1 with managed-local diagnostics, deferred MCP startup, short Unix socket paths, structured tool errors, and updated agent-facing docs.
  • Released pgsandbox v0.2.0 with managed local multi-version Postgres support.
  • Added the Astro Markdown blog post "What Is a Database Sandbox?" with SEO ledger, link inventory, and inbound blog links.
  • Updated existing blog posts to link to the new database sandbox definition page.
  • Added managed local multi-version Postgres runtime support with --postgres-version, PGSANDBOX_POSTGRES_VERSION, versioned local-pg<major> profiles, isolated data directories, and version-specific binary discovery.
  • Added MCP postgresVersion selectors, list_profiles, and repo workflow inference from .pgsandbox/project.json, Compose, and devcontainer Postgres image tags.

Changes for 2026-06-30

  • Added the Docker-safe managed local Postgres runtime with init/start/stop/status helpers, free-port selection, health checks, and local profile persistence.
  • Added lifecycle audit logging, local/private safety policy checks, allowed-host validation, per-owner sandbox quotas, and explicit external-admin opt-ins.
  • Added repo workflow tools for preparing repos, running and validating migrations, seeding databases, and returning compact schema diffs.
  • Added schema snapshot and local template workflows for repeatable agent database checkpoints, diffs, exports, restores, and cleanup.
  • Expanded install, MCP client, no-Docker quickstart, troubleshooting, workflow, template, and snapshot documentation.
  • Added the Astro Markdown blog post "How to Clone a Postgres Database Into a Safe Sandbox" with SEO ledger, link inventory, and inbound blog links.
  • Updated the SEO foundation to reflect Astro Markdown blog files as the current source of truth.

Changes for 2026-06-29

  • Added a site build check for accessible Markdown table scroll wrappers on blog posts.
  • Added a site content check that requires explicit blog post publication status.
  • Moved the two published site blog posts out of Rowset and into Astro-managed Markdown content files.
  • Added the database branching comparison brief and SEO ledger updates for the Rowset-backed blog.
  • Added the initial SEO content foundation with brand guidance, Rowset blog configuration, internal link inventory, keyword research baseline, and candidate backlog for future PGSandbox blog posts.
  • Updated the site deployment path so Rowset-backed blog pages are built in GitHub Actions before CapRover serves the static output.

Changes for 2026-06-19

  • Hardened the Astro site build by pinning Node 24.15.0 and upgrading to Astro 6 with explicit overrides for patched transitive build tooling: esbuild, volar-service-yaml, yaml-language-server, and yaml.
  • Improved site navigation accessibility with 44px minimum interactive targets, safe-area viewport handling, current-page state on the home link, and location state for the top-level docs link on nested docs pages.

Changes for 2026-06-14

  • Added an auto-generated site changelog page sourced from CHANGELOG.md and linked it from the site footer.
  • Added database cloning support with hardened clone errors and TLS parameter forwarding.
  • Simplified the homepage call to action around the agent setup prompt and docs.
  • Added a homepage flow for copying the agent-assisted setup prompt.
  • Reduced setup prompt interaction so agents can proceed automatically when a safe local configuration is discoverable.

Changes for 2026-06-13

  • Added release automation to open Homebrew tap update PRs with versioned release asset URLs and SHA256 checksums.
  • Added a GitHub release installer script for downloading and installing platform-specific binaries.
  • Rewrote the MCP server as a Rust native binary with local Postgres profile support.
  • Added agent-assisted setup prompt guidance for installing, configuring, and verifying PGSandbox.
  • Added a static Astro marketing/docs site under site/ with a futuristic landing page, getting-started docs, Docker/CapRover packaging, and a GitHub Actions deployment workflow for main-branch updates.
  • Renamed the product direction to PGSandbox and removed the default "experiment" framing from user-facing docs.
  • Added AI steering files for product, technical, structure, vision, and design guidance.

Changes for 2026-05-28

  • Added MCP client setup commands for Codex, Cursor, VS Code, Claude Desktop, and all supported clients.
  • Added a TypeScript/npm MCP server v0 with local Postgres profile support.
  • Added database lifecycle, SQL execution, schema inspection, listing, and TTL cleanup tool implementations.
  • Added CI, Cargo checks, and unit tests for configuration and name handling.
  • Added initial repository scaffold for a local Postgres experimentation MCP.
  • Documented v0 scope, MCP tool contract, architecture, safety rules, and local Postgres baseline.