About This Tool
Documentation
What does this tool do?
A relational database migration tool that analyzes JSON record arrays, auto-detects column data types (INT, DECIMAL, VARCHAR, JSON, TIMESTAMP), generates `CREATE TABLE` DDL with custom primary keys, and produces batch `INSERT INTO` queries for MySQL, PostgreSQL, SQLite, SQL Server, and Oracle.
When should you use it?
Use this tool when importing MongoDB or DynamoDB JSON exports into relational databases, seeding local development SQL databases, or generating SQL migration scripts.
Key Capabilities & Features
Highlights
Convert complex JSON objects and arrays into relational SQL schema definitions and INSERT statements
Auto-detect column data types: INT, BIGINT, NUMERIC, VARCHAR, TEXT, BOOLEAN, and JSONB
Dialect options for PostgreSQL (with JSONB support), MySQL, SQLite, and SQL Server
Handle nested JSON hierarchies by flattening keys or generating relational child tables
Batch INSERT query generation with configurable chunk sizes for massive datasets