• Skip to main content
  • Skip to secondary menu
  • Skip to footer

Market Analysis

Connecting the Dots, Quantifying Technology Trends & Measuring Disruption

  • AI Market Analyzer
  • Tech News
    • Project Dashboard
  • Domain Marketplace
  • Sponsored Post
  • About
  • Contact

ForgeSchema Plans PostgreSQL Schema Changes in Advance, Applies Them in One Transaction and Checks the Result

September 19, 2026

Schema changes are where databases get hurt. A migration drops a column someone still used. A type change locks a big table at the worst moment. A tool decides to “tidy up” and removes something nobody asked it to touch. And after it’s all done, nobody is quite sure the database matches what the team thinks it looks like.

ForgeSchema is a PostgreSQL schema evolution engine written in Go, built around four steps: inspect, plan, apply and verify. It explains every change before it runs and drops nothing you didn’t list. You describe the schema you want, review the plan it writes, apply it in a transaction, and then check the database with a separate read-only process that doesn’t trust the apply step.

The Pitch in Four Numbers

  • 4 commands: inspect, plan, apply and verify.
  • 3 PostgreSQL versions supported: 16, 17 and 18.
  • 0 drops you didn’t list. Nothing disappears unless the plan says so and you approved it.
  • 1 transaction per apply, with indexes built online.

How It Works

Inspect reads the live schema: defaults, identity columns, unique, check and foreign key constraints, enums, arrays and views. Plan compares it with the schema you want and writes an explicit, reviewable plan, including drops and type changes when you ask for them, with an explanation of each step. Plans can be posted as comments on pull requests, so schema changes get reviewed like code.

Apply runs the reviewed plan in a transaction, building indexes online so tables aren’t locked longer than they need to be. Only supported, reviewed plans can be applied. Verify then checks whether the database structurally matches the desired schema or has drifted, without changing anything. Because verify is independent of apply, it’s useful on its own: run it in CI against staging and production and you’ll know when someone made a change outside the process.

The desired schema lives in files in your repository, so development, staging and production can all be checked against the same source. A reproducible walkthrough on a disposable database shows the whole cycle, and a capability matrix in the repository spells out exactly what’s supported.

Who It’s For

  • Teams on PostgreSQL who want to see every schema change before it runs.
  • Reviewers who want migration plans in the pull request, not hidden in a script.
  • Platform and DBA teams checking that staging and production haven’t drifted.
  • Anyone who’s been burned by a migration tool dropping something it shouldn’t.

Limits

ForgeSchema is PostgreSQL only, and still in development. Only features in its capability matrix can be applied, and anything else is refused instead of guessed at. The project publishes scope, not performance figures.

The Four-Question Screening

Every project featured here gets the same four questions, the way you’d screen a startup idea.

1. Where is the money in it?

The engine is open source under Apache 2.0, with no paid tier. Database change management is a real market: teams pay for tools that make schema changes safe and auditable, especially in regulated industries. The paid paths are a hosted review and approval workflow with audit history, drift monitoring across many databases, and support for large teams. Plans that explain themselves in a pull request are a natural fit for compliance-minded companies.

2. What real problem does it solve?

Schema changes nobody fully understood before they ran, and databases nobody can prove are in the expected shape. Both lead to outages and slow, nervous releases.

3. The technology in plain words

Think of renovating a house with a careful builder. First they survey what’s there. Then they hand you a written plan of every wall they’ll move, and they won’t knock anything down that isn’t on the list. They do the work in one go. Then a separate inspector, who didn’t do the work, walks through and checks the house matches the drawings.

4. Moat and differentiation

Migration tools are plentiful, and many either run hand-written scripts or generate changes with little explanation. ForgeSchema’s edge is explanation and restraint: every step explained in advance, nothing dropped that you didn’t list, and verification that doesn’t trust the apply step. The moat that can grow is depth on PostgreSQL’s harder features and its place in the pull request workflow, which makes it part of how a team ships.

Why It Matters

Most database outages start with a change. A tool that makes every change visible, reviewable and checkable lowers the risk of the riskiest moment in a database’s life.

Follow the Project

Read the introduction, learn about the engine and the schema format, try the demo, see the roadmap, or get the code from the ForgeSchema repository on GitHub. ForgeSchema is listed with the other open-source projects on SoftDevStudio.com, and more featured projects are in the Projects section.

Filed Under: Projects Tagged With: cloud computing, enterprise software, startups and funding

Footer

Recent Posts

  • China Turns AI Model Distillation Into Industrial Policy and Weakens the Reach of US Chip Controls
  • AI-Found Software Flaws and the Rush to Patch Them Are Now a Market Risk After a Week of US Outages
  • Ohio Voters Put $17 Billion of Amazon Data Center Spending at Risk as Local Bans Spread
  • US Remote Access Chip Rule and FCC Optics Ban Squeeze Southeast Asia Data Centers and Nvidia China Exposure
  • Microsoft Puts Word, Excel and PowerPoint Inside Copilot and Turns Office Into an AI Front Door
  • OpenAI Cuts GPT-6.2 Astra Prices 20% as Microsoft MAI Code 2 Undercuts Frontier Coding Models
  • Tencent Q3 Shows New AI Products Cost About RMB15 Billion in Operating Profit as Capex Hits 39% of Revenue
  • Anthropic IPO Heads for the Top of Its Range as $900 Billion in Compute Commitments Go Public
  • Nvidia Q3 Revenue Hits $115.8 Billion but the Q4 Margin Guide Drops Three Points as the Board Rules Out Jensen Huang
  • Emboldened Iran and a Weakened Trump Leave US Stocks, Bonds and Oil Pricing a Peace That Has Not Arrived

RSS feed: Market Research Media Market Research Media

  • Four Vendor Surveys on Missed AI Returns Each Find the Problem Their Sponsor Sells a Fix For
  • Wasabi Study Puts Unplanned Infrastructure Spending at $63.4 Billion, With Germany Overspending by 7.1 Billion Euros
  • CSC Survey Finds 88% of Private Capital GPs Spend Up to Half Their Finance Time Checking Administrator Work
  • Lenovo Survey Finds 80% of IT Leaders Tie AI Success to the Digital Workplace and Only 10% Have Redesigned It
  • Claude and ChatGPT Integrations Killed the Headless CMS Market
  • Survey Margin of Error Explained, What Plus or Minus 3 Points Covers and What It Leaves Out
  • Morgan Stanley Pulse Survey Finds Bearish Investor Sentiment Rising to 42 Percent as Inflation Fears Grow
  • A Stronger Week Across the Network, October 4–10, 2026
  • The Tariff Map Is Becoming an Industrial Policy Map—and the U.S. Economy Is Paying the Price
  • PC Shipments Fall 22.4% as Higher Component Costs Price Buyers Out

Media Partners

  • Analysis
  • Technology Conferences
  • OSINT
  • Defense Market
  • Cybersecurity Market
  • Event Calendar
  • Calendarial
  • Opinion
  • 3V
  • Media Presser
  • Exclusive Domains

Copyright © 2026 MarketAnalysis.com | Terms of Service | Privacy Policy | Supplier Disclaimer | The Website Coded and Designed by SoftDev Studio

Media Partners: Technologies | Photography | Referently

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT