Turn JSON into INSERT, UPDATE, or CREATE TABLE statements for any database.
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.
PostgreSQL, MySQL, SQLite, and SQL Server. Each gets the right quoting, types, and auto-increment syntax.
Objects and arrays become JSONB or JSON where supported, and TEXT where they aren't, so no data is lost.
Every conversion runs client-side. Your JSON never touches a server, so it's safe for sensitive data.
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).
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.
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.
Completely. Every conversion runs in your browser. Your JSON is never uploaded, so it's safe even for sensitive data.
With CREATE TABLE, the tool detects the primary key and applies the right syntax per dialect:
SERIAL PRIMARY KEY
INT AUTO_INCREMENT PRIMARY KEY
INT IDENTITY(1,1) PRIMARY KEY
INTEGER PRIMARY KEY
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.
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).
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.
Beekeeper Studio is a fast, good-looking SQL editor and database manager for Mac, Windows, and Linux. Paste the SQL you just generated, run it, and browse the results, all in one place.
私たちのミッションは、世界中の誰もがデータベースにアクセスしやすくするために、オープンソースソフトウェアを作成することです。
あなたへの約束：