The best SQLite database editor for macOS
Base is a small, powerful, comfortable SQLite editor for everyone
Detailed Schema Inspector
Manage your database structure with Base's schema inspector, making understanding your tables effortless.
View table schemas, column types, constraints, and relationships at a glance. Understand your table design without digging through SQL.
Intuitive Table Editor
Create and modify tables with ease using Base's visual table editor. No need to write complex CREATE or ALTER statements.
Add and organize columns and define constraints through a clean interface. The table editor makes database design accessible to everyone.
Simple Data Browser
Browse, filter and edit your table contents with ease.
View your data in a simple table format. You can edit cells directly and use powerful filtering tools to find exactly what you need. The data browser makes working with your database contents easy and efficient.
SQL Editor & Query Tools
Write and execute SQL queries with intelligent autocomplete and syntax highlighting.
Store your common queries as reusable snippets, view query results instantly, and take advantage of helpful features that make SQL more accessible. Perfect for both learning SQL and running complex queries efficiently.
Import & Export
Import data from CSV and SQL dump files. Export your results to SQL, delimited text, JSON, and Excel formats.
Move your data in and out of Base quickly and easily - whether you're migrating from another system or sharing results with colleagues.
Import
CSV
SQL
Export
Want to try Base out?
Download for free now.
The free version is feature-limited and requires a one-off purchase to unlock the full version.
Base 3 requires macOS 15 Sequoia or newer.
Need some help?
Have a look at the documentation for Base, or send us an email.