CODEWITHSUNDEEP
mongodbjsonschema
kaan_atakan
kaan_atakan

Reputation: 4047

Generate a JSON schema from an existing MongoDB collection

I have a MongoDB collection that contains a lot of documents. They are all roughly in the same format, though some of them are missing some properties while others are missing other properties. So for example:

[
  {
    "_id": "SKU14221",
    "title": "Some Product",
    "description": "Product Description",
    "salesPrice": 19.99,
    "specialPrice": 17.99,
    "marketPrice": 22.99,
    "puchasePrice": 12,
    "currency": "USD",
    "color": "red",
  },
  {
    "_id": "SKU14222",
    "title": "Another Product",
    "description": "Product Description",
    "salesPrice": 29.99,
    "currency": "USD",
    "size": "40",
  }
]

I would like to automatically generate a schema from the collection. Ideally it would not which properties are present in all the documents and mark those as required. Detecting unique columns would also be nice, though not really all that necessary. In any event I would be modifying the schema after it's automatically generated.

I've noticed that there are tools that can do this for JSON. But short of downloading the entire collection as JSON, is it possible to do this using the MongoDb console or a CLI tool directly from the collection?

Upvotes: 1

Views: 5001

Answers (1)

Edward Romero
Edward Romero

Reputation: 3106

You could try this tool out. It appears to do exactly what you want.

Extract (and visualize) schema from Mongo database, including foreign keys. Output is simple json file or html with dagre/d3.js diagram (depending on command line options).

https://www.npmjs.com/package/extract-mongo-schema

Upvotes: 3

Related Questions