DevCatz runs real database servers for your sites — as many as you like, each with its own version, port and data folder. Open Database in the rail to set them up. Each site then links to the one it uses, and DBCatz opens them all without any setup.
The engines
The same engines run on macOS and Windows; where the server builds come from differs. The install form and each server’s page say so under Builds: / Builds from, with a link to the source.
| Engine | Where the server comes from | Default port |
|---|---|---|
| MySQL | Official macOS tarballs from cdn.mysql.com (MD5 from the CDN), for example 8.4 LTS | 3306 |
| MariaDB | Homebrew (MariaDB publishes no macOS builds) — 11.8, 11.4, 10.11 and 10.6 LTS; runs with DevCatz’s own data folder and port | 3306 |
| PostgreSQL | Relocatable builds from github.com/theseus-rs/postgresql-binaries (SHA-256) | 5432 |
| Redis | Official source from download.redis.io (SHA-256 from redis-hashes), compiled on this Mac | 6379 |
| Valkey | Official source from github.com/valkey-io/valkey (SHA-256 from valkey-hashes), compiled on this Mac | 6379 |
| MongoDB | Official Community Server builds from fastdl.mongodb.org (SHA-256) | 27017 |
| Elasticsearch | Official builds from artifacts.elastic.co with the bundled JDK (SHA-512); security is off for local use | 9200 |
| SQLite | The sqlite3 that ships with macOS — no server needed | — |
A few engines need something on your Mac first:
- Redis and Valkey are compiled when you install them, so they need the Xcode Command Line Tools
(
xcode-select --installin Terminal). - MariaDB needs Homebrew.
| Engine | Where the server comes from | Default port |
|---|---|---|
| MySQL | Official Windows x64 ZIP from cdn.mysql.com (MD5 from the CDN), for example 8.4 LTS | 3306 |
| MariaDB | Official Windows x64 ZIP from downloads.mariadb.org (SHA-256) | 3306 |
| PostgreSQL | Relocatable builds from github.com/theseus-rs/postgresql-binaries (SHA-256) | 5432 |
| Redis | Community Windows build from github.com/redis-windows/redis-windows (MSYS2, SHA-256 from GitHub) | 6379 |
| Valkey | Community Windows build from github.com/SamuelMarks/valkey-windows (the official source compiled with MSVC, SHA-256 from GitHub) — not published by the Valkey project | 6379 |
| MongoDB | Official Community Server Windows x64 ZIP from fastdl.mongodb.org (SHA-256) | 27017 |
| Elasticsearch | Official Windows x64 ZIP from artifacts.elastic.co with the bundled JDK (SHA-512); security is off for local use | 9200 |
| SQLite | Built into DevCatz; nothing to install | — |
Nothing is compiled on Windows: every server is an official zip, except Redis and Valkey, which neither project publishes for Windows. DevCatz takes those from community builds and says so in the form. If a server does not start, the Microsoft Visual C++ Redistributable (x64) may be missing — the error names it, with the download link.
Server builds are downloaded once and shared by every instance of that version, under db-services/bin in DevCatz’s
data folder.
Adding a database server
Press New database service at the top of the Database sidebar, pick the engine and the version, and fill in the form. You can run any number of instances, even several of the same engine side by side.
| Setting | What it does |
|---|---|
| Version | The server version |
| Name | What the service is called in DevCatz, DBCatz and the menu bar (the tray on Windows) |
| Port | The TCP port it listens on |
| Socket path | A Unix socket as well as the port — optional, for the SQL enginesmacOS only; on Windows databases use TCP only, so the form has no socket field |
| Data path | Where the data lives. Pointing at another folder starts from the data there |
| Config file | Your own server config file, if you have one |
| User / Password | By default root without a password |
| Disable the binary log | Skips the MySQL / MariaDB binary log, which saves disk space |
| Start automatically when DevCatz launches | The server starts with DevCatz |
Servers listen on 127.0.0.1 and ::1 only, so nothing outside your computer can reach them.
A PostgreSQL data folder only runs with the major version that created it. To move to a newer major version, make a new instance and import the databases into it.
Managing a server
Each server has its own page with overview, connection and logs tabs, and these actions:
- Start, Stop and Restart.
- Show database files and Show database server binaries open the folders in FinderFile Explorer.
- Settings… changes the form above.
- Linked sites shows which sites use this server.
- Remove… — type the service name to confirm. Ticking the option also deletes its data; otherwise the data folder stays.
The overview also shows Builds from — where this engine’s server builds come from, with a link.
The Database sidebar works like the Projects sidebar: favorites, groups, drag-and-drop order and a Running only filter. Deleting a group keeps the services.
The connection tab
The connection tab has everything a project needs to connect: host, port, user, password and database, with ready-made lines to paste:
DATABASE_URL- Laravel’s
DB_*lines REDIS_URLfor Redis and Valkey
Press Copy, or Write to .env to put them into a site’s .env file. You see a diff of the change first.
Servers that already run elsewhere
DevCatz notices database servers that something else runs on your computer, and port clashes with them, so you know
why port 3306 is taken.
On a Mac it finds servers from DBngin, Laravel Herd, Docker or OrbStack, Homebrew and Postgres.app, and lists DBngin’s own servers by name.
On Windows it checks the well-known database ports (3306, 5432, 6379, 27017, 9200 and their neighbours) and
names the program that answers on each — mysqld, a Docker Desktop relay and so on. Finding DBngin and Herd servers
is macOS only.
Importing from elsewhere
Import… copies MySQL, MariaDB or PostgreSQL databases from another server into a DevCatz service. The source is only read, never changed, so you can move over at your own pace and switch the site when you are ready.
The site Database tab
Each site has a Database tab that ties it to its data.
Linking a server
The card at the top shows which server the site uses. Choose a service… and Link connect it; from then on the linked server starts together with the site. A site that uses a SQLite file or an external database shows that instead.
Commands for the framework
Below the link card, the tab offers buttons for the site’s framework (see Detected stacks for each one):
- Commands — migrations, seeders and the like for Laravel, CodeIgniter, Yii, Symfony, CakePHP, WordPress, Drupal, Django, Flask and Alembic.
- Artisan card for Laravel:
migrate,db:seed,migrate:fresh --seed. - Prisma card:
migrate dev,db seed,generate,migrate reset…. - GORM / Go card: AutoMigrate, goose and other migration tools.
- Data access — the database libraries the project uses (ORMs, query builders, migration tools).
The Redis card
Sites that use Redis or Valkey get a Redis card. It tells Valkey apart from Redis and sets which numbered database the site uses:
| Setting | What it does |
|---|---|
| Database index | The numbered Redis database the site uses |
| Cache database | A separate index for the cache |
| Pick a free one | Picks an index no other site uses |
| Write to .env… | Writes REDIS_DB / REDIS_URL, Laravel’s REDIS_CACHE_DB and custom connections |
Giving every site its own index keeps their keys apart on one shared server. Worktree sites get their own index this way too.
Open in DBCatz
Open in DBCatz buttons on the Database page, the site’s link card and the Redis card open that database in DBCatz straight away. DBCatz also lists every DevCatz server under DevCatz services, with a live status dot and the credentials filled in. If DBCatz is not installed, DevCatz offers Download & Install. See the DBCatz docs and What the cats share.
Settings → Database
| Part | What it holds |
|---|---|
| Services | Every server, with Starts with DevCatz per service |
| Installed server builds | The downloaded builds, with Show and Remove |
| Defaults | Data folders of new services, the Server builds folder, Host in .env lines (this computer, or the address Docker containers use), and the DB domain — for example db, which gives db.localhost |
Each server logs to logs/db-<id>.log in DevCatz’s data folder; the logs tab shows it.
DevCatz never keeps database data in <data>/databases, because Chromium (which DevCatz runs on) uses and deletes a
folder with that name.
Last updated 2026-11-01