Schema Generator

Generate magical auto-typed code & database interfaces!

An Open Source joint by Dan Levy ✨

This project (Schema Generator) is a web app with usage example for it's sister library Schema Analyzer. The Analyzer library provides an automatic data type analysis on any given array of objects.

The components included here support JSON/CSV data!

Mini Demo

Features

The primary goal is to support any input JSON/CSV and infer as much as possible. More data will generally yield better results.

• Support SQL & noSQL systems!
• Automatic type detection!
• Detects String & Number size constraints (for SQL backends)!
• Handles error/outliers intelligently
• Ignores error/outlier records!
• Smart field name formatting, snake-case vs. camel-case!
• Detects unique columns!
• Detects enum Fields!
• Detects Not Null fields!
• Extensible design, add new output/target with ease!
• Nested data structure & multi-table relational output - Coming soon

Currently Supports...

• Mongoose Schema definition - https://mongoosejs.com/
• Knex Migration scripts - https://knexjs.org
• TypeScript Types
• SQL DDL script (Data-definition language) - Coming soon
• Validation Code for Libraries like Yup or Joi
• JSON Schemas (for libraries like ajv)
• Binary Encoders (protobufs, thrift, avro?)
• JPA
• Ruby/Rails