# Database GUI for Mac

> Browse and safely edit your databases without leaving your Mac.

- Canonical URL: https://getedith.pro/extensions/database-client
- Category: [Developer & Data](https://getedith.pro/extensions/category/developer-tools)
- Extension ID: `database`
- Updated: 2026-11-15
- Part of: [Edith](https://getedith.pro/), a Mac app for macOS 14 or later on Apple silicon, [$35 once for one Mac, plus $7 for each additional Mac](https://getedith.pro/pricing)

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.

## Overview

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.

## How to browse and edit a database on Mac

1. **Add a connection**: Pick your database type and enter its host, or choose a file for SQLite.
2. **Open it**: Edith connects and shows the tables, collections or keys inside.
3. **Browse and filter**: Look through records, search, sort and filter without writing a query.
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 you can do

- **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 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.

## Command line and MCP

Run `ed database` from Terminal, and add `--json` for JSON output. Coding agents connected to the [Edith MCP server](https://getedith.pro/mcp) call the same commands as tools whose names start with `edith_database`.

```sh
ed database connections list
ed database connections add notes --product postgresql
ed database connect <connection-id>
```

## 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

## FAQ

### 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.

## Works well with

- [SSH Server Manager for Mac With Docker and Files](https://getedith.pro/extensions/ssh-machines): Watch, browse and run your servers and containers from one place.
- [Terminal With Broadcast Input and Tabs for Mac](https://getedith.pro/extensions/terminal): A fast built-in terminal with tabs that keeps your shells in one place.
- [GitHub Code Stats on Mac: Commits, Lines, Streaks](https://getedith.pro/extensions/code-stats): See how much code you write, across every GitHub repository you own.

## Use cases

- [Manage Servers From Your Mac With Edith](https://getedith.pro/use-cases/manage-servers-from-your-mac): Manage SSH servers from your Mac: health, terminals, Docker, port forwards, a database client and agent usage across machines, from one app and the ed CLI.
