DbSchema for CSV Files Databases

DbSchema is a powerful database management and design tool for CSV Files. It offers features such as visual schema design, team collaboration with GIT, schema deployment and HTML schema documentation.

How to Connect to CSV Files Database

  1. Access the Connection Dialog

    Choose "Connect to the database" or "New Model Connected to the Database" will let you select your database and open the Connection Dialog.

    DbSchema automatically downloads the JDBC driver to connect to your database.

  2. Configure the Connection
  3. In the Connection Dialog window, select the JDBC URL you want to connect with. If your database is running in the cloud, choose Edit Manually and insert the JDBC URL from the cloud console.

    Enter the host name, the authentication details, select your database as described in the Connection Dialog page.

  4. Troubleshoot Firewall Issues
  5. If you encounter connection issues, it may be due to firewall settings. Read how to enable Firewall Connections.
Remember to enable Windows Firewalls Firewalls & anti-viruses may block database connections.

Load CSV Files from Folder

CSV Formats

DEFAULT Standard Comma Separated Value format, similar to RFC4180 but allows empty lines.
EXCEL The Microsoft Excel CSV format.
INFORMIX_UNLOAD Informix UNLOAD format used by the UNLOAD TO file_name operation.
INFORMIX_UNLOAD_CSV Informix CSV UNLOAD format used by the UNLOAD TO file_name operation (escaping is disabled).
MONGO_CSV MongoDB CSV format used by the mongoexport operation.
MONGO_TSV MongoDB TSV format used by the mongoexport operation.
MYSQL The MySQL CSV format.
ORACLE Default Oracle format used by the SQL*Loader utility.
POSTGRESQL_CSV Default PostgreSQL CSV format used by the COPY operation.
POSTGRESQL_TEXT Default PostgreSQL text format used by the COPY operation.
RFC4180 The RFC-4180 format defined by RFC-4180.
TDF A tab-delimited format.

Here with a more detailed description

Format Name Delimiter Ignore Empty Lines Quote Character Comment Marker Record Separator
DEFAULT , No " # \r\n
EXCEL , No " None \r\n
INFORMIX_UNLOAD ` ` No None None
INFORMIX_UNLOAD_CSV , No " None \n
MONGO_CSV , No " None \r\n
MONGO_TSV \t No " None \r\n
MYSQL \t No " None \n
ORACLE , No " None \n
POSTGRESQL_CSV , No " None \n
POSTGRESQL_TEXT \t No None None \n
RFC4180 , No " None \r\n
TDF \t No " None \n

Save the Database Back to CSV

After connecting, DbSchema will load the data into a H2 local database. You can edit the data, add new records, etc. To save back the data to CSV file use the command:

save csv to 'path'
where the path is the folder where to save the data.

DbSchema Features for CSV Files

DbSchema is loading the CSV files to a temporary H2 database. DbSchema will auto-detect the mandatory fields, primary keys and foreign keys.

DbSchema Diagram for CSV files

Available are all DbSchema features, including the SQL Editor, Relational Data Explorer, Query Builder, etc.