Base - SQLite Editor

Base is for creating, designing, editing and browsing SQLite 3 database files.

It's small, powerful and comfortable - a proper macOS application that's fast to launch and quick to get you to the data you need.


Base starts with all the essential features you need:

• A clear schema inspector for visualizing table structures
• Intuitive table contents viewing and editing
• A powerful SQL editor with intelligent autocomplete and syntax highlighting
• Command logging and query history


Then makes it all even better:

• A visual table designer - Create and modify tables without writing complex CREATE or ALTER statements. Add columns, define constraints, and organize your database structure through a clean, intuitive interface

• Multiple database support - Work with multiple attached databases simultaneously for complex projects

• Support for advanced SQLite features - Full support for WITHOUT ROWID tables, STRICT tables, partial indexes with WHERE clauses, named table constraints, and generated columns

• Code Snippets - Store your commonly used SQL as reusable snippets

• Comprehensive import & export - Import data from CSV and SQL files. Export to SQL, CSV, JSON, and Excel formats

• Complete constraint support - View and edit ALL column- and table-level constraints, from simple default values to complex foreign key relationships



Note: By default, Base 3 runs in "Free mode" where advanced features are not available. To unlock these advanced features, there is a one-time purchase fee.

---
Legal notices
Terms of use (EULA): https://www.apple.com/legal/internet-services/itunes/dev/stdeula/
Privacy: https://menial.co.uk/privacy/