
Base - SQLite Editor
The SQLite editor for everyone
Only for Mac
Free · In‑App Purchases
Mac
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/
This app hasn’t received enough ratings or reviews to display an overview.
**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
The developer, Menial, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy .
Data Not Linked to You
The following data may be collected but it is not linked to your identity:
- Identifiers
- Usage Data
Accessibility
The developer has not yet indicated which accessibility features this app supports. Learn More
Information
- Seller
- Menial Ltd
- Size
- 41.4 MB
- Category
- Developer Tools
- Compatibility
Requires macOS 15.0 or later.
- Mac
Requires macOS 15.0 or later.
- Languages
- English
- Age Rating
4+
- 4+
- In-App Purchases
Yes
- Pro Features $36.00
- Copyright
- © 2025 Menial Ltd