Skip to content

Baserow

Baserow

Baserow is an open-source database tool that lets teams build no-code data applications, collaborate on records, and integrate with other services for data management. With the Baserow integration in SquadOS, your agents can interact with workspaces, databases, tables, forms, templates, and application builders directly from automation flows.

This tool uses an API key (API_KEY) to connect.

You will need the following fields:

FieldRequiredDescription
api_keyYesAPI key from your Baserow account, used to authenticate all requests to the instance.
  1. Go to baserow.io and log in to your account (or self-hosted instance).
  2. Click your profile icon in the top-right corner and select Settings.
  3. Navigate to the API tokens tab.
  4. Click Create token, give it a name (e.g., SquadOS), and set the desired permissions.
  5. Copy the generated token — this is the value to use in the api_key field when connecting in SquadOS.
  1. Go to Tools in the side menu (/admin/tools).
  2. Open the Available tab and search for Baserow.
  3. Click the card to open the details modal and hit Connect.
  4. You’re taken to the secure connection page hosted by Composio, where you enter the API key obtained above.
  5. Once done, you’re sent back to SquadOS with the account connected and the tool available for your agents. (Connection-flow details in Organization Tools.)

BASEROW_CREATE_USER

Tool to create a new Baserow user with the provided details. Use when you need to register a new user account in Baserow. After creating an account, an initial workspace containing a database is automatically created. Optionally generates authentication JWT tokens if the authenticate parameter is set to true.

NameTypeRequiredDescription
namestringYesThe user’s display name.
emailstringYesThe user’s email address (used for login).
languagestringNoAn ISO 639 language code (with optional variant) selected by the user. Ex: en-GB.
passwordstringYesThe user’s password.
template_idintegerNoThe id of the template that must be installed after creating the account. This only works if the workspace_invitation_token param is not provided.
authenticatebooleanNoIndicates whether an authentication JWT should be generated and be included in the response.
workspace_invitation_tokenstringNoIf provided and valid, the user accepts the workspace invitation and will have access to the workspace after signing up.
NameTypeRequiredDescription
datastringYesData from the action execution.
errorstringNoError if any occurred during the execution of the action.
successfulbooleanYesWhether or not the action execution was successful.

BASEROW_DISPATCH_BUILDER_PAGE_DATA_SOURCE

Tool to dispatch the service of a builder page data source and return the result. Use when you need to execute a data source query in Baserow’s builder application.

NameTypeRequiredDescription
metadataobjectNoMetadata payload for the dispatch request.
data_source_idintegerYesThe id of the data_source you want to call the dispatch for.
ClientSessionIdstringNoAn optional header that marks the action performed by this request as having occurred in a particular client session. Then using the undo/redo endpoints with the same ClientSessionId header this action can be undone/redone.
NameTypeRequiredDescription
datastringYesData from the action execution.
errorstringNoError if any occurred during the execution of the action.
successfulbooleanYesWhether or not the action execution was successful.

BASEROW_DISPATCH_PUBLIC_BUILDER_PAGE_DATA_SOURCE

Tool to dispatch the service of a published builder page data source and return the result. Use this when you need to execute a data source in a public/published Baserow builder domain.

NameTypeRequiredDescription
metadataobjectNoMetadata for the data source dispatch.
data_source_idintegerYesThe id of the data_source you want to call the dispatch for.
ClientSessionIdstringNoAn optional header that marks the action performed by this request as having occurred in a particular client session. Then using the undo/redo endpoints with the same ClientSessionId header this action can be undone/redone.
NameTypeRequiredDescription
datastringYesData from the action execution.
errorstringNoError if any occurred during the execution of the action.
successfulbooleanYesWhether or not the action execution was successful.

BASEROW_GET_FORM_VIEW_METADATA

Tool to retrieve metadata for a Baserow form view. Use when you need to get form structure and configuration details for constructing a form with the right fields. The form must be publicly shared or the user must have access to the related workspace.

NameTypeRequiredDescription
slugstringYesThe slug related to the form view. This unique identifier is used to access the form metadata.
NameTypeRequiredDescription
datastringYesData from the action execution.
errorstringNoError if any occurred during the execution of the action.
successfulbooleanYesWhether or not the action execution was successful.

BASEROW_GET_PUBLIC_BUILDER_BY_DOMAIN_NAME

Tool to retrieve the public published version of a builder by its domain name. Use when you need to access a published Baserow builder application and its configuration, including pages, scripts, theme, and user sources.

NameTypeRequiredDescription
domain_namestringYesThe domain name of the published builder to retrieve. Can be a custom domain or Baserow subdomain (e.g., ‘demo.baserow.io’).
NameTypeRequiredDescription
datastringYesData from the action execution.
errorstringNoError if any occurred during the execution of the action.
successfulbooleanYesWhether or not the action execution was successful.

Get Record Names for Builder Page Data Source

Section titled “Get Record Names for Builder Page Data Source”

BASEROW_GET_RECORD_NAMES_BUILDER_PAGE_DATA_SOURCE

Tool to find the record names associated with a given list of record ids. Use when you need to retrieve the display names for specific records from a builder page data source.

NameTypeRequiredDescription
record_idsstringYesA comma separated list of the record ids to search for.
data_source_idintegerYesThe id of the data_source to find the record names.
NameTypeRequiredDescription
datastringYesData from the action execution.
errorstringNoError if any occurred during the execution of the action.
successfulbooleanYesWhether or not the action execution was successful.

BASEROW_GET_SETTINGS

Tool to retrieve all admin configured settings for the Baserow instance. Use when you need to check system-wide configuration like signup policies, email verification settings, or workspace creation permissions.

NameTypeRequiredDescription
datastringYesData from the action execution.
errorstringNoError if any occurred during the execution of the action.
successfulbooleanYesWhether or not the action execution was successful.

BASEROW_LIST_APPLICATION_USER_SOURCES

Tool to list all user sources of an application if the user has access to the related application’s workspace. Use when you need to retrieve user source configurations for a Baserow application. If the workspace is related to a template, this endpoint is publicly accessible.

NameTypeRequiredDescription
application_idintegerYesReturns only the user_sources of the application related to the provided Id.
NameTypeRequiredDescription
datastringYesData from the action execution.
errorstringNoError if any occurred during the execution of the action.
successfulbooleanYesWhether or not the action execution was successful.

BASEROW_LIST_AUTH_PROVIDERS_LOGIN_OPTIONS

Tool to list available login options for configured authentication providers. Use when you need to discover which authentication methods are enabled for the Baserow instance.

NameTypeRequiredDescription
datastringYesData from the action execution.
errorstringNoError if any occurred during the execution of the action.
successfulbooleanYesWhether or not the action execution was successful.

BASEROW_LIST_DATABASES

This tool retrieves a list of all databases in a specified workspace. As a fundamental operation, it allows users to discover which databases are available in their Baserow workspace. This operation is independent and requires only authentication in order to fetch essential metadata for subsequent operations.

NameTypeRequiredDescription
datastringYesData from the action execution.
errorstringNoError if any occurred during the execution of the action.
successfulbooleanYesWhether or not the action execution was successful.

BASEROW_LIST_TABLES

This tool lists all tables within a specified Baserow database. It allows users to retrieve information about all tables in a database, including details such as id, name, order, database_id, type, and first_row_header.

NameTypeRequiredDescription
database_idintegerYesID of the database to list tables from.
NameTypeRequiredDescription
datastringYesData from the action execution.
errorstringNoError if any occurred during the execution of the action.
successfulbooleanYesWhether or not the action execution was successful.

BASEROW_LIST_TEMPLATES

Tool to list all template categories and their related templates. The template’s workspace_id can be used for previewing purposes because that workspace contains publicly accessible applications. Use when you need to discover available templates in Baserow.

NameTypeRequiredDescription
datastringYesData from the action execution.
errorstringNoError if any occurred during the execution of the action.
successfulbooleanYesWhether or not the action execution was successful.

BASEROW_SEND_PASSWORD_RESET_EMAIL

Tool to send a password reset email to a user’s email address. The email contains a password reset link that is valid for 48 hours. The endpoint will not fail if the email address is not found.

NameTypeRequiredDescription
emailstringYesThe email address of the user that has requested a password reset.
base_urlstringYesThe base URL where the user can reset their password. The reset token will be appended to the base_url (base_url ‘/token’).
NameTypeRequiredDescription
datastringYesData from the action execution.
errorstringNoError if any occurred during the execution of the action.
successfulbooleanYesWhether or not the action execution was successful.

BASEROW_SEND_VERIFY_EMAIL

Tool to send a verification email to a user’s email address. Use when you need to trigger email verification for a user account that hasn’t been verified yet.

NameTypeRequiredDescription
emailstringYesThe email address to send the verification email to.
NameTypeRequiredDescription
datastringYesData from the action execution.
errorstringNoError if any occurred during the execution of the action.
successfulbooleanYesWhether or not the action execution was successful.