NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
Go modules
Go modules, #2078 by repository stars
Latest stable
v1.0.9
Last release 3 months ago
06 Aug 2026
Release timing varies
gaps range from 8 days to 6 months
Nearly every release is documented
notes for 22 of 22 stable releases
Nothing withdrawn
no release was ever pulled
3 years old
57 releases · first in 2023
Drag across the ruler to compare, or tap a release to open it.
During plan validation, setSchemaForEmptyDatabase reconstructs the source schema in a temporary database. For materialized views, the Add() method pre
During plan validation, setSchemaForEmptyDatabase reconstructs the source schema in a temporary database. For materialized views, the Add() method previously emitted CREATE MATERIALIZED VIEW ... AS <query> without WITH NO DATA, causing Postgres to execute the view's stored query. This is unnecessary (the temp DB is discarded immediately) and potentially unsafe.
WITH NO DATA to all CREATE MATERIALIZED VIEW DDL generated during schema reconstructionpg_get_viewdef() output to prevent syntax errors when appending WITH NO DATApkg/diff/materialized_view_sql_generator.gopkg/diff/schema_migration_plan_test.go (3 new unit tests)Full PR: #305
Fixes search_path shadowing in bigint-to-timestamp column migrations (CVE-2018-1058, #298).
Fixes search_path shadowing in bigint-to-timestamp column migrations (CVE-2018-1058, #298).
USING clause (sql_generator.go)When migrating a bigint column to timestamp without time zone, pg-schema-diff emits a to_timestamp() call in the ALTER COLUMN ... USING clause. An unqualified call resolves via search_path, so a user with CREATE on a schema can plant shadow functions that run during apply instead of the built-ins.
Fix: emit a fully qualified expression:
pg_catalog.to_timestamp(
col::pg_catalog.float8 OPERATOR(pg_catalog./) 1000.0::pg_catalog.float8
)
Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v1.0.7...v1.0.8
Your coding agent can read these notes before it upgrades. Set up the MCP server →
Fixes two additional SQL injection sinks identified via the same root cause as v1.0.6 (enum labels, #295). Schema-derived values were re-emitted into
Fixes two additional SQL injection sinks identified via the same root cause as v1.0.6 (enum labels, #295). Schema-derived values were re-emitted into generated DDL without proper escaping.
policy_sql_generator.go)AppliesTo role names (sourced from pg_roles.rolname) were interpolated raw into CREATE POLICY ... TO and ALTER POLICY ... TO statements. A user with CREATEROLE privilege could plant a role whose name contains an embedded double-quote to inject arbitrary SQL during plan execution.
Fix: Added escapeRoleNames() helper that applies EscapeIdentifier to each role name, preserving PUBLIC as an unquoted SQL keyword.
schema.go buildProcName)The function used hand-rolled quoting (fmt.Sprintf("\"%s\"(%s)", name, ...)) that did not double embedded double-quotes. A user with CREATE FUNCTION privilege could create a function with " in its name to inject SQL when DROP FUNCTION/DROP PROCEDURE statements are generated.
Fix: Replaced the hand-rolled quoting with EscapeIdentifier(name).
Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v1.0.6...v1.0.7
Escapes enum labels in generated SQL to prevent a second-order SQL injection.
Escapes enum labels in generated SQL to prevent a second-order SQL injection.
Enum labels were interpolated into generated DDL using raw fmt.Sprintf("'%s'", val). A label containing a single quote could break out of the string literal and inject arbitrary SQL, which then executes with the plan runner's (often superuser) privileges when pg-schema-diff generates migration SQL — enabling RCE via COPY ... TO PROGRAM.
All three enum sinks (CREATE TYPE ... AS ENUM, ALTER TYPE ... ADD VALUE, and the BEFORE ordering clause) now route through a new EscapeLiteral helper that doubles single quotes and strips null bytes.
See #295 for details and test evidence.
Recommendation: upgrade to v1.0.6, especially if you run pg-schema-diff against databases where lower-privileged users can create enum types.
Table privilege support by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/264
Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v1.0.4...v1.0.5
Dump command prototype by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/263
Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v1.0.3...v1.0.4
Materialized view index support by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/262
Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v1.0.2...v1.0.3
Nothing published for this version
Ensure command prints to stdout by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/245
Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v1.0.1...v1.0.2
Update readme by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/240
GENERATED ALWAYS AS columns to reduce migration failures (#212) by @lmcrean in https://github.com/stripe/pg-schema-diff/pull/232Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v1.0.0...v1.0.1
Nothing published for this version
Nothing published for this version
Releasing first major version, since the API has stabilized.
Releasing first major version, since the API has stabilized.
Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.9.3...v1.0.0
Add materialized views MVP by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/229
sql output format by @velagent in https://github.com/stripe/pg-schema-diff/pull/235Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.9.2...v0.9.3
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Add basic VIEW support by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/226
VIEW support by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/226Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.9.1...v0.9.2
[FEATURE] Add support for --from-dir and providing a dedicated temporary database server by @bplunkett-stripe in https://github.com/stripe/pg-schema-d
--from-dir and providing a dedicated temporary database server by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/199Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.9.0...v0.9.1
Nothing published for this version
Adding identity to column with default by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/183
Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.8.0...v0.9.0
Nothing published for this version
Nothing published for this version
Nothing published for this version
Update Acceptance Tests - Flatten specs by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/136
Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.7.0...v0.8.0
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Use logfmt for plan modifiers by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/109
Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.6.0...v0.7.0
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
New interface for generating plans (Generate). GeneratePlan is now deprecated.
publicGenerate). GeneratePlan is now deprecated.Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.5.0...v0.6.0
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Allow root db to be something other than postgres in temp db factory by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/79
SET NOT NULL by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/83NOT NULL statement generation. Update README by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/89Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.4.0...v0.5.0
Nothing published for this version
Add lock timeout modifier by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/61
Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.3.0...v0.4.0
Nothing published for this version
Nothing published for this version
Add basic Extension support. by @alexrhee-stripe in https://github.com/stripe/pg-schema-diff/pull/43
Extension support. by @alexrhee-stripe in https://github.com/stripe/pg-schema-diff/pull/43Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.2.0...v0.3.0
Add sequence support by @bplunkett-stripe in https://github.com/stripe/pg-schema-diff/pull/35
Full Changelog: https://github.com/stripe/pg-schema-diff/compare/v0.1.0...v0.2.0
Nothing published for this version
Initial release. The exposed library API is subject to change; however, the CLI should be mostly stable.
Initial release. The exposed library API is subject to change; however, the CLI should be mostly stable.
Full Changelog: https://github.com/stripe/pg-schema-diff/commits/v0.1.0
One column per quarter.