From JSON to your database in one paste
Bootstrapping a database with seed data, importing an API response into Postgres for analysis, or building a fixture file for tests — all the same pattern: a JSON array of records and a target table.
Column types are inferred from the values. Strings become VARCHAR or TEXT, integers become INTEGER, booleans become BOOLEAN (or TINYINT in MySQL), and ISO date strings are detected as DATE or TIMESTAMP. Nested objects fall through to a TEXT column with the JSON serialized as-is.