# Seatable

> SeaTable — manage rows, tables, and bases in SeaTable collaborative databases. Supports CRUD, filtering, linking, file attachments, and view management via `robomotion seatable`. Do NOT use for Airtable, Baserow, NocoDB, or other no-code databases.

- Skill: `robomotionio/seatable` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add robomotionio/seatable`
- Raw SKILL.md: https://api.skillmd.com/api/skills/robomotionio/seatable/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- License: Apache-2.0
- Author: robomotionio (https://skillmd.com/u/robomotionio)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/robomotionio/seatable

---

# SeaTable

The `robomotion seatable` CLI connects to SeaTable for collaborative database management. It manages rows (CRUD with filtering and sorting), tables, bases, links between records, file attachments, and views.

## When to use
- List, create, update, or delete rows in SeaTable tables
- Search and filter rows with SQL-like conditions
- Manage links between records and file attachments
- List tables, views, and manage base schemas

## Prerequisites
- `robomotion` CLI installed
- Package installed: `robomotion install seatable`
- SeaTable API token configured via Robomotion vault

## IMPORTANT: Session Mode Required for Multi-Step Operations
Each CLI command runs as a **separate process** — connection IDs from `connect` do NOT persist across calls.
You MUST use `--session` on `connect` and pass `--session-id` to all subsequent commands.

## Workflow
1. Install (once): `robomotion install seatable`
2. Connect with session:
   ```
   robomotion seatable seatable_connect --session --output json
   # → {"outClientId":"<client-id>","session_id":"<session-id>"}
   ```
3. Use the returned `client-id` and `session-id` in all subsequent commands:
   ```
   robomotion seatable seatable_list_rows --client-id "<client-id>" --table-name <table> --session-id "<session-id>" --output json
   ```
4. Disconnect when done:
   ```
   robomotion seatable seatable_disconnect --client-id "<client-id>" --session-id "<session-id>" --output json
   ```

**Always** append `--output json` to get structured JSON results.

## Commands Reference
- `robomotion seatable seatable_connect --session --output json`
  Connects to SeaTable and returns a client ID for subsequent operations
- `robomotion seatable seatable_disconnect --client-id --session-id "<session-id>" --output json`
  Closes the SeaTable connection and releases resources
- `robomotion seatable seatable_create_row --client-id --table-name --row-data --session-id "<session-id>" --output json`
  Creates a new row in a SeaTable table
- `robomotion seatable seatable_get_row --client-id --table-name --row-id --session-id "<session-id>" --output json`
  Retrieves a single row from a SeaTable table by its ID
- `robomotion seatable seatable_list_rows --client-id --table-name [--view-name] [--0] [--100] --session-id "<session-id>" --output json`
  Retrieves multiple rows from a SeaTable table
- `robomotion seatable seatable_update_row --client-id --table-name --row-id --row-data --session-id "<session-id>" --output json`
  Updates an existing row in a SeaTable table
- `robomotion seatable seatable_delete_row --client-id --table-name --row-id --session-id "<session-id>" --output json`
  Deletes a row from a SeaTable table
- `robomotion seatable seatable_lock_row --client-id --table-name --row-id --session-id "<session-id>" --output json`
  Locks a row in a SeaTable table to prevent changes
- `robomotion seatable seatable_unlock_row --client-id --table-name --row-id --session-id "<session-id>" --output json`
  Unlocks a row in a SeaTable table
- `robomotion seatable seatable_search_rows --client-id --table-name --search-query [--100] --session-id "<session-id>" --output json`
  Searches for rows containing a keyword in a SeaTable table
- `robomotion seatable seatable_sql_query --client-id --sql-query --session-id "<session-id>" --output json`
  Executes a SQL query on a SeaTable base
- `robomotion seatable seatable_create_link --client-id --link-id --table-name --other-table-name --row-id --other-row-id --session-id "<session-id>" --output json`
  Creates a link between two rows in different tables
- `robomotion seatable seatable_delete_link --client-id --link-id --table-name --other-table-name --row-id --other-row-id --session-id "<session-id>" --output json`
  Removes a link between two rows in different tables
- `robomotion seatable seatable_upload_file --client-id --file-path --session-id "<session-id>" --output json`
  Uploads a file to SeaTable storage
- `robomotion seatable seatable_get_asset_url --client-id --asset-path --session-id "<session-id>" --output json`
  Gets a download URL for a file/image asset stored in SeaTable
- `robomotion seatable seatable_get_metadata --client-id --session-id "<session-id>" --output json`
  Retrieves the metadata (structure) of a SeaTable base including tables، columns، and links
- `robomotion seatable seatable_api_call --client-id --endpoint [--http-method] [--request-body] [--headers] --session-id "<session-id>" --output json`
  Makes a custom API call to SeaTable for advanced operations

## Environment
- ROBOMOTION_API_TOKEN (if vault credentials are needed)