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
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