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.

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

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

The developer has not yet indicated which accessibility features this app supports. Learn More

  • Seller
    • Menial Ltd
  • Size
    • 42.2 MB
  • Category
    • Developer Tools
  • Compatibility
    Requires macOS 15.0 or later.
    • Mac
      Requires macOS 15.0 or later.
  • Languages
    • English
  • Age Rating
    4+
  • In-App Purchases
    Yes
  • Copyright
    • © 2025 Menial Ltd