Agent-First PSQL Blog

Updates, deep-dives, and release notes for Agent-First PSQL.

Design

Design

Agent-First PSQL v0.5: A PostgreSQL Connector Designed from the Agent Side

The v0.5 afpsql line asks what a PostgreSQL connector should look like when the primary caller is an agent: structured state, explicit permissions, stable sessions, and local control over remote databases.

Release notes

Release

Agent-First PSQL v0.6.3: Look Before You Touch

v0.6.3 gives an agent everything it needs to understand a database before changing it: `afpsql inspect` for schema discovery, `--dry-run` to prepare and validate a statement without running it, `--explain` / `--explain-analyze` for the query plan, and pipe-mode `begin`/`commit`/`rollback` for explicit multi-statement transactions with savepoint-isolated failures. It also soft-truncates oversized inline results instead of erroring, and ships correctness fixes for query cancellation, value decoding (bytea and arrays), and NUMERIC bind precision.

 Release

Agent-First PSQL v0.6.2: Container Transport Family and Self-Describing Sessions

v0.6.2 generalizes the docker transport into a container transport family (podman, nerdctl, compose, kubectl) with structured scope flags and SSH chaining, adds a session_info pipe request so agents can introspect their session's transport, permission default, and limits instead of probing with failing queries, and surfaces two new log events for implicit behaviors that previously had to be inferred.

 Release

Agent-First PSQL v0.6.1: Embedded Skill Installer and SQLSTATE on Connect

v0.6.1 ships the Agent-First PSQL skill inside the binary so Claude Code and Codex can install it with one command, and preserves PostgreSQL SQLSTATE plus message, detail, and hint on connect_failed so agents can distinguish auth, role, database, capacity, and startup failures without parsing prose.

 Release

Agent-First PSQL v0.6: SSH Transport and Explicit Write Permissions

v0.6 adds an SSH transport that keeps the agent local while reaching server-only PostgreSQL, and splits write permission into separate direct and SSH families so an agent cannot silently turn a read across a boundary into a remote write.

 Release

Agent-First PSQL v0.4: A Native Runtime with Complete Help

The v0.4 line removed MCP server mode, generated CLI docs from the source command definition, and made --help complete for agents.

 Release

Agent-First PSQL v0.3.1: Output Policy Protected SQL Rows

The v0.3.1 update separated SQL payloads from output-layer redaction and preserved row structure across JSON, YAML, plain, and MCP responses.

 Release

Agent-First PSQL v0.2.1: SQL Became Previewable

The v0.2.1 update added dry-run SQL previews, actionable error hints, and better config invalidation for stateful sessions.

 Release

Agent-First PSQL v0.1: SQL Queries as Structured Events

The first Agent-First PSQL release line: PostgreSQL rows, timing, and SQLSTATE failures as machine-readable events instead of terminal prose.