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/