Base is an application for creating, designing, editing and browsing SQLite 3 database files. It's a proper Mac OS X application. Fast to launch, quick to get in to and get the data you need.
- Yes, it has the basic features you need:
Table schema? Check.
Table contents? Check.
Custom queries? Logging? Check.
- Base fully supports the display and editing of all column- and table-level constraints.
Seriously. Everything from simple default values, through to complex foreign key constraints, Base can handle it.
- Advanced table designing & altering
No need to muck about with long-winded CREATE TABLE statements. From a single sheet, you can add, edit and remove columns & constraints to your heart's content, maintaining or moving the original data within them.
- Quick data filtering
Easily find the data you want using the new filtering system. Build complex queries with minimal typing in a familiar spotlight-like view. You can even export the filter to SQL to save later!
- Easy import, comprehensive export.
Quickly bring in existing CSV or SQL from dump files, then export your tables and custom queries to SQL, delimited text, XML or Microsoft Excel-compatible formats!
- SQL editing made easy
On top of the standard syntax highlighting, Base can now autocomplete commonly-used SQL commands. Even better, you can store your commonly used SQL snippets for quick re-use later on.
Screenshots

Support
Need help? Right this way…