All integrationsDatabases

SurrealDB

Run SurrealQL, and list, find, create, insert, update and delete records in your SurrealDB database, on SurrealDB Cloud or your own server.

actions
16

Actions

Steps a workflow can run in SurrealDB.

  • Run SurrealQL queryRun one or more SurrealQL statements in the database and get each statement's result. Anything the connected user may do can run, including changes and deletes.
  • List recordsGet a page of a table's records, up to 1000. To see more, run it again with the next page's Skip value.
  • Find recordsFind records in a table that match one condition, sorted and limited, with all their fields or only the ones you name.
  • Get recordGet one record by its id. When there is none, 'found' is false instead of the step failing.
  • Create recordCreate a record in a table, with an id made by SurrealDB or one you choose. Fails if that id already exists.
  • Insert multiple recordsCreate up to 200 records in a table in one request, each with an id made by SurrealDB.
  • Replace recordReplace a record's fields with exactly the ones given; fields not listed are removed. Use 'Update record fields' to keep them.
  • Update record fieldsChange only the fields given on an existing record and keep all its other fields.
  • Delete recordDelete one record by its id and return what it held. A record that is already gone is reported, not an error.
  • Count recordsCount the records in a table. Add a filter to count or total only the records that match it.
  • Total a fieldAdd up, average, or find the smallest or largest value of a number field across a table's records. Add a filter to count or total only the records that match it.
  • List tablesList the tables in the database and whether each enforces a schema.
  • Get table structureGet a table's defined fields, indexes and events.
  • List databasesList the databases in the connection's namespace. Needs a root or namespace user.
  • Get server versionGet the version of SurrealDB the server runs. Needs no sign-in.
  • Check server healthCheck that the server and its storage answer. An unhealthy server is reported as 'healthy' false, not as a failed step.

Automate SurrealDB with Lodol.

Connect SurrealDB, then hand Lodol the job in Slack, Claude or ChatGPT.

Free plan, no credit card