Locks
Who is waiting on whom
Wait chains show the blocked statement, the session that holds the lock and how long its transaction has been open.
Recern WorkspaceOne workspace.
One workspace.
Every database you run.
A desktop workspace for PostgreSQL, MySQL, Microsoft SQL Server, MongoDB, ClickHouse, Cassandra, Qdrant, OpenSearch, SQLite, Redis, Valkey, Dragonfly and Recern Vector: activity, queries, indexes and findings, with Safe Mode for production.
Download Version 1.0.0 · macOS, Windows and Linux
A closer look
Every view,
built for its engine.
Every connection at a glance
Throughput, memory and open findings for each connection, grouped by environment. Production is marked, and critical findings come first.
In detail
Answers,
not just numbers.
Queries
Where query time goes
With pg_stat_statements installed, Recern ranks statements by total time, calls, rows and disk reads, so the expensive ones stand out.
Redis · Valkey · Dragonfly
Where the memory goes
Data, key overhead, scripts and client buffers, the peak and fragmentation, and used memory over the last hour.
Recall
Recall you can measure
Recern compares approximate search with exact search at every ef, so you see what raising ef_search buys and what it costs.
Production-aware
Safe by default
in production.
Safe Mode
Production connections open in Safe Mode, marked in the window and on the dashboard.
A console that cannot write
Production connections start in Safe Mode. PostgreSQL and MySQL use read-only transactions; SQLite opens read-only and blocks unsafe operations; Redis refuses commands that write. TLS and SSH tunnels are available for server connections. MongoDB, ClickHouse, Cassandra, Qdrant, OpenSearch and Microsoft SQL Server consoles are read-only in this version. TLS support through SSH depends on the engine; see the connection documentation. Use a dedicated read-only account and query limits; Safe Mode does not replace database permissions or prevent expensive reads.
SSH tunnels
Reach private databases through a bastion with a password, a key or your SSH agent. Host keys are checked against known_hosts.
TLS and the keychain
Connections can require TLS with certificate checks. Passwords are kept in the system keychain, never in the configuration file.
Made for every day
⌘KSearch everything
⌘NNew connection
⌘1Dashboard
⌘,Settings
⌘RRefresh
- Persistent query history and named saved queries
- Export displayed SQL results as CSV or JSON; Redis replies as JSON
- Named connection groups and custom ordering
- Light and dark themes, menu bar access and automatic refresh
- App context menus and optional statistics with explicit consent
A useful first session
Follow a short guide from a real question to an answer in Recern.
Why is this query waiting?
Follow a PostgreSQL lock chain to the transaction that holds it up.
Does this vector query match its index?
Check pgvector columns, distance operators, settings and index usage.
Build your first vector search
Create a local collection, filter results and inspect how the search ran.
Try it on
your own databases.
Recern 1.0.0 for macOS, Windows and Linux.
Download Version 1.0.0 · macOS, Windows and Linux