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.
No actions match that.
Automate SurrealDB with Lodol.
Connect SurrealDB, then hand Lodol the job in Slack, Claude or ChatGPT.
Free plan, no credit card