SQLite import into ERD

Question

Trying to work out a way to import the table structure from a SQLite database (.db file).  Does anyone have the SQL required to export the data from a SQLite DB as per other dbs such as SQL Server?

Nico S · Accepted Answer

Hi JeffThanks for posting in the Community.Lucidchart does not currently support ERD import from SQLite. The DBMS supported for ERD import into Lucidchart are MySQL SQL Server PostgreSQL and Oracle.Anecdotally we have seen some users work around this by editing their import data to make it mimic a supported database. (You might want to take a look at some example import text files linked at the bottom of this article from our Help Centre to see the required format.) This might work in some situations although I can't guarantee this would suit your particular needs and it is outside the scope of the Support team's capabilities to provide any more specific guidance on this.However we're always looking for ways to improve Lucidchart and your feedback is the best way for us to do that. If you would like to see SQLite as a supported DBMS would you mind adding your idea to our product feedback space? Ideas submitted to this form are passed on to the product development team for their consideration.

dido · Answer

Hi, haven’t found an answer anywhere, made this one. Sqlite 3.41.2

SELECT 'postgresql',
       'schema',
       'public',
       tbl_name,
       ti.name AS [column],
       ti.cid,
       ti.type,
       '' AS '?',
       iif(ti.pk = 1, 'PRIMARY KEY', iif([from] IS NOT NULL, 'FOREIGN KEY', '') ) AS key,
       iif([from] IS NOT NULL, 'public', '') AS '',
       [table],
       [to]
  FROM sqlite_schema AS s,
       pragma_table_info(s.name) ti
       LEFT JOIN
       pragma_foreign_key_list(s.name) fkl ON ti.name = fkl.[from]
 WHERE s.type = 'table' AND 
       NOT s.tbl_name = 'sqlite_sequence'

Create an account in the community

Log in to the community