get_records
Get Records
Retrieve records from a Softr table. Fetch a single record by ID, or list records with pagination. Use the `fieldNames` option to get human-readable field names instead of field IDs in the response.
get_records
Retrieve records from a Softr table. Fetch a single record by ID, or list records with pagination. Use the `fieldNames` option to get human-readable field names instead of field IDs in the response.
list_tables
Retrieve all tables in a specific Softr database, including their fields (schema). Useful for discovering available tables and understanding their structure before querying records.
delete_record
Delete a record from a Softr table by its ID. This action is permanent and cannot be undone.
manage_table
Create, retrieve, update, or delete a table in a Softr database. - To **create**: provide `databaseId` and `name`. Optionally include `primaryFieldName` and `fields`. - To **get**: provide `databaseId` and `tableId`. - To **update**: provide `databaseId`, `tableId`, and new `name`/`description`. - To **delete**: provide `databaseId`, `tableId`, and set `delete` to true.
sync_users
Trigger a user sync in a Softr application. You can sync all users, or provide specific email addresses to sync only those users. Requires the **domain** to be configured in the integration settings.
create_record
Create a new record in a Softr table. Provide field values as a map of field IDs (or field names if `fieldNames` is true) to their values.
update_record
Partially update a record in a Softr table. Only the fields provided will be updated; other fields remain unchanged.
list_databases
Retrieve all databases accessible to the authenticated user. Returns database names, IDs, workspace associations, and table counts.
delete_user
Delete a user from a Softr application by their email address. Requires the **domain** to be configured in the integration settings.
manage_database
Create, retrieve, update, or delete a Softr database. - To **create**: provide `workspaceId` and `name`. - To **get**: provide `databaseId` only. - To **update**: provide `databaseId` along with `name` and/or `description`. - To **delete**: provide `databaseId` and set `delete` to true. Database must be empty.
search_records
Search for records in a Softr table using filters, sorting, and pagination. Supports a rich set of filter operators for precise querying. **Available filter operators:** - **Comparison:** IS, IS_NOT, GREATER_THAN, GREATER_THAN_OR_EQUALS, LESS_THAN, LESS_THAN_OR_EQUALS - **String matching:** CONTAINS, DOES_NOT_CONTAIN, STARTS_WITH, DOES_NOT_START_WITH, ENDS_WITH, DOES_NOT_END_WITH - **Array:** IS_ONE_OF, IS_NOT_ONE_OF, HAS_ANY_OF, HAS_ALL_OF, HAS_NONE_OF - **Null checks:** IS_EMPTY, IS_NOT_EMPTY - **Range:** IS_BETWEEN, IS_NOT_BETWEEN, IS_WITHIN, IS_NOT_WITHIN - **Composite:** AND, OR (for combining multiple conditions)
generate_magic_link
Generate a magic link for a user in a Softr application, enabling passwordless authentication. The user must already exist in the app. Requires the **domain** to be configured in the integration settings.
create_user
Create a new user in a Softr application. Optionally generates a magic link for passwordless login. If no password is provided, one will be auto-generated by Softr. Requires the **domain** to be configured in the integration settings.
validate_user_token
Validate a Softr user authentication JWT token. Useful when using Softr user data in external systems outside of Softr to verify the token is valid and extract user information. Requires the **domain** to be configured in the integration settings.
manage_table_field
Add, retrieve, update, or delete a field (column) on a Softr table. Use this to manage the schema of your tables. - To **add**: provide `name` and `type`. Supported types include: SINGLE_LINE_TEXT, CHECKBOX, CURRENCY, DATE, DATETIME, DURATION, EMAIL, SELECT, NUMBER, ATTACHMENT, RATING, LINKED_RECORD, LONG_TEXT, URL, PERCENT, PHONE. - To **get**: provide `fieldId` only. - To **update**: provide `fieldId` with new `name`, `type`, or `options`. - To **delete**: provide `fieldId` and set `delete` to true.
Manage users, databases, tables, and records in Softr no-code applications. Create and delete app users, generate magic links for passwordless authentication, sync users, and validate JWT tokens. Perform full CRUD operations on databases, tables, table fields (schema), and records. Search and filter records within tables. Integrate Softr data with external systems via its Database and Studio APIs.
Common questions about connecting Softr to AI agents with Metorial.