ToolPal

JSON to SQL

JSONデータをSQL INSERT文に即座に変換します。MySQL、PostgreSQL、SQLite、SQL Serverに対応し、CREATE TABLE生成オプションもあります。

使い方

JSONデータをSQL INSERT文に即座に変換します。MySQL、PostgreSQL、SQLite、SQL Serverに対応し、CREATE TABLE生成オプションもあります。

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

よくある質問

詳しく読む