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.
Must Have for Developers
CreativeApps
I have relied on this app since way6 back in 2013! It is my goto tool whenever I need to work with SQLite databases in my development lifecycle. I have tried so many other apps that have steep learning curves and are complex. My favorite thing about this app is that it is so powerful, yet so easy to use. The recent updates have elevated the app to new heights of usefulness. My fave new feature is that I can hide columns in tables with a large number if columns in their schema.
Wonderful attention to detail
jack135797531
Base really nails the UX/UI details for a simple database app. You can really feel the native SwiftUI and AppKit components used throughout; it’s very snappy and intuitive on macOS. The app is also performant, so clearly things seem to be working under the hood too. Overall highly recommended! Particular kudos for the interface to add constraints, I love the use of color-coded letter symbols.
THE best SQLite database editor
Gnarlodious
I have tried them all and this one is the best. Works well with R2L languages using highly readable fonts. Columns are re-orderable and there’s a useful SQL store&recall feature. Databases can be reconfigured from the app. Includes a logging feature where you can copy previous command lines. You need this app!
Added:
- Base now provides a Quick Look preview extension, showing a list of tables, views, indexes and triggers in previewed databases
- The Geopoly and RBU SQLite extensions are now enabled for use
Fixes:
- The numpad enter key can now be used to execute queries
- The selected row in the data browser jumps around less when editing data
- Data browser table headers no longer overlap row numbers when scrolling
- Table headers no longer get out-of-sync with columns when switching between tables
- Fix a crash which occured when adding a filter in the data browser
- Fix a crash which occurred when removing certain columns in the table editor
- Fixed overlapping text in SQL query results
Changes:
- The 'page_size' database option is now a dropdown instead of text field
- Update SQLite to v3.51.2
Version 3.3.0
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
Privacy practices may vary, for example, based on the features you use or your age. Learn More
Accessibility
The developer has not yet indicated which accessibility features this app supports. Learn More