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.
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.
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.
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 withunsupported_elements.
SQLITE and SVG.What each format is.
The formats
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
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.
$ cv convert report.sqlite report.svg$ cv convert report.sqlite report.svgQuestions.What people ask about SQLITE to SVG.
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.