Clarity across
databases.

One workspace for your databases and vectors. Safe Mode for production.

Version 0.5.0 · macOS, Windows and Linux
The Recern Dashboard with seven fintech demo connections: PostgreSQL, MySQL, Dragonfly, Recern Vector, Valkey, Redis and SQLite, with activity and findings
01 / A clearer perspective

Understand what’s happening,
not just what’s stored.

Traditional database clients are built around tables, rows and query editors. Recern brings data, activity and performance into one workspace.

01

Overview

Is everything okay?

02

Data

What is stored here?

03

Activity

What is happening right now?

04

Performance

What is slow or expensive?

05

Console

Talk directly to the database.

Other database tools help you manage databases. Recern helps you understand them.

02 / Built around your database

Different databases.
Native understanding.

Each engine has its own way of working. Recern respects that — with workflows built around its runtime, not a generic interface.

MongoDBAvailableCollections, operations and how efficiently queries run.CollectionsDocumentsOperationsIndexes
ClickHouseAvailableParts, merges and mutations of your analytical workload.QueriesPartsMergesMutations
Microsoft SQL ServerComing soonSessions, locks, query performance, tables and indexes, with a read-only SQL console.SessionsLocksQueriesTablesIndexesConsole
AvailableCassandraQdrantOpenSearchComing laterMicrosoft SQL ServerAzure SQLDynamoDBDatabricks SQLOracle DatabaseIBM Db2SAP HANAAll databases and what comes next
Insights

See what deserves
attention.

Recern reads each server's own statistics and turns them into findings: a blocked session, an unused index, a collection full of deleted vectors. Each one leads to the view that explains it.

Inspect. Understand. Decide.
A blocked UPDATE and the session that holds its lock in a transaction left open.
Screenshot · Demo databasesA blocked UPDATE and the session that holds its lock in a transaction left open.
03 / Production-aware by design

Built for production.

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 and OpenSearch 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.

Safe Mode for productionRead-only consoleSSH tunnels with host key checksTLS and Keychain passwords
PRODUCTIONSafe Mode ON

Confidence before every command.

04 / Recern Vector Open source · v0.3.0

A vector database
in a single file.

Recern Vector 0.3.0 combines local HNSW search, WAL and int8 storage with a portable Python API and verified migration to Qdrant. Native Rust, Node.js and CLI APIs remain available.

  • Portable Python API
  • Qdrant adapter
  • Verified, resumable migration
  • Stable files, WAL and int8

MIT or Apache-2.0. Version 0.3.0 uses stable format 2 and reads format 1. Benchmark figures are the published baseline before 0.2.0.

import recern_vector as rv

db = rv.Database.open_or_create("docs.rvec")
docs = db.create_collection("docs", dim=384, metric="cosine")
docs.upsert_many(ids, embeddings, metadatas)

hits = docs.search(query, k=5, filter={"lang": "en"})
docs.explain(query, k=5)  # strategy, visited nodes, time
1.30×

faiss HNSW throughput at recall 0.95 on SIFT1M

1.78×

the same comparison on GloVe-100

35s

to index one million vectors

Open the file in Recern Workspace

Workspace inspects pgvector columns and indexes, Redis search indexes and vector sets when the server supports them, and Recern Vector snapshots with committed WAL changes. Recall checks are available for Recern Vector collections, including f32 and int8.

Recall and latency by ef for the payment_patterns int8 collection in the risk-intelligence demo database
05 / Questions / Answers

Recern,
explained clearly.

Direct answers about the workspace, supported databases and Recern Vector.

01

What is Recern?

Recern is a desktop workspace for databases. It brings activity, performance and the findings that need attention into one clear view, and keeps production connections safe by default. Alongside it we build Recern Vector, an open-source embedded vector database.

02

Which databases does Recern support?

Recern Workspace 0.5.0 supports PostgreSQL with pgvector, MySQL, MongoDB, ClickHouse, Cassandra, Qdrant, OpenSearch, SQLite, Redis, Valkey, Dragonfly and Recern Vector files. Microsoft SQL Server is planned for 1.0.0.

03

What about vector search?

Workspace inspects pgvector columns and indexes, Redis search indexes and vector sets when the server supports them, and Recern Vector snapshots with committed WAL changes. Recall checks are available for Recern Vector collections, including f32 and int8.

04

How does Recern approach production databases?

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 and OpenSearch 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.

05

Which platforms does Recern run on?

Recern is a desktop app for macOS, Windows and Linux. Builds appear on the download page as soon as they are released.