DemandHunt Demand signals from global communities
EN
Dev Tools & Micro-SaaS Stack Exchange · 2025-08-18

APIs have Swagger; databases need the same — schema as a tracked file with nice docs

API 有 Swagger,数据库 schema 也想要个『存进 Git 就能看』的工具

At a glance · 30-second read
  • WhoStack Exchange · 2025-08-18 · 1 replies
  • The askAPIs have Swagger; databases need the same — schema as a tracked file with nice docs
  • The openingSwagger for databases: export JSON schema from a live DB, render visual docs, diff history in Git. Open core plus team tier.

What was actually said

“Swagger presents a JSON API schema nicely. What tool does the same for a database schema stored as JSON/XML? I want to track schema changes with Git only.”

— Stack Exchange · 2025-08-18 · softwarerecs.stackexchange.com/questions/93630/what-…

Background and pain

The pain

Schema changes live in tribal memory and migration scripts; with no textual source of truth, reviews can't see what the tables became.

A buildable angle

The opening

Swagger for databases: export JSON schema from a live DB, render visual docs, diff history in Git. Open core plus team tier.

How to validate it

  1. Read the whole thread and note the recurring scenarios — repetition is the density of the need.
  2. Search existing tools around "database / schema docs" and check which single step they actually cover.
  3. Put up a one-line landing page, share it back to Stack Exchange, and see whether anyone asks about pricing.

Existing options

Flyway/LiquibaseDBML/dbdocs

From the thread · top comments

You can use schemacrawler for this, the Free database schema discovery and comprehension tool. The downloadable release comes with a sqlite database, sc.db When you have downloaded schemacrawler, execute this to load the schemacrawler shell: schemacrawler --shell Inside the schemacrawler shell, execute 3 commands to extract the schema to text: connect --server=sqlite --database=sc.db load --info-level=standard execute --command=schema Expected output: Tables ======================================================================== Authors [table] ------------------------------------------------

— knb · ▲ 0
Open the source thread

More threads on this pain

Related opportunities