Base is an application for creating, designing, editing, and browsing SQLite 3 database files. It's a proper OS X application. Fast to launch, quick to get in to and get the data you need. (The trial is limited to 15-minute sessions, and custom queries only return 5 rows.
Features:
- Schema viewing
- Table contents viewing/editing
- Custom SQL queries
- Command logging
- Support for viewing and editing ALL column- and table-level constraints; from simple default values, to complex foreign keys, Base can handle it
- Advanced table designing and altering; no need to manually type CREATE TABLE statements, from a single sheet you can add, edit and remove columns and constraints to your heart's content, maintaining or moving the original data within them
- Quick data find and filter; build lengthy SELECT statements with a few clicks, previewing results as you go
- Easy SQL editing, with clear syntax highlighting and useful SQL auto-completion
- Store your commonly used SQL as snippets for easy re-use later
- Easy import, comprehensive export; bring in data from CSV or SQL files; export to SQL, delimited text, XML, or Microsoft Excel-compatible formats