DbSchema Database Designer

DbSchema | CSV Editor for Large Files

Publish on DbSchema Blog >>>

DbSchema includes a free CSV Editor for large files, up to 5G, depending on the free memory on your computer.
The editor is available under both, DbSchema Community and Pro editions.

Open the CSV Editor

Open the editor from the Query Tools menu.

Open the CSV Editor

In the next step, you can choose the file to open, and the CSV format: file encoding, fields and records delimiters,
and quote character. DbSchema will try to guess first this for you.

Press ‘Cancel’ to edit a new CSV.

Choose CSV File Format

Add New Rows or Columns

Right-click one of the column or row headers to add a new row or column.
Add new row or column

Filter & Sort the Data

From the column pop-up menu, you can set filters or sort the data. DbSchema is trying to guess the column data type, so the sorting for numeric and date columns
is working correctly.

Filter and sort the data

Edit the Data

Double-click any cell to edit its content.

Edit the data

Save Format

Use ‘File / Save As’ to save the edited CSV under a given file and format.

Save the CSV File

Visually Manage Databases using DbSchema

DbSchema is a databases client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.
DbSchema main features include:

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams, by double-clicking them. Changes will be saved to the design model and, if DbSchema is connected to the database also into the database. More.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected. Choose 'Edit Manually' into the JDBC URL combo to enter a custom URL. More.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys. Double-click cells to edit the data. More.

Query Builder alt >

Query Builder

Create SQL Queries featuring JOINS, GROUP BY, ORDER BY just using the mouse. More.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries. The editor is autocompletion-enabled. More.

Schema Synchronization alt >

Design Schema in Team & Schema Deployment

DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model. More.

Dark Theme alt >

Dark Theme

Configurable styles & dark theme. More.

Many features are available in the free Community edition.
The Pro edition adds capabilities to save the design to the model file, design schema in team and deploy the schema on multiple databases.

DbSchema can be downloaded for free. No registration is required.