JSON to database schemas
Turn JSON into SQL tables, Prisma and Mongoose models, BigQuery schemas or Protocol Buffers — instantly, right in your browser.
- JSON to MySQL — A CREATE TABLE You Can Run Turn a JSON sample into a MySQL CREATE TABLE. Column types come from the values, and a string too long for VARCHAR(255) gets TEXT instead.
- JSON to PostgreSQL — Paste It Into psql Turn a JSON sample into a PostgreSQL CREATE TABLE. Strings become TEXT, nested values JSONB, and a key missing from some rows becomes nullable.
- JSON to Mongoose — A Model File to Require Turn a JSON sample into a Mongoose schema. One schema per object, required where the sample shows a value, ready to export as a model.
- JSON to Prisma — A Model That Migrates Turn a JSON sample into a Prisma model. The identifier every model needs is always there, so prisma validate passes and the migration runs.
- JSON to BigQuery Schema — bq load Takes It Turn a JSON sample into a BigQuery schema file. Fields from every row are merged, so the load succeeds on the first attempt rather than the third.
- JSON to Protobuf — A .proto protoc Compiles Turn a JSON sample into proto3 messages. Field names are repaired for protobuf and json_name keeps the original key, so both sides still agree.