Convert JSON to SQL

Add your JSON data and automatically convert it to a SQL insert file.

Add your data to get started

No conversion done yet

JSON

JSON stands for JavaScript Object Notation and it's a plain-text data format primarily developed for use in JavaScript, but now widely used across the interwebs, specially in modern web APIs.

Character encoding

As stated by the RFC 8259, we expect strings in uploaded JSON files to be encoded in UTF-8.

If your file contains non UTF-8 characters, you might get an error when converting your data.

SQL

SQL stands for Structured Query Language and is a standarized language used to communicate with almost all relational databases. It can be used to query, insert and manipulate data stored in a database.

The exported file will be a SQL dump (.sql) that you can use to import it to your database.

SQL flavour

Since databases have different syntax for some things. You'll be able to choose a SQL database flavour when exporting to SQL, at the moment we support:

  • MySQL
  • PostgreSQL
  • SQLite

Character encoding

The exports will always be encoded in UTF-8.

Frequently asked questions

How does the file limit work?

You can upload files up to 10 MB with the free plan.

Upgrade to the Pro plan if you need to upload files up to 100 GB.

Can I change my plan any time?

You can change your plan any time by going to the pricing page and selecting a new plan. If you're in the middle of a billing cycle and you change to a more expensive plan, the subscription price will be prorated automatically.

How do I cancel my subscription?

Go to your account page and find the Billing section, there you can downgrade to the Free plan. Your plan will be cancelled immediately and you won't be charged again.

Is it secure?

We pride ourselves in building software that's easy to use, but security is also our top priority.

We understand that some data uploaded might be sensitive, so we ensure that your data is only kept when needed.

We follow widely accepted industry standard practices when it comes to security:

  • HTTPS is enforced for all communications with our server
  • We enforce a strict access policy and employees or external collaborators never have access to user data
  • All data is always encrypted at rest
  • All data is automatically deleted forever 24 hours after being uploaded.

We allow time before deleting files just in case you're not done with the data, if you're done with viewing or converting a file and want to delete it right away, you can do it yourself through the API.

Note that all files files uploaded without an account are acessible by a unique URL that is hidden but accesible by anyone, so we recommend you to sign up with an account if you want your files to be private, only your account will be able to access your files.

Do you provide an API for converting files?

You can upload files, queue and check the progress of conversion jobs with our API. Check out the API documentation for more detail.

Do you offer a trial?

We don't offer a trial plan at the moment.

You can test our tools with a subset of your data with the Free plan then upgrade if you like it.

All plans provide the same conversion features.

Where do I get my API key?

You'll get an API key when you sign up, find it in your account page.

Do you have any SDKs for your API?

Unfortunately, we don't have any language specific SDKs yet, so you'll have to use a standard HTTP client for it.

Related articles