What JSON formats does this tool accept?

The tool accepts a JSON array of objects (the most common format for data exports) or a single JSON object. Each key becomes a column. Keys are discovered across all rows, so missing keys in some rows result in NULL values for those columns.

How does type inference work for CREATE TABLE?

Types are inferred from the first non-null value per column: integers→INT, floats→DOUBLE, booleans→TINYINT(1) or BOOLEAN, ISO 8601 timestamps→DATETIME, date strings→DATE, long strings→TEXT, everything else→VARCHAR(255). Review the generated CREATE TABLE before running it in production — auto-inference can be wrong for edge cases.

Which SQL dialects are supported?

MySQL (backtick quoting, TINYINT booleans), PostgreSQL (double-quote identifiers, BOOLEAN type), SQLite (lightweight, double-quotes), and Microsoft SQL Server (bracket identifiers, NVARCHAR). Pick the dialect that matches your database to get correctly-quoted output.

What does the batch size setting do?

Instead of one INSERT per row, batching groups multiple rows into one INSERT ... VALUES statement. Batch size 100 means each INSERT inserts 100 rows. Larger batches are faster to import but can hit database packet size limits. 100 is a safe default; drop to 1 if your database complains about query size.

Is my JSON data safe? Is anything sent to a server?

Nothing leaves your browser. All parsing and SQL generation runs entirely in JavaScript on your device. Open the Network tab in browser DevTools while converting — you will see zero HTTP requests.

JSON 转 SQL

将JSON数据即时转换为SQL INSERT语句。支持MySQL、PostgreSQL、SQLite和SQL Server，并可选择生成CREATE TABLE语句。

表名

SQL方言

包含CREATE TABLE语句

批次大小

JSON输入

使用方法

将JSON数据即时转换为SQL INSERT语句。支持MySQL、PostgreSQL、SQLite和SQL Server，并可选择生成CREATE TABLE语句。

1Paste your JSON data into the input field. The tool accepts a JSON array of objects or a single JSON object.
2Enter a table name and choose your SQL dialect (MySQL, PostgreSQL, SQLite, or SQL Server).
3Optionally check 'Include CREATE TABLE' to auto-generate a table schema with inferred column types.
4Adjust the batch size to control how many rows appear per INSERT statement (useful for large datasets).
5Click 'Convert to SQL', then copy the output or paste it directly into your database client.

主要功能

Supports MySQL, PostgreSQL, SQLite, and SQL Server with correct identifier quoting for each dialect
Automatic type inference — maps JSON value types to appropriate SQL column types
Optional CREATE TABLE generation to scaffold a complete schema in one click
Configurable batch size (1 to 1000 rows per INSERT) for performance tuning
100% client-side — no data leaves your browser; works offline after initial page load

常见问题

了解更多

JSON to SQL Converter — Turn Any JSON Dataset into Ready-to-Run INSERT Statements