JSON to SQL

About This Tool

Converts a JSON filter object with Mongo-style operators into a SQL WHERE clause, or a flat JSON object into an INSERT statement, across PostgreSQL, MySQL, and SQLite quoting conventions. The swap button reverses this, parsing an existing WHERE, INSERT, or UPDATE statement back into JSON.

Output is generated text only and is never executed against a database. If the goal is a CSV export or a URL query string instead of SQL, see JSON to CSV or JSON to Query String.

Key Features

• Two conversion kinds: filter-to-WHERE or object-to-INSERT, picked from the Conversion dropdown.
• Three SQL dialects: PostgreSQL, MySQL, and SQLite, each with correct identifier quoting and placeholder syntax.
• Named or positional placeholders: switch between :name and ?/$n styles.
• One-click JSON formatting: the Format button pretty-prints the input before converting.
• Reverse parsing: the ⇌ swap button turns existing SQL back into JSON.

Example

A filter with a comparison and an IN clause:

{
  "status": "active",
  "age": { "$gt": 18 },
  "role": { "$in": ["admin", "editor"] }
}

produces (PostgreSQL, parameterized):

WHERE "status" = :status AND "age" > :age AND "role" IN (:role_0, :role_1)