Database client
Curiosity won’t kill this cat.
Free and open source, for MySQL, PostgreSQL, Redis, MongoDB and more. DBCatz connects to the databases DevCatz runs — and to everything else, over SSH, AWS IAM or Vault — with a Production mode that stops you from breaking what matters.
connected · [email protected]:55432/catz_shop · PostgreSQL 18.6 · 15 ms
MySQL
MariaDB
PostgreSQL
SQLite
Redis
Valkey
MongoDB
ElasticsearchIn the app
Real screens from the app — no stuffed cats, no mock-ups. Keep scrolling: it plays.
Databases
Relational, key-value, document and search — with an editor that speaks each one’s language.
> which customers paid twice this month?
AI, with your schema
The same shared AI connection as DevCatz (Claude by default; OpenAI, Gemini, DeepSeek, Z.ai, Mistral, xAI, Groq, OpenRouter, Ollama and any OpenAI-compatible server). Only structure is sent — tables, columns, types, keys, indexes, estimated rows — never your data, unless you switch Send samples on for a connection.
The query never runs on its own
It lands in the editor, formatted; you read it, then you press Run.
Structure, never your rows
Tables, columns, types, keys and indexes go out — data only if you switch Send samples on, per connection.
Keys stay in your Keychain
Encrypted by macOS, never in a settings file.
Read-only stays read-only
On a read-only connection the AI is asked for SELECT only, and Run refuses the rest.
SQL · Redis / Valkey · MongoDB (mongosh) · Elasticsearch (Kibana console)
The query lands formatted in the editor and never runs on its own. Follow-ups in the same thread, Fix with AI on a failed statement, the answer streams in as it is written. Read-only connections get SELECT only.
Open a table, filter rows, export, back up, create a database…
Plain words become steps you run one by one. Destructive steps are red, reviewed, and still go through the dialog where you type the name.
An error row, or “why is this slow?”
What happened, why, and the fixed or faster statement with Copy and Open in Query. Obvious secrets are masked before sending.
Every feature has its own switch
See the exact structure and lines that go to the provider before they do.
Off until you turn it on · one connection, shared with every Catzoid app ·Claude (default)OpenAIGeminiDeepSeekZ.aiMistralxAIGroqOpenRouterOllamaany OpenAI-compatible server
The MCP with the cats insidesoon
One MCP server for the whole Catzoid family. Your AI assistant — Claude, Cursor or any other that speaks MCP — will be able to list tables and run read-only queries on the connections you allow in DBCatz, and reach the other cats you have installed through the same connection. One connection, every cat — and you hold the keys: only what you allow, nothing runs without you seeing it.
Works with ClaudeGeminiGPTGLM— any app that speaks MCP.
Meet MCatzPConnect anywhere
TCP/IP · Unix socket · SSH tunnel (key, password or ssh-agent, built in) · AWS IAM · HashiCorp Vault
AWS IAM tokens for RDS are signed locally with the RDS CA and renewed every 10 minutes; Vault gives dynamic credentials or KV v2 secrets. No side scripts, no copied passwords.
mysql:// · postgres:// · redis:// / rediss:// · mongodb:// / mongodb+srv:// · https:// (Elasticsearch) · sqlite:// · a whole DATABASE_URL= line from .env
Paste it as a quick session or let it fill the form. The fastest way from a .env to a query.
SSL (require / verify) · LOCAL INFILE · cleartext plugin · public key · timeout · session time zone
Test / Connect show every step — Vault → AWS → SSH → reach → sign in — with Cancel and a readable error when one fails.
Passwords · SSH passphrases · AWS keys · Vault tokens
Encrypted by macOS, never in a plain config file.
Favorites · your own groups · drag-and-drop order · colour per connection · connected dot · several tabs per connection
Fifty connections stay readable.
Production safety
The client assumes you will make a mistake one day, and makes that mistake harmless.
Safety · per connection
Normal · Production (PROD chip, asks before every write, destructive statements need the connection name typed) · Read-only (writes refused, the server session itself is read-only)
A production connection looks and behaves differently, every time.
Primary key · foreign keys · values that would not fit the new type · duplicates before UNIQUE · charset / collation · long rebuilds
Blocked with what to do instead, or marked risky so you type the name. Dropping or truncating a table other tables reference is refused.
DROP · TRUNCATE · ALTER · UPDATE / DELETE without WHERE · FLUSHALL · deleteMany({})
The one line you did not mean to run gets a second look.
Working with data
Paging · sort · filter · inline edit · insert (typed field per column, Default / NULL / Value) · delete
Type-aware editors: ENUM dropdown, boolean toggle, date / time pickers, JSON editor, long text. Fewer typos, fewer bad rows.
Resizable / reorderable columns · saved filters · foreign-key links with Back
Click a value to jump to the row it references and come back.
Columns, indexes, foreign keys, CREATE statement · add / change / drop with type pickers · Unique, charset, collation, comment per column · create / rename / truncate / drop tables · create database
No typos in types, and your own tables come first — system tables (mysql, information_schema, sqlite_*…) are grouped apart.
Several editors · ⌘⏎ runs all or the selection · one result per statement · copy CSV / JSON · editable single-table SELECT results
Syntax highlighting and autocomplete for SQL, mongosh, the Kibana console and redis-cli: statements, tables, alias-aware columns, functions, Redis commands with their syntax and the database’s keys. Saved queries and history per database.
Key browser (pattern, type, size, TTL) · editor per type · rename / TTL / delete / flush · Command tab with suggestions
JSON values pretty-printed, and PHP serialize() values (Laravel jobs, cache, sessions) shown as readable objects — a big help for Laravel developers.
Export SQL, CSV, JSON / NDJSON, XML, DOT diagram, Redis script · import SQL / .sql.gz, CSV, NDJSON, Redis script, DBCatz backups · back up chosen databases to one .tar.gz
Progress in a Jobs panel; long jobs do not block the app.
Activity per connection (every query, edit and DDL with timing, rows and errors) · the server’s own log
See what the app did, and ask AI why a statement was slow.
Better together
DevCatz’s database services show up in DBCatz as “DevCatz services” with live status and no setup. Open in DBCatz from DevCatz, Open in DevCatz from DBCatz; DevCatz installs DBCatz when it is missing. And after a DialCatz request, DBCatz opens the table it touched.
One file is the whole contract.DevCatz writes the services it runs; DBCatz follows the file and lists them. Nothing talks to anything.
Check in DBCatz.After a request, Check in DBCatz opens the table the call just touched — at the row, when the URL or the JSON answer has its id.No host, port or password to copy for local databases.
Stop a service in DevCatz and its DBCatz tab shows Disconnected / Reconnect.
Check in DBCatz after a request lands on the table it touched, at the row — read-only, it only opens.
Ready for adoption
macOS 13+ on Apple silicon and Intel; Windows is on the way. No account, no licence key — all cats, no catch.
Apple siliconIntel MacWindows · soon
