Convert SQLITE to SVG

Turn SQLITE files into SVG. A picture kept as vectors with real text.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

A diagram of your database schema.Each table becomes a box, and foreign keys become lines between them.

  1. What you get

    One SVG picture, kept as vectors with real text. It is an entity relationship diagram laid out left to right.

    Each table is a box headed by its name. The box lists the columns in order with their declared types, and it shows NOT NULL and generated columns. Primary keys are marked PK and foreign keys are marked FK.

  2. How relationships are drawn

    Each foreign key is a line from its column to the column it references. A crow's foot sits on the side that can repeat. A bar or a circle tells whether the key is required.

    If a foreign key names a table that the file does not have, that table is drawn with a dashed border. Tables with no keys between them are set out in a grid.

  3. What is left out

    Every table is drawn, including empty ones and those without a rowid. Views, indexes, triggers and SQLite's own tables are left out. The data in the rows is not part of the picture.

    A schema of more than 250 tables or 5,000 columns stops with resource_limit. A file with no tables stops with unsupported_elements.

SQLITE and SVG.What each format is.

The formats

From · SQLITE

SQLite Database

A whole relational database in one file. Tables, indexes and views.

Extensions
.sqlite .sqlite3 .db
MIME type
application/vnd.sqlite3
Kind
Text and data
To · SVG

SVG

Scalable vector graphics in XML. Logos, icons and diagrams that stay sharp at any size.

Extensions
.svg .svgz
MIME type
image/svg+xml
Kind
Images

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

terminal
$ cv convert report.sqlite report.svg
$ cv convert report.sqlite report.svg

Questions.What people ask about SQLITE to SVG.

01OF 04

No. It shows the structure: table names, columns, types and keys. Rows are not drawn.

No. Views, indexes, triggers and SQLite's own tables are left out. Every table is drawn, including empty ones.

Primary keys are marked PK and foreign keys are marked FK. Each foreign key also has a line to the column it references.

The file has no tables, so there is nothing to draw. A schema of more than 250 tables or 5,000 columns fails with resource_limit instead.

More conversions.Other ways in and out of SQLITE and SVG.