Searchable encryption comes to Postgres

Searchable encryption lands in Postgres

The biggest story of the week is that field-level encryption with search capability is now a first-class citizen on Postgres. Supabase's CipherStash integration lets you encrypt individual columns while still being able to filter, sort, and join on those values — all without ever decrypting them on the server. Setup is a single CLI command, and it works with Supabase.js, Drizzle, and Prisma out of the box. For any application handling PII, healthcare data, or financial records, this closes a longstanding gap: you no longer have to choose between encrypting data and querying it efficiently.

CLI commands built for agents

Across the three major platforms, this week's releases share a clear theme: CLIs are being redesigned for AI agent consumption. Neon's neon api command gives agents access to every Platform API route from the terminal using your existing CLI login, without managing raw API keys. The command surfaces all available endpoints via neon api --list and supports full HTTP method flags. PlanetScale went even further with a pscale sql command for non-interactive queries (read-only by default, destructive statements blocked without --force), plus a pscale agent-guide command that provides machine-readable bootstrap instructions covering CLI conventions, the hosted MCP server, and the PlanetScale API. Structured JSON error envelopes and next steps in workflow responses round out the agent-friendly tooling.

Supabase's July feature drop and client SDK fixes

Beyond encryption, Supabase's July 2026 release is packed: Wrappers v0.6.2 lets you query and join MongoDB collections directly from Postgres, Realtime Broadcast now supports binary payloads alongside JSON, and OpenCode integrates with Supabase for agentic coding workflows. TanStack DB syncs collections with Supabase tables in alpha, and Multigres now supports LISTEN/NOTIFY across pooled connections. On the client side, SDK v2.110.2 fixes a notable auth bug where signout failures could leave stale local sessions, while v2.110.1 defers auth initialization notifications to prevent race conditions and suppresses disconnected status events from Realtime heartbeat consumers.

PlanetScale adds Postgres replication and programmatic insights

PlanetScale's Postgres offering continues to mature. Postgres roles can now be created with the REPLICATION attribute through the API, dashboard, CLI, and Terraform provider, enabling logical replication and CDC setups. The new Query Insights API endpoints expose query statistics, errors, anomalies, and traffic budgets programmatically. And the CLI v0.295.0 adds a pscale import d1 command for offline Cloudflare D1 migration, with hardened parsing and resume flows.

Prisma Next documentation expands

Prisma Next's documentation now covers fundamentals, data modeling, migrations, middleware and extensions, contract authoring, and a full API reference — a significant expansion that makes the new schema engine more approachable. The schema also now reads native PostgreSQL enums directly.