Looking for DB schema management tool

Question

I'm looking for a tool to solve help with DB schema wrangling. I've got a big mongo cluster, several postgres databases, kafka (with schema registry), and a little bit of redis.I'd like to have something that I can record all the schemas in and then cross reference them, so I can ask things like, "which collections contain links to bigmongo.user.id?" or "if I delete one record from table X, what are all the other records I'm going to have to delete?"Have you heard of such a beast, or am I going to somehow have to roll my own with neo4j, datatomic, or prolog?

tianzhou · Accepted Answer

Sounds like you are looking for a data catalog tool instead of db schema management tool. You can check out Amundsen (https://www.amundsen.io/), DataHub (https://datahubproject.io/)If you are looking for schema change management tool, then you can check out Bytebase (bytebase.com). But it can't answer questions like "which collections contain links to bigmongo.user.id?"