JSON to SQL Converter

About this converter

Turn JSON, like API responses, exports, and config files, into SQL you can run. Point it at an array of objects and it maps every key to a column, infers sensible types, and writes the statements for your dialect.

Four dialects

PostgreSQL, MySQL, SQLite, and SQL Server. Each gets the right quoting, types, and auto-increment syntax.

Nested data

Objects and arrays become JSONB or JSON where supported, and TEXT where they aren't, so no data is lost.

Private by default

Every conversion runs client-side. Your JSON never touches a server, so it's safe for sensitive data.

Frequently Asked Questions

Can I convert nested JSON objects to SQL?

Yes. Nested objects and arrays are stored as JSON/JSONB in databases that support them (PostgreSQL, MySQL) and as TEXT in those that don't (SQLite, older SQL Server).

How does the tool determine column types?

It reads the values in your JSON and maps them: numbers become INT or DECIMAL, strings become VARCHAR(255) or TEXT, booleans map to each database's boolean type, objects and arrays become JSON types, and ISO date strings become DATE or TIMESTAMP. Fields named id or ending in _id are treated as primary keys.

What's the difference between individual and batch inserts?

Individual mode writes one INSERT statement per row. Batch mode combines every row into a single INSERT with multiple value sets, which is more efficient for large datasets, though some clients cap the number of rows.

Is my data secure when using this tool?

Completely. Every conversion runs in your browser. Your JSON is never uploaded, so it's safe even for sensitive data.

How are primary keys and auto-increment handled?

With CREATE TABLE, the tool detects the primary key and applies the right syntax per dialect:

PostgreSQL: SERIAL PRIMARY KEY
MySQL: INT AUTO_INCREMENT PRIMARY KEY
SQL Server: INT IDENTITY(1,1) PRIMARY KEY
SQLite: INTEGER PRIMARY KEY

What's the largest JSON I can convert?

Since everything runs locally, the limit is your device's memory. For multi-megabyte files, use batch insert and turn off prettify for the best performance.

Does it handle dates and times?

Yes. Strings in YYYY-MM-DD format map to DATE, and strings with a time component map to TIMESTAMP (or the closest equivalent for your chosen database).

Can I target a database that isn't listed?

The output is broadly compatible. Use MySQL as a starting point for MariaDB or BigQuery, and PostgreSQL for Oracle, then adjust any syntax specifics afterward.

Mission von Beekeeper Studio

Unsere Mission ist es, Open-Source-Software zu entwickeln, um die Zugänglichkeit von Datenbanken für alle auf der ganzen Welt zu verbessern.

Unsere Verpflichtungen an Sie:

😍 Tolles Gefühl - Die Verwendung unserer Software sollte Sie glücklich machen, weil sie so angenehm zu bedienen ist.
🔒 Respektiert Privatsphäre - Kein aufdringliches Werbe-Tracking oder Verkauf Ihrer persönlichen Informationen. Standardmäßig wissen wir nicht einmal, wann Sie die App installieren - das geht uns nichts an!
💾 Funktioniert Offline - Sie werden niemals eine Internetverbindung benötigen, um die App zu verwenden (warum sollten Sie?)
🌍 Inklusiv - Wir sind zu 100% inklusiv und haben einen Verhaltenskodex. Vielfalt und Inklusion sind gut für Beekeeper, die Tech-Community und die Welt. Verhaltenskodex.
💪 Open Source - Wir werden immer eine vollwertige Community-Edition unter einer OSI-genehmigten Lizenz bereitstellen. OSI approved.

Quellcode auf Github Ansehen