Baserow CLI for Openclaw

A powerful command-line interface for managing Baserow databases, enabling seamless row manipulation and table discovery through JSON-based workflows.

jzakirov
v0.1.0
Mar 6, 2026
0
754
0

Install & Download

1. ClawHub CLI

The fastest way to install a skill directly from the registry.

npx clawhub@latest install baserow-cli

2. Manual Installation

Copy the skill folder to one of these locations

Global
~/.openclaw/skills/
Workspace
<project>/skills/

Priority: Workspace > Local > Bundled

3. Prompt Installation

Copy this prompt to OpenClaw to install it automatically.

Help me install baserow-cli using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).

Prefer to download?

Get the raw skill files in a ZIP archive.

What is Baserow CLI?

Baserow CLI is a professional-grade tool designed for interacting with Baserow, the leading open-source alternative to Airtable. As a core component of Openclaw Skills, it provides a structured way for developers and AI agents to manage relational data directly from the terminal. The tool is built to handle complex database workflows, including querying specific data points, updating multiple records simultaneously, and inspecting table architectures.

By prioritizing JSON output, this skill integrates perfectly with modern developer stacks, allowing for easy piping into utilities like jq or custom automation scripts. It bridges the gap between manual data entry and automated data processing, making it an essential asset for anyone building data-driven applications or autonomous agent routines.

Baserow CLI Use Cases

  • Automating recurring data entry tasks into Baserow tables via scripts or AI agents.
  • Performing bulk updates or deletions across large datasets using batch operations.
  • Querying database records with advanced filters and search parameters from the command line.
  • Synchronizing local JSON data files with remote Baserow instances for real-time data consistency.

How Baserow CLI Works

  1. The user authenticates the CLI by providing a Baserow API token and the instance URL through environment variables or a configuration file.
  2. Command discovery is performed using the help flag to identify specific table and field IDs required for data operations.
  3. Row operations are executed using CRUD commands, where data is passed and received in structured JSON format.
  4. For large-scale changes, the CLI processes batch commands, reading from local JSON strings or stdin pipes.
  5. Success or failure is communicated via standard exit codes and JSON-formatted error messages for automated handling.

Baserow CLI Setup

Install the CLI using your preferred Python package manager:

uv tool install baserow-cli   # or: pip install baserow-cli
baserow config init            # starts the interactive setup wizard

Ensure you set the following environment variables in your shell profile or environment file:

  • BASEROW_TOKEN: Your personal access token.
  • BASEROW_URL: The base URL of your Baserow instance.
  • BASEROW_TABLE: (Optional) The default table ID for row operations.

Baserow CLI Data Schema & Taxonomy

The skill manages data across three primary layers, ensuring a clear taxonomy for Openclaw Skills users:

Level Description Key Identifiers
Tables The primary containers for data sets. Table ID
Fields Defined columns within a table representing data types. Field Name
Rows Individual records containing specific field values. Row ID

All input and output data defaults to JSON format, where field keys correspond to the actual field names defined in the Baserow UI, rather than internal IDs.

Baserow CLI Advanced Features

  • Support for piping JSON data directly from stdin using the --json - flag.
  • Safety-first execution with the --yes requirement for destructive delete operations in non-TTY environments.
  • Granular data control using --filter and --order-by for complex row retrieval.
  • Efficient pagination handling with configurable page sizes up to 200 records.
  • Comprehensive configuration management via ~/.config/baserow-cli/config.toml or CLI flags.

SKILL.md


Loading

Related Openclaw Skills

METADATA

Github Stars: 0
forks: 0

Featured*