AGENT SKILL

pm-coda

Coda connector knowledge and safe action guide.

License 许可
AGPL-3.0
所属仓库
polymetrics-ai/cli
最近更新
2026-09-21
Stars
★ 7
Forks
0

01 前言 Front Matter

name
pm-coda
description
Coda connector knowledge and safe action guide.

03 SKILL.md 正文

pm-coda

Purpose

Reads Coda docs and doc-scoped tables, rows, columns, pages, formulas, and controls, and writes rows/pages, through the Coda REST API v1.

Icon

Capabilities

  • check=true catalog=true read=true write=true query=false
  • Integration type: api

Authentication

  • Use pm credentials add with --from-env or --value-stdin for secret fields.

Configuration

  • base_url
  • doc_id
  • mode
  • page_size
  • auth_token (secret) (required)

ETL Streams

  • docs:
    • primary key: id
    • fields: browserLink(string), createdAt(string), folderId(string), href(string), id(string), name(string), owner(string), ownerName(string), type(string), updatedAt(string), workspaceId(string)
  • tables:
    • primary key: id
    • fields: browserLink(string), doc_id(string), href(string), id(string), name(string), rowCount(integer), tableType(string), type(string)
  • pages:
    • primary key: id
    • fields: browserLink(string), contentType(string), doc_id(string), href(string), id(string), name(string), subtitle(string), type(string)
  • formulas:
    • primary key: id
    • fields: doc_id(string), href(string), id(string), name(string), type(string)
  • controls:
    • primary key: id
    • fields: controlType(string), doc_id(string), href(string), id(string), name(string), type(string)
  • columns:
    • primary key: id
    • fields: calculated(boolean), defaultValue(string), display(boolean), doc_id(string), format(object), formula(string), href(string), id(string), name(string), table_id(string), type(string)
  • rows:
    • primary key: id
    • fields: browserLink(string), createdAt(string), doc_id(string), href(string), id(string), index(integer), name(string), table_id(string), type(string), updatedAt(string), values(object)

Sync Modes

  • ETL sync modes: full_refresh_append, full_refresh_overwrite

Reverse ETL Actions

  • upsert_rows:
    • endpoint: POST /docs/{{ config.doc_id }}/tables/{{ record.table_id }}/rows
    • required fields: table_id, rows
    • optional fields: keyColumns
    • risk: inserts new rows, or upserts existing ones when keyColumns is set, into a Coda table; queued for async processing (202) and generally applied within seconds
  • update_row:
    • endpoint: PUT /docs/{{ config.doc_id }}/tables/{{ record.table_id }}/rows/{{ record.row_id }}
    • required fields: table_id, row_id, row
    • risk: overwrites cell values on an existing row; queued for async processing (202) and generally applied within seconds
  • delete_row:
    • endpoint: DELETE /docs/{{ config.doc_id }}/tables/{{ record.table_id }}/rows/{{ record.row_id }}
    • required fields: table_id, row_id
    • risk: permanently removes a row from a Coda table; irreversible, queued for async processing (202)
  • delete_rows:
    • endpoint: DELETE /docs/{{ config.doc_id }}/tables/{{ record.table_id }}/rows
    • required fields: table_id, rowIds
    • risk: permanently removes multiple rows from a Coda table in one request; irreversible, queued for async processing (202)
  • push_button:
    • endpoint: POST /docs/{{ config.doc_id }}/tables/{{ record.table_id }}/rows/{{ record.row_id }}/buttons/{{ record.column_id }}
    • required fields: table_id, row_id, column_id
    • risk: pushes a button on a row; the underlying button can perform ANY action the doc's formulas define, including writes to other tables and Pack actions outside this connector's declared surface — high blast-radius, approval required
  • create_page:
    • endpoint: POST /docs/{{ config.doc_id }}/pages
    • risk: creates a new page in the configured doc; requires Doc Maker access in the workspace, queued for async processing (202)
  • update_page:
    • endpoint: PUT /docs/{{ config.doc_id }}/pages/{{ record.page_id }}
    • required fields: page_id
    • risk: renames, hides, or restyles an existing page; renaming/re-iconing requires Doc Maker access in the workspace, queued for async processing (202)
  • delete_page:
    • endpoint: DELETE /docs/{{ config.doc_id }}/pages/{{ record.page_id }}
    • required fields: page_id
    • risk: permanently removes a page (and its subpages/content) from the doc; irreversible, queued for async processing (202)

Security

  • read risk: external Coda API read of docs and doc-scoped tables, rows, columns, pages, formulas, and controls
  • write risk: external mutation of Coda table rows and doc pages (insert/upsert/update/delete rows, push a row button, create/update/delete a page); push_button and delete actions are approval-gated per writes.json risk text
  • approval: row/page create+update: none; delete_row/delete_rows/delete_page: approval required (irreversible); push_button: approval required (arbitrary doc-defined side effects)
  • Never pass secret values in chat, shell arguments, logs, docs, or JSON output.

Commands

Inspect as a manual

pm connectors inspect coda

Inspect as structured JSON

pm connectors inspect coda --json

Agent Rules

  • Run pm connectors inspect coda before creating credentials or plans.
  • Use --json only when the caller needs structured output; use the manual for human-readable guidance.
  • Never ask the user to paste secret values into chat.
  • For reverse ETL writes, create a plan, show the preview, wait for explicit approval, then run with the approval token.

04 同仓库更多 Skills