Convert SQL to TSV

Turn SQL files into TSV files. The tables the script creates are loaded first, with a dump from MySQL, MariaDB or PostgreSQL rewritten into SQLite's dialect.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop SQL files on the dialor turn it to pick what to do

One TSV for each table in your SQL script.Each table becomes its own TSV file, named after the table, with a header row.

  1. What you get

    The tables the script creates are loaded first, then each one is written out as a TSV file named after it. Every file starts with a header row.

    Values are written as stored. Binary values are written as escaped text.

  2. Dumps from other databases

    A dump from MySQL, MariaDB or PostgreSQL is rewritten into SQLite's dialect before it is loaded, so you can convert it as it is.

    Dates that are not real dates, such as MySQL's 0000-00-00, are left empty. PostgreSQL true and false become 1 and 0.

  3. What is left out

    Views, functions and triggers are not converted. They are left out with a warning. Only the tables and the rows in them reach the TSV files.

    To load a TSV back into a database, use TSV to SQL.

SQL and TSV.What each format is.

The formats

From · SQL

SQL Script

SQL statements as text. A database dump that any SQL tool can read or replay.

Extensions
.sql
MIME type
application/sql
Kind
Text and data
To · TSV

Tab-Separated Values

Tab-separated values.

Extensions
.tsv .tab
MIME type
text/tab-separated-values
Kind
Text and data

In your code.The same SQL to TSV conversion through the API, for your app or your agent.

terminal
$ cv convert report.sql report/ --to tsv
$ cv convert report.sql report/ --to tsv

Questions.What people ask about SQL to TSV.

01OF 04

One TSV per table in the script, each named after its table. A script with one table gives one file.

Yes. A dump from MySQL, MariaDB or PostgreSQL is rewritten into SQLite's dialect before the tables are loaded.

Dates that are not real dates, such as MySQL's 0000-00-00, are left empty in the TSV.

No. Views, functions and triggers are left out, and you get a warning about them.

More conversions.Other ways in and out of SQL and TSV.