Skip to content

Paid plans add features and fund TablePro’s development. Optional paid plans See plans

SurrealDB client

Run SurrealQL and edit record fields while preserving their types.

Works on MacDriver downloads on first use of SurrealDB

Included in Free; paid plans add optional featuresOpen source (AGPL-3.0)

A SurrealQL query in the editor and the records it returned in the data grid.

At a glance

Query language
SurrealQL
Driver
Downloads on first use
Connect with
Host and port, SSH tunnel, SSL/TLS
Default port
8000
Minimum version
2.0, enforced: older servers are refused
iPhone and iPad
Does not open

Connect and sign in

Choose Auth Level for the user: Root, Namespace, Database, Record Access or Token. Namespace and Database require their names. Record Access also requires the access method and sign-in fields; Token accepts an existing JWT.

The driver talks CBOR over the HTTP RPC endpoint, so record links, datetimes, durations, decimals and UUIDs keep their types. A surrealdb:// link opens the connection form filled in, and a remote server can be reached through an SSH tunnel.

SSL starts Disabled, which is plain HTTP; every other mode uses HTTPS. Verify CA and Verify Identity check the certificate against the system trust store, and a CA file set in the SSL/TLS pane is ignored, so install a private CA in macOS first.

SurrealQL and records

Run complete SurrealQL scripts, including RELATE, with statement completion. Explain and Explain Full run the query with EXPLAIN and return a text plan.

Namespaces sit at the top of the sidebar with their databases inside. Switching either never reconnects, because the namespace and database ride on each request. Only a root user sees every namespace.

Cell edits update only changed fields as typed parameters, preserving computed FUTURE fields and other writers’ changes. Leave id empty for an autogenerated ID. SCHEMALESS table columns come from fetched records.

Filters become SurrealQL, and a Raw SQL row takes one condition, such as a graph traversal. A condition that writes, holds a ; or a comment, or calls into fn:: or http:: is refused; run it in the editor.

Structure

The Structure tab is read-only. Create and change fields and indexes with DEFINE FIELD and DEFINE INDEX in the editor. A namespace or a database is dropped from its menu, and selecting several asks once for all of them.

Move data

There is no import. Export a table or a SurrealQL result as CSV, JSON, SQL, XLSX, Markdown, HTML and XML.

iPhone and iPad

The iPhone and iPad app has no SurrealDB driver. SurrealDB connections synced from a Mac appear in its list but do not open.

Limits

  • SurrealQL is not syntax-highlighted in the editor.
  • Live queries are not supported. Rerun a query to see new records.

Questions about SurrealDB

Can I run a transaction?

Within one query, yes. HTTP RPC carries no transaction from one request to the next, so send BEGIN TRANSACTION; … COMMIT TRANSACTION; as a single editor query.

How do I change the in or out of a relation?

Not from the grid: the save stops, names the field and keeps every edit pending. An UPDATE does not move a relation either, so delete it and RELATE the new pair.

Get TablePro

Download the Mac app for free. Starter and Team add optional features.
Download for Mac

Requires macOS 13 Ventura or later

See pricing