Base

Base

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.

via Setapp
Rating: 4.5/5
based on 915 reviews
Latest Version: 2.4.12
System Requirements: Mac OS X 10.10+

Sounds good? Well it looks good too.

Base features

Easy SQLite database creation

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.

Rich editing capabilities

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.

Superb table designing & altering

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.

Instant, consistent data filtering

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.

Basic import and detailed export

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.

Smart autocomplete option

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.

We love Setapp

Base
Spend less time searching, more time doing
Setapp has Base plus more than 150 other beautifully designed tools in one collection. No ads, no in-app purchases, no paying for updates. Just apps, fully unlocked. Setapp is $9.99/month. You get an entire week free to try it out.