What is sqliteer?

SQLiteER is a native Mac application that reads any SQLite database file and draws a visual diagram showing all the tables and how they connect to each other. SQLite is a common file-based database format used by many Mac and iOS apps to store structured data. An entity-relationship diagram (the ER in the name) is a map of that structure: each table appears as a labeled box, and lines between boxes show which tables reference each other. To use it, you drag a database file onto the app window. SQLiteER reads the file's structure automatically, lays out every table as a card, and draws the connections between them using a standard notation called crow's foot, where the shape at each end of a line tells you whether a record in one table can link to one or many records in another. You can then drag the cards around to arrange the diagram however you like, zoom in or out, and export the result as a PNG image or PDF. The app understands three Apple-specific database formats beyond plain SQLite: Core Data, SwiftData, and SQLiteData stores. These formats use internal naming conventions that are confusing to look at directly. SQLiteER translates them back into clean, readable names so the diagram reflects the app's original design rather than the raw storage format. Relationships between tables are detected in three ways: from foreign keys that are explicitly declared in the schema, from column naming patterns that suggest a connection even without a declared key, and from the internal tables that Core Data uses to record relationships between records. The app requires macOS 15 or later and is built entirely with Apple's SwiftUI and the built-in SQLite library, with no third-party dependencies. Source code is included for those who want to build it themselves in Xcode. Pre-built installer files are also available on the releases page. The project is all rights reserved by the author.