Base is an application for creating, designing, editing and browsing SQLite 3 database files. Its a proper Mac OS X application. Fast to launch, quick to get in to and get the data you need. Base starts with all the basic features you need: • Schema viewing • Table contents viewing/editing • Custom SQL queries • Command logging Then makes it all even better: • 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 & constraints to your hearts content, maintaining or moving the original data within them. • Quick data find & filter. Build lengthy SELECT statements with a few clicks, previewing results as you go. • Easy SQL editing, with clear syntax highlighting and useful SQL autocompletion • 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.