Skip to content

Base

Simplify SQLite file management

Base is an SQLite database manager for macOS. You can use it to create, search, and edit databases through a spreadsheet-like interface or work directly with SQL.

by Menial · 98% positive (120)

Get it on Setapp Free on the Mac App Store Developer website ↗
Helps you Manage databases 11

What you get

You can create, edit, and search SQLite databases without writing every command.

With Base, you can create an SQLite database for test data, experiments, or production work, then manage its contents in a spreadsheet-like view. You can change values and adjust table structures without writing long SQL statements, including adding or removing columns and editing defaults or foreign key constraints.

You can narrow down records with filters rather than typing out every query. When you do need SQL, autocomplete helps you enter standard commands, while saved snippets let you reuse queries you write often. You can also turn your filters into SQL statements.

You can bring in CSV data or import SQLite databases from dump files. When you need the results elsewhere, you can export tables and custom query results as SQL, delimited text, XML, or Microsoft Excel-compatible files.

  • Start a database quickly

    You can create SQLite databases for experiments, test data, or production files.

  • Change tables without lengthy SQL

    You can add, edit, or delete columns and constraints through a visual editing sheet.

  • Find the records you need

    You can filter data with less typing and export those filters as SQL statements.

  • Reuse your SQL work

    You can save frequently used SQL snippets and use autocomplete when writing standard commands.

  • Take your results elsewhere

    You can export tables and query results to SQL, delimited text, XML, or Excel-compatible formats.

Best for

  • You maintain SQLite files for an app or project
  • You want to edit database tables visually
  • You regularly filter and export SQLite data

Skip it if

You don't need it if you only work with spreadsheets or databases other than SQLite.

Screenshots

Base screenshot 1 Base screenshot 2 Base screenshot 3 Base screenshot 4

From the developer

Base is an SQLite database manager to quickly create, search and edit data on macOS. It’s a lightweight, simple and straightforward way of taking control over your databases. With a spreadsheet-like interface the app will feel familiar to all, so there’s no need in learning difficult SQL commands.
Read the full description

Alternatives to Base

Other apps to manage databases. See all

TablePlus Database Management made easy Setapp 99% · 2,557 ratings SQLPro Studio Manage multiple DBMS Setapp 97% · 650 ratings SQLPro for SQLite A simple but powerful SQLite editor. Setapp 96% · 114 ratings Hydra Dev Studio One native window for databases, file servers, Git and SSH, plus safe AI agents Sold separately Access MDB Viewer Mac App Store Navicat Premium Lite Mac App Store