Convert any query, in your browser.
Free converters between SQL, MongoDB, JsonLogic, Elasticsearch and the JSON of other query builders. Paste, pick a dialect, copy.
nothing leaves your browser
SQL to MongoDB converter
freePaste a WHERE clause, or a whole SELECT, and get the MongoDB filter document that matches the same rows.
MongoDB to SQL converter
freePaste a find() filter, shell syntax welcome, and get the WHERE clause for your database, inline or parameterized.
SQL to JsonLogic converter
freeTurn a WHERE clause into a JsonLogic rule: the same condition, as JSON you can store and evaluate anywhere.
JsonLogic to SQL converter
freePaste a JsonLogic rule and get the equivalent WHERE clause for your database.
JsonLogic to MongoDB converter
freePaste a JsonLogic rule and get a MongoDB filter that matches the same documents.
SQL to Elasticsearch converter
freePaste a WHERE clause and get the Elasticsearch query DSL: a bool query you can drop into _search.
react-querybuilder to SQL converter
3 outputsPaste a react-querybuilder query (RuleGroupType JSON) and export it to SQL, MongoDB or JsonLogic with qnot's codecs.
RAQB tree to SQL converter
3 outputsPaste a react-awesome-query-builder tree (Utils.getTree output) and export it to SQL, MongoDB or JsonLogic, no RAQB config needed.
Paste any query: field kinds come from the values, so numbers stay numbers and dates stay dates. Open the schema panel to see what was inferred.
When a format can't express something, you get the rule, the reason and what to change, never a silently wider query.
Each tool shows the two calls it makes. They're qnot's codecs: MIT, typed, and the same on the server and in the browser.