Recern Workspace
Recern Workspace 1.0.0 is a desktop app for understanding databases. Connect to PostgreSQL, MySQL, Microsoft SQL Server, MongoDB, ClickHouse, Cassandra, Qdrant, OpenSearch, Redis, Valkey and Dragonfly, or open SQLite and Recern Vector files. Inspect activity, locks, slow queries, indexes and memory, with findings that point to the view that explains them.
Production connections start in Safe Mode. The console also keeps query history, saves named queries and exports results; connections can be organized into your own groups.
Try a practical guide
- Find the session blocking a PostgreSQL query.
- Check whether a pgvector index matches your query.
- Build your first vector search in Python.
What it works with
| Database | Views |
|---|---|
| PostgreSQL | Overview, Sessions, Locks, Queries, Tables, Indexes, Vectors, Console |
| MySQL | Overview, Sessions, Locks, Queries, Tables, Indexes, InnoDB, Replication, Console |
| Microsoft SQL Server | Overview, Sessions, Locks, Queries, Tables, Columns, Indexes, Access & limits, Console |
| MongoDB | Overview, Collections, Documents, Indexes, Operations, Console |
| ClickHouse | Overview, Queries, Tables, Indexes, Parts, Merges, Mutations, Replicas, Console |
| Cassandra | Overview, Topology, Keyspaces, Tables, Columns, Indexes, Estimates, Compactions when permitted, Console |
| Qdrant | Overview, Collections, Vectors, Payload indexes, Points, Cluster when permitted, Console |
| OpenSearch | Overview, Indices, Nodes, Shards, Mappings, Documents, Access & limits, Search console |
| Redis, Valkey, Dragonfly | Overview, Memory, Clients, Slow log, Keys, Vectors, Console |
| SQLite files | Overview, Tables, Indexes, Pragmas, Console |
| Recern Vector files | Overview, Index, Recall |
PostgreSQL's Queries view needs pg_stat_statements; its Vectors view appears when pgvector is installed. Redis-family vector views depend on the server's search module or vector-set commands. MySQL diagnostic views report missing permissions or unavailable Performance Schema data in the affected view.
Coming later: Azure SQL, DynamoDB, Databricks SQL, Oracle Database, IBM Db2 and SAP HANA. These six integrations are planned for releases after 1.0. See all databases and the roadmap.
MongoDB, ClickHouse, Cassandra, Qdrant, OpenSearch and Microsoft SQL Server consoles are always read-only. App statistics are optional, disabled by default, and enabled only with permission in Settings → Privacy. See shortcuts and settings for the data shared and how to turn it off.
In these docs
- Getting started: install Recern and add a first connection.
- Connections: connection settings, groups, environments, TLS and passwords.
- Microsoft SQL Server: SQL authentication, verified TLS, diagnostics and bounded read-only T-SQL.
- Backups & recovery: local settings checkpoints, restore, credential exclusions and rollback limits.
- MongoDB: authentication, collections, JSON queries and BSON exports.
- ClickHouse: HTTP(S), diagnostics, read-only SQL and result limits.
- Cassandra: CQL, schema, reported topology and request limits.
- Qdrant: API keys, vector queries, payload filters and paginated points.
- OpenSearch: cluster diagnostics, mappings, documents, JSON searches and account-permission evidence.
- Changelog: changes in Workspace 1.0.0 and earlier releases.
- SSH tunnels: reach private databases through a bastion host.
- Safe Mode and the console: what each engine allows and refuses.
- Query history, saved queries and export: reuse commands and export displayed results.
- Views: the dashboard, findings and the views for each database.
- Shortcuts and settings: keyboard shortcuts, updates, themes and refresh options.