HN Explorer

Ask HN: Looking for DB schema management tool

3 points by jyounker ↗ HN
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?

2 comments

[ 32.4 ms ] story [ 496 ms ] thread
tianzhou
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?"

jyounker
Thank you! "Data catalog" is indeed the magic phrase I was looking for.