Baserow
Overview
Section titled “Overview”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.
- Official website: https://baserow.io/
- Composio documentation: docs.composio.dev/toolkits/baserow
Authentication
Section titled “Authentication”This tool uses an API key (API_KEY) to connect.
You will need the following fields:
| Field | Required | Description |
|---|---|---|
api_key | Yes | API key from your Baserow account, used to authenticate all requests to the instance. |
How to get credentials
Section titled “How to get credentials”- Go to baserow.io and log in to your account (or self-hosted instance).
- Click your profile icon in the top-right corner and select Settings.
- Navigate to the API tokens tab.
- Click Create token, give it a name (e.g.,
SquadOS), and set the desired permissions. - Copy the generated token — this is the value to use in the
api_keyfield when connecting in SquadOS.
How to connect in SquadOS
Section titled “How to connect in SquadOS”- Go to Tools in the side menu (
/admin/tools). - Open the Available tab and search for
Baserow. - Click the card to open the details modal and hit Connect.
- You’re taken to the secure connection page hosted by Composio, where you enter the API key obtained above.
- 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.)
Available actions
Section titled “Available actions”Create User
Section titled “Create User”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.
Input parameters
Section titled “Input parameters”| Name | Type | Required | Description |
|---|---|---|---|
name | string | Yes | The user’s display name. |
email | string | Yes | The user’s email address (used for login). |
language | string | No | An ISO 639 language code (with optional variant) selected by the user. Ex: en-GB. |
password | string | Yes | The user’s password. |
template_id | integer | No | The id of the template that must be installed after creating the account. This only works if the workspace_invitation_token param is not provided. |
authenticate | boolean | No | Indicates whether an authentication JWT should be generated and be included in the response. |
workspace_invitation_token | string | No | If provided and valid, the user accepts the workspace invitation and will have access to the workspace after signing up. |
Output
Section titled “Output”| Name | Type | Required | Description |
|---|---|---|---|
data | string | Yes | Data from the action execution. |
error | string | No | Error if any occurred during the execution of the action. |
successful | boolean | Yes | Whether or not the action execution was successful. |
Dispatch Builder Page Data Source
Section titled “Dispatch Builder Page Data Source”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.
Input parameters
Section titled “Input parameters”| Name | Type | Required | Description |
|---|---|---|---|
metadata | object | No | Metadata payload for the dispatch request. |
data_source_id | integer | Yes | The id of the data_source you want to call the dispatch for. |
ClientSessionId | string | No | An 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. |
Output
Section titled “Output”| Name | Type | Required | Description |
|---|---|---|---|
data | string | Yes | Data from the action execution. |
error | string | No | Error if any occurred during the execution of the action. |
successful | boolean | Yes | Whether or not the action execution was successful. |
Dispatch Public Builder Page Data Source
Section titled “Dispatch Public Builder Page Data Source”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.
Input parameters
Section titled “Input parameters”| Name | Type | Required | Description |
|---|---|---|---|
metadata | object | No | Metadata for the data source dispatch. |
data_source_id | integer | Yes | The id of the data_source you want to call the dispatch for. |
ClientSessionId | string | No | An 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. |
Output
Section titled “Output”| Name | Type | Required | Description |
|---|---|---|---|
data | string | Yes | Data from the action execution. |
error | string | No | Error if any occurred during the execution of the action. |
successful | boolean | Yes | Whether or not the action execution was successful. |
Get Form View Metadata
Section titled “Get Form View Metadata”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.
Input parameters
Section titled “Input parameters”| Name | Type | Required | Description |
|---|---|---|---|
slug | string | Yes | The slug related to the form view. This unique identifier is used to access the form metadata. |
Output
Section titled “Output”| Name | Type | Required | Description |
|---|---|---|---|
data | string | Yes | Data from the action execution. |
error | string | No | Error if any occurred during the execution of the action. |
successful | boolean | Yes | Whether or not the action execution was successful. |
Get Public Builder by Domain Name
Section titled “Get Public Builder by Domain Name”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.
Input parameters
Section titled “Input parameters”| Name | Type | Required | Description |
|---|---|---|---|
domain_name | string | Yes | The domain name of the published builder to retrieve. Can be a custom domain or Baserow subdomain (e.g., ‘demo.baserow.io’). |
Output
Section titled “Output”| Name | Type | Required | Description |
|---|---|---|---|
data | string | Yes | Data from the action execution. |
error | string | No | Error if any occurred during the execution of the action. |
successful | boolean | Yes | Whether 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.
Input parameters
Section titled “Input parameters”| Name | Type | Required | Description |
|---|---|---|---|
record_ids | string | Yes | A comma separated list of the record ids to search for. |
data_source_id | integer | Yes | The id of the data_source to find the record names. |
Output
Section titled “Output”| Name | Type | Required | Description |
|---|---|---|---|
data | string | Yes | Data from the action execution. |
error | string | No | Error if any occurred during the execution of the action. |
successful | boolean | Yes | Whether or not the action execution was successful. |
Get Settings
Section titled “Get Settings”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.
Output
Section titled “Output”| Name | Type | Required | Description |
|---|---|---|---|
data | string | Yes | Data from the action execution. |
error | string | No | Error if any occurred during the execution of the action. |
successful | boolean | Yes | Whether or not the action execution was successful. |
List Application User Sources
Section titled “List Application User Sources”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.
Input parameters
Section titled “Input parameters”| Name | Type | Required | Description |
|---|---|---|---|
application_id | integer | Yes | Returns only the user_sources of the application related to the provided Id. |
Output
Section titled “Output”| Name | Type | Required | Description |
|---|---|---|---|
data | string | Yes | Data from the action execution. |
error | string | No | Error if any occurred during the execution of the action. |
successful | boolean | Yes | Whether or not the action execution was successful. |
List Auth Providers Login Options
Section titled “List Auth Providers Login Options”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.
Output
Section titled “Output”| Name | Type | Required | Description |
|---|---|---|---|
data | string | Yes | Data from the action execution. |
error | string | No | Error if any occurred during the execution of the action. |
successful | boolean | Yes | Whether or not the action execution was successful. |
List Databases
Section titled “List Databases”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.
Output
Section titled “Output”| Name | Type | Required | Description |
|---|---|---|---|
data | string | Yes | Data from the action execution. |
error | string | No | Error if any occurred during the execution of the action. |
successful | boolean | Yes | Whether or not the action execution was successful. |
List Tables in Database
Section titled “List Tables in Database”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.
Input parameters
Section titled “Input parameters”| Name | Type | Required | Description |
|---|---|---|---|
database_id | integer | Yes | ID of the database to list tables from. |
Output
Section titled “Output”| Name | Type | Required | Description |
|---|---|---|---|
data | string | Yes | Data from the action execution. |
error | string | No | Error if any occurred during the execution of the action. |
successful | boolean | Yes | Whether or not the action execution was successful. |
List Templates
Section titled “List Templates”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.
Output
Section titled “Output”| Name | Type | Required | Description |
|---|---|---|---|
data | string | Yes | Data from the action execution. |
error | string | No | Error if any occurred during the execution of the action. |
successful | boolean | Yes | Whether or not the action execution was successful. |
Send Password Reset Email
Section titled “Send Password Reset Email”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.
Input parameters
Section titled “Input parameters”| Name | Type | Required | Description |
|---|---|---|---|
email | string | Yes | The email address of the user that has requested a password reset. |
base_url | string | Yes | The base URL where the user can reset their password. The reset token will be appended to the base_url (base_url ‘/token’). |
Output
Section titled “Output”| Name | Type | Required | Description |
|---|---|---|---|
data | string | Yes | Data from the action execution. |
error | string | No | Error if any occurred during the execution of the action. |
successful | boolean | Yes | Whether or not the action execution was successful. |
Send Verification Email
Section titled “Send Verification Email”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.
Input parameters
Section titled “Input parameters”| Name | Type | Required | Description |
|---|---|---|---|
email | string | Yes | The email address to send the verification email to. |
Output
Section titled “Output”| Name | Type | Required | Description |
|---|---|---|---|
data | string | Yes | Data from the action execution. |
error | string | No | Error if any occurred during the execution of the action. |
successful | boolean | Yes | Whether or not the action execution was successful. |