baserow-cli

A command-line tool for Baserow — the open-source Airtable alternative.

Built for AI agents and automation, but works great for humans too. JSON output to stdout, structured errors to stderr, config via file/env/flags.

Install

uv tool install baserow-cli

Or with pip:

pip install baserow-cli

Quick start

# Set your Baserow database token and instance URL
export BASEROW_TOKEN="your-database-token"
export BASEROW_URL="https://your-baserow-instance.com"

# Or run the interactive setup
baserow config init

Create a database token in Baserow under Settings > Database tokens. Tokens are scoped per-table — you control exactly what the CLI can access.

Usage

# List tables accessible by your token
baserow tables list

# Get table info with field definitions
baserow tables get 42

# List rows (with search, filtering, sorting, pagination)
baserow rows list --table 42
baserow rows list --table 42 --search "quarterly" --size 50
baserow rows list --table 42 --filter "Status__equal=Done" --order-by "-Created"

# Single row operations
baserow rows get 1 --table 42
baserow rows create --table 42 --json '{"Name": "New item", "Status": "Todo"}'
baserow rows update 1 --table 42 --json '{"Status": "Done"}'
baserow rows delete 1 --table 42 --yes

# Batch operations
baserow rows batch-create --table 42 --json '[{"Name": "A"}, {"Name": "B"}]'
baserow rows batch-update --table 42 --json '[{"id": 1, "Status": "Done"}, {"id": 2, "Status": "Done"}]'
baserow rows batch-delete --table 42 --json '[3, 4, 5]' --yes

# Pipe JSON from stdin
cat data.json | baserow rows batch-create --table 42 --json -

Configuration

Config is loaded with priority: config file < env vars < CLI flags.

Config file location: ~/.config/baserow-cli/config.toml

# Manage config
baserow config init          # interactive setup
baserow config show          # print current config (token masked)
baserow config show --reveal # show full token
baserow config set defaults.table 42

Output

All commands output JSON to stdout. Errors go to stderr as structured JSON:

{"error": {"type": "not_found", "message": "...", "status_code": 404}}

Exit codes: 0 success, 1 error, 2 rate limited.

API reference

This CLI wraps the Baserow REST API. Your instance also serves interactive API docs at https://your-instance/api/redoc/.

• Database tokens
• Row endpoints
• Field types
• Filtering syntax

License

MIT