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 de Beekeeper Studio

Notre mission est de créer des logiciels open source afin d'améliorer l'accessibilité des bases de données pour tous dans le monde entier.

Nos engagements envers vous:

😍 Excellente Expérience - L'utilisation de notre logiciel devrait vous faire vous sentir bien car il est très agréable à utiliser.
🔒 Respecte la Vie Privée - Pas de suivi publicitaire intrusif ni de vente de vos informations personnelles. Par défaut, nous ne savons même pas quand vous installez l'application, ce n'est pas notre affaire!
💾 Fonctionne Hors Ligne - Vous n'aurez jamais besoin d'une connexion internet pour utiliser l'application (pourquoi devriez-vous?)
🌍 Inclusif - Nous sommes 100% inclusifs et avons un code de conduite. La diversité et l'inclusivité sont bonnes pour Beekeeper, la communauté technologique et le monde. code de conduite.
💪 Open Source - Nous fournirons toujours une édition communautaire complète sous une licence approuvée par l'OSI. OSI approved.

Voir le Code Source sur Github