Convert JSON to MySQL

Add your JSON data and automatically convert it to a MySQL (.sql) file for importing.

Add your data to get started

No conversion done yet

You can also use the API to convert data, check out the documentation to learn more.

curl -X POST https://konbert.com/api/v1/convert \
	-H "Authorization: Bearer ${API_KEY}" \
	-F "input[file]=@myfile.json" \
	-F "input[format]=json" \
	-F "input[options][flatten_objects]=true" \
	-F "output[format]=sql" \
	-F "output[options][create_table]=true" \
	-F "output[options][syntax]=mysql" \
	-F "output[options][table_name]=mytable"

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.

MySQL

MySQL is a free and open source relational database management system developed by Oracle that fully implements the SQL standard. It is used in many large-scale websites like Google.

Frequently asked questions

What is the monthly data volume?

The monthly data volume is the total size of all the files uploaded over the course of the month. It resets every month.

For example, if you upload a 1GB file and a 2GB file, your monthly data volume will be 3GB.

If you upload a 1GB file and then delete it, your monthly data volume will still be 1GB.

How does the file size limit work?

The file size limit is the maximum size of a single file you can upload.

What is a AI query?

A query is when you use the data viewer to query a file with natural language (AI).

How do I change my plan?

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.

How secure is your service?

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 uploaded for conversion is automatically deleted forever 24 hours after being uploaded.
  • Once you delete a file, it is deleted forever, we do not archive your data

We allow time before auto 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. We will be implementing this functionality in the web app soon.

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.

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

Avro vs JSON: What are the differences?

15 December, 2022

JSON is a data format that has been around what seems like ages, being used widely as an export format and common exchange format for web APIs everywhe