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/
| Size | 17.8 MB |
|---|---|
| Initial release | |
| Price | |
| Platforms | Mac |
| Languages | English |
| Category | Developer Tools |
| Website | menial.co.uk/base |
| Compatibility | |
|---|---|
| Mac | Requires macOS 15.0 or later. |
App's data is regularly updated.
Last update:
**New** - The table schema editor has been simplified. Columns and table constraints are now in a single table with section titles. Buttons for adding/removing items now have text labels for clarity. - You can now copy rows and cells from the data browser table from a right-click menu - The data browser now has an "insert special" context menu for quickly inserting dates, UUIDs and NULL values - SQL autocompletions for SQLite functions has been expanded to cover all built-in functions - Added experimental options (opt-in from the settings window) for working with large tables: - Disabling the counting of rows in a table - Allow selecting which columns should be shown in the data browser **Updated** - SQL autocomplete suggestions show less eagerly (eg. after typing a semicolon or a complete keyword) - The sidebar now only shows database schema names when multiple non-empty databases are attached - The row editor preview column now resizes to fill available space **Fixed** - The SQL editor no longer loses focus after executing a statement - Clicks in the space below text in the SQL editor now behave like other text views on macOS - Fixed the "Send to SQL" button not working - Database pragma values now update correctly after being changed - Tables containing columns with default value of a signed number are now displayed correctly - Fixed a UI misalignment in the autocomplete window - (v3.2.1): Fixed the table editor sometimes showing options for the wrong type of table constraint