Docs · DevCatz

Databases

Run MySQL, MariaDB, PostgreSQL, Redis, Valkey, MongoDB and Elasticsearch on your Mac or PC, link them to sites, and bring databases over from elsewhere.

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 --install in 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_URL for 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