Simple, elegant SQLite database manager with powerful features
Base is an SQLite database manager to quickly create, search and edit data on macOS. It’s a lightweight, simple and straightforward way of taking control over your databases. With a spreadsheet-like interface the app will feel familiar to all, so there’s no need in learning difficult SQL commands.
Create SQLite databases in seconds. It’s simple and quick to make a new database, so do it anytime. For test data, experiments or production files, it’s up to you.
Edit everything! This includes all column- and table-level constraints. In fact, with this robust sqlite editor, you can edit everything from the basic default values to complex foreign key constraints.
No need to fight with long-winded CREATE TABLE statements! You can add, edit and delete columns or constraints from a single sheet. Base has made the creating and maintaining of tables simpler than ever.
Effortlessly find your data using the novel and improved filtering system. It is now fast and simple to create difficult queries with minimal typing in a familiar spotlight-like view.
Import any CSV or SQLite from dump files, then export your tables and custom queries to SQL, delimited text, XML or Microsoft Excel-compatible formats! You can also export your filters to SQL statements.
With Base, SQL editing is made easy. Besides the typical syntax highlighting option, this app can now autocomplete standard SQL commands. You can also store your most used SQL snippets for prompt re-use later on.