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/

Ratings & Reviews

  • This app hasn’t received enough ratings or reviews to display an overview.

• Adopted the new Liquid Glass style • Updated SQLite to v3.50.4 • Added a button for clearing sorting & filtering in the data browser • Added a button to jump to a table in the database size inspector • Added an option to always enable foreign keys when opening a database • Added an option to hide shadow tables • Re-ordered filter predicates to put more commonly used ones at the top • When showing the table editor, the table name field is automatically selected • Slightly improved performance for some large tables • When importing or exporting finishes, the app will show a notification • Fixed a bug causing filter buttons to disappear from the data browser • Base will now sometimes, politely, ask for a review on the App Store

Version 3.1.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

Information

  • Seller
    • Menial Ltd
  • Size
    • 40.8 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
  • Developer Website
  • Privacy Policy

    • More by Menial