Convert Avro to PostgreSQL

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

Tablepad: Explore and create graphs from AVRO. Try it now

Convert files up to 5 MB. Please upgrade to increase the limit.

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.avro" \
	-F "input[format]=avro" \

	-F "output[format]=sql" \
	-F "output[options][create_table]=true" \
	-F "output[options][syntax]=postgres" \
	-F "output[options][table_name]=mytable"

Avro

Apache Avro is a data serialization format for record data developed within the Apache Hadoop project.

Avro encodes data in a compact binary format and embeds a schema to describe the shape of the data stored.

PostgreSQL

PostgreSQL an open source and free relational database management system that implements the SQL standard. It is considered by many the most robust database that currently exists.

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.

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 Arrow: What are the differences?

26 December, 2022

Avro and Arrow are two popular data formats used in a variety of settings. They both have advantages and disadvantages, and understanding their differe

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