pgsandbox v0.5.0

PGSandbox 0.5.0 adds one-shot agent test sessions with explicit cleanup policies, bounded credential-redacted output, versioned JSON results, recoverable extension lifecycle auditing, and measured guidance for templates and large test suites.\n\nSee CHANGELOG.md for details.

pgsandbox v0.4.9

Highlights

• More reliable agent repo workflows, including database-id-first profile resolution, bounded stdin, Docker URL environment aliases, and explicit untracked-change semantics.
• Redacted and filterable command output, clearer expired listings, concise smoke-test results, and preserved output when commands time out.

See the changelog for details.

pgsandbox v0.4.8

Summary

• Renames the native package and CLI from pgsandbox-mcp to pgsandbox.
• Adds direct CLI parity for every public MCP tool, including hyphenated commands and shared JSON input support.
• Adds a safe uninstall command that cleans current and legacy client configuration entries.
• Aligns GitHub release assets and the Homebrew formula workflow with the renamed pgsandbox package.
• Includes new guides for Postgres MCP error handling and local Postgres version selection.

Verification

• npm run check
• npm test
• npm run build
• npm run site:check-changelog
• npm run package:homebrew
• npm run package:release
• SHA-256 verification for the release archives
• GitHub CI on PR #91: success

pgsandbox-mcp v0.4.7

Summary

• Exposes actionable local Postgres install diagnostics, including bounded installer output and next-step hints.
• Accepts managed-local profile names consistently when paired with matching postgresVersion.
• Classifies filtered clone archive transaction_timeout restore failures as restore compatibility errors.
• Adds clone timeoutSeconds handling, source size estimates, and structured cleanup state for long clone timeouts.

Verification

• cargo test
• npm run site:check-changelog
• npm run package:homebrew
• npm run package:release
• GitHub CI on main: success
• Site deploy on main: success

pgsandbox-mcp v0.4.6

Released pgsandbox-mcp 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.

pgsandbox-mcp v0.4.5

Released pgsandbox-mcp v0.4.5.

Highlights:

• Expanded managed local Postgres discovery through major version 13.
• Added the EXPLAIN plan agent SQL review guide and related site links.
• Refreshed pinned install examples for v0.4.5.

pgsandbox-mcp v0.4.4

Released pgsandbox-mcp v0.4.4.

Highlights:

• 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 and clone-source repair hints.
• Clearer agent workflow docs.

pgsandbox-mcp v0.4.3

Patch release with MCP response, schema, and diagnostics hardening.

Included since v0.4.2:

• Normalize MCP success and failure response envelopes while keeping workflow warnings discoverable.
• Return structured unknown-profile and unavailable-version errors with safer recovery hints.
• Migrate stored sandbox role passwords to encrypted metadata and keep connection-string exposure redacted by default.
• Split schema relation descriptions by relation kind and cover partitioned relation behavior.
• Improve repo command timeout classification, direct script hints, and compact doctor version diagnostics.
• Document comment-triggered ReviewGate setup and add the schema snapshot migration review guide.

pgsandbox-mcp v0.4.2

Patch release with safety, schema, and SQL-result hardening.

Included since v0.4.1:

• Redact additional connection-string exposure points in creation responses and debug output.
• Harden schema validation/snapshot command timeouts.
• Reject invalid zero and negative TTL values before lifecycle work.
• Preserve unsupported Postgres type nullability and provide clearer cast hints.
• Normalize run_sql int8 serialization, including negative values.
• Simplify schema introspection payloads while keeping legacy aliases available.
• Polish repo command validation errors.

pgsandbox-mcp v0.4.1

Patch release with the latest site content updates and Homebrew packaging metadata.

Included since v0.4.0:

• Added the Database Migration Testing Before Agent PRs blog post.
• Added the Postgres Template Databases vs Task Sandboxes blog post.
• Updated changelog metadata for the v0.4.1 release.