Database schema evolution, as easy as Git.
Most teams still treat database schemas the way they treated code before Git: manual diffs, tribal knowledge about what changed in prod, and a migration script someone wrote at 11pm hoping it's right.
The-Andb is a schema reliability engine. It reads your database structure as a semantic model — not just text — so you can diff dev against prod, catch destructive changes before they run, and generate migrations without guessing.
Everything here — engine, CLI, MCP server, desktop app — ships under the same AGPL-3.0 license. Nothing is held back behind a proprietary build.
We picked AGPL-3.0 specifically because it closes the SaaS loophole regular open-source licenses leave open: if someone re-hosts a modified TheAndb as a service, they have to publish their changes too. That's what lets us stay fully open without the code getting quietly forked into someone else's paid product. Sustainability comes from sponsorship, not from what's locked away.
Each repo does one job, and they compose into the same pipeline — inspect a schema, diff it, and act on the diff:
| Repo | Role |
|---|---|
| 🧠 andb-core | The engine. AST-based SQL parsing, semantic diffing, and migration generation. Everything else is a client of this. |
| 🖥 andb-desktop | Visual schema comparison and drift auditing (Electron + Vue 3). Where most people meet the project first. |
| ⚙️ andb-cli | The same engine, wired for automation — andb compare/andb export in CI/CD pipelines. |
| 🤖 andb-mcp | Model Context Protocol server, so AI agents (Claude, ChatGPT) can run safe, read-audited schema checks. |
| 🌐 andb-www | This project's public site and docs. |
| 📂 andb-monorepo | Orchestrates the repos above for local development — clone-all, docs, Docker fixtures. |
We're a small team, actively reviewing incoming issues and discussions. Bug reports and feature requests via GitHub Issues on the relevant repo are the fastest way to reach us. If you're picking up an issue to fix, comment first so we don't duplicate work.
Software is like sex: it's better when it's free. That's the philosophy behind everything here — no hidden repositories, no source-available tricks. Read it, fork it, hack it, self-host it. If hosted services ever show up, you'll be paying for convenience, not for access to the source. Code should be free. Time isn't. ❤️
Sponsorship doesn't unlock anything — it's already all AGPL-3.0. What it funds is the time behind it: development, testing across MySQL/Postgres, CI/CD, and keeping releases shipping on a predictable cadence.
⭐ Star the repos you use · 🐛 File issues you hit · ❤️ Sponsor if TheAndb saves you time