Skip to content
Edith

Database

Database GUI for Mac

Browse and safely edit your databases without leaving your Mac.

Developer & Data
Get Edith

Database is an Edith extension that saves connections to PostgreSQL, MySQL, MariaDB, SQLite, MongoDB, Redis, Valkey, Elasticsearch, OpenSearch and ClickHouse, then lets you browse, query and edit them with a preview before any change runs.

Most developers touch several kinds of database in a week: a relational one for the app, Redis for caching, maybe MongoDB or a search cluster. Database covers relational, key-value, document, search and analytical stores in one window. Add a connection by picking the type and entering the host, or choose a file for SQLite. Edith tests it before saving, keeps the password in your Keychain, and then shows the tables, collections or keys inside. You can page through records, search, sort and filter without writing a query.

Changes are where it is deliberately careful. An edit to a row, a key or a document, or a query that would modify data, first becomes a preview showing exactly what will change, and nothing runs until you confirm that exact preview. Each connection also carries a safety policy: standard, require a preview for every change, or refuse changes entirely, which is the one to pick for production. Long-running operations are tracked and can be cancelled.

Coding agents get a careful path too. ed database mcp runs a separate MCP server over stdio whose tools list saved connections, browse records and run bounded read queries, while its Redis key and document change tools only apply a change after a preview is confirmed. The ed database commands are also tools in Edith's own MCP server. Queries you run often can be saved by name with ed database saved-queries and pulled up again later.

Updated

Database GUI for Mac browsing a PostgreSQL table with filters and a previewed row edit

How to browse and edit a database on Mac

  1. 1

    Add a connection

    Pick your database type and enter its host, or choose a file for SQLite.

  2. 2

    Open it

    Edith connects and shows the tables, collections or keys inside.

  3. 3

    Browse and filter

    Look through records, search, sort and filter without writing a query.

  4. 4

    Review before changing

    Edits show exactly what will change and wait for your confirmation. Agents can read through a read-only MCP server.

What it does

Browse a database

Connect to PostgreSQL, MySQL, SQLite, MongoDB or Redis and look through tables.

Run a query

Write a query and see the results, with risky changes previewed first.

Does macOS do this already?

Does macOS include a database app?

Not a graphical one. macOS ships the sqlite3 command-line tool, which opens SQLite files in Terminal, and nothing for PostgreSQL, MySQL, MongoDB or Redis. Database gives all of them a browser, a query editor and previewed edits in one window, with passwords in your Keychain rather than in a config file.

Use cases

Look at production data without risking it

Save the production connection with the refuse-changes policy and a staging copy with standard. You can browse and query production freely, and any edit you try there is refused, while staging still lets you fix a row after a preview.

Check what a Redis key actually holds

Open the Redis or Valkey connection, find the session or cache key, and read its value and expiry. Setting a new expiry on a string key, or deleting it, goes through a preview of that one key before it happens.

Let Claude Code read your schema

Point your agent at ed database mcp and it can list connections, browse tables and run bounded read queries while it writes a migration, without ever being handed the connection password.

Open a SQLite file from an app

Many Mac apps and dev tools keep their data in SQLite. Add a connection, choose the .sqlite or .db file, and browse its tables the same way you would a server database.

From the terminal and your coding agents

Every example returns JSON with --json, and agents can call the same thing over MCP.

$ ed database connections list
$ ed database connections add notes --product postgresql
$ ed database connect <connection-id>
CommandMCP tools
ed databaseedith_database_*

Connect Claude Code, Codex, Cursor or another client through the Edith MCP server.

Permissions and requirements

Permissions

  • Keychain, to store connection passwords
  • Access to the SQLite files you choose

Requirements

  • macOS 14 or later on Apple silicon
  • Network access to each database server, or a local SQLite file

Recent changes

Frequently asked questions

Which databases does it support?

PostgreSQL, MySQL, MariaDB and SQLite for relational data, Redis and Valkey for keys, MongoDB for documents, Elasticsearch and OpenSearch for search, and ClickHouse for analytics. The drivers come with the extension.

Where are my database passwords stored?

In your macOS Keychain. Saved connection details hold no secrets, and ed database connections show prints a connection without its credentials.

Can it stop me from changing a production database by accident?

Yes. Give that connection the policy that refuses changes, and every edit through Edith is rejected. The middle policy requires a preview for every change, so nothing runs without a deliberate confirmation.

Can Claude Code query my database over MCP?

Yes, carefully. Add ed database mcp to your agent as an MCP server. Its database_browse and database_query tools read data in bounded pages, and the tools that change a Redis key or a MongoDB, Elasticsearch or OpenSearch document work only through a preview that has to be confirmed.

Does it support encrypted connections?

Yes. Each connection carries its own TLS settings, so you can connect to servers that require encrypted connections.

Is Database included in Edith's one-time price?

Yes. Database comes with every Edith license, with every supported driver included in the extension.

Get Edith.

From $35 once. No subscription. No account.

Download for macOS

Needs a license key · macOS 14 or later on Apple silicon · 6.4 MB