Baserow | Composio Docs

Overview

SLUG: BASEROW

Description

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

Authentication Details

Bearer Token

token

stringRequired

Connecting to Baserow

Create an auth config

Use the dashboard to create an auth config for the Baserow toolkit. This allows you to connect multiple Baserow accounts to Composio for agents to use.

Select App

Navigate to the Baserow toolkit page and click “Setup Integration”.

Configure Auth Config Settings

Select among the supported auth schemes of and configure them here.

Create and Get auth config ID

Click “Create Integration”. After creation, copy the displayed ID starting with ac_. This is your auth config ID. This is not a sensitive ID — you can save it in environment variables or a database. This ID will be used to create connections to the toolkit for a given user.

Connect Your Account

Using Bearer Token

1 from composio import Composio
2 from composio.types import auth_scheme
3 
4 # Auth config ID created above
5 baserow_auth_config_id = "ac_YOUR_BASEROW_CONFIG_ID" 
6 
7 # UUID from database/application
8 user_id = "0000-0000-0000"
9 
10 composio = Composio()
11 
12 
13 def authenticate_toolkit(user_id: str, auth_config_id: str):
14     # Replace this with a method to retrieve the Bearer Token from the user.
15     bearer_token = input("[!] Enter bearer token")
16     connection_request = composio.connected_accounts.initiate(
17         user_id=user_id,
18         auth_config_id=auth_config_id,
19         config={"auth_scheme": "BEARER_TOKEN", "val": bearer_token}
20     )
21     print(f"Successfully connected Baserow for user {user_id}")
22     print(f"Connection status: {connection_request.status}")
23     
24     return connection_request.id
25 
26 
27 connection_id = authenticate_toolkit(user_id, baserow_auth_config_id)
28 
29 # You can verify the connection using:
30 connected_account = composio.connected_accounts.get(connection_id)
31 print(f"Connected account: {connected_account}")

Tools

Executing tools

To prototype you can execute some tools to see the responses and working on the Baserow toolkit’s playground

OpenAI (Python)

Anthropic (TypeScript)

Google (Python)

Vercel (TypeScript)

Python

1 from composio import Composio
2 from openai import OpenAI
3 import json
4 
5 openai = OpenAI()
6 composio = Composio()
7 
8 # User ID must be a valid UUID format
9 user_id = "0000-0000-0000"  # Replace with actual user UUID from your database
10 
11 tools = composio.tools.get(user_id=user_id, toolkits=["BASEROW"])
12 
13 print("[!] Tools:")
14 print(json.dumps(tools))
15 
16 def invoke_llm(task = "What can you do?"):
17     completion = openai.chat.completions.create(
18         model="gpt-4o",
19         messages=[
20             {
21                 "role": "user",
22                 "content": task,  # Your task here!
23             },
24         ],
25         tools=tools,
26     )
27 
28     # Handle Result from tool call
29     result = composio.provider.handle_tool_calls(user_id=user_id, response=completion)
30     print(f"[!] Completion: {completion}")
31     print(f"[!] Tool call result: {result}")
32 
33 invoke_llm()

Tool List

BASEROW_LIST_DATABASES

Tool Name: List Databases

Description

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.

Action Parameters

Action Response

data

objectRequired

error

string

successful

booleanRequired

BASEROW_LIST_TABLES

Tool Name: List Tables in Database