Database rows

Set a row's properties from the terminal

Create databases and their properties in the app; see databases. From the CLI you can read rows and set their properties. Each row is a page directly under the database page, so zyler ls and zyler cat work on rows like on any other note.

Read a row

zyler cat prints a row's properties as frontmatter at the top, followed by its body.

zyler ls "Launch plan"          # the rows of a database page
zyler cat "Fix the login bug"   # one row, with its properties

Set properties

Write each property as its own argument. After = comes the value as zyler cat prints it: text, a number, a date such as 2026-11-20 (or 2026-11-20/2026-11-22 for a range), or one option of a select or status.

zyler set "Fix the login bug" Status=Done Due=2026-11-20

After := comes JSON, for lists, numbers, true or false, and clearing a value:

zyler set "Fix the login bug" Tags:='["Sync","Desktop"]' Shipped:=true Notes:=null

JSON typed this way works in shells such as bash and zsh. PowerShell and cmd.exe can split it apart; on Windows, run these from Git Bash or WSL, or from a program that passes each argument directly (see calling it from a program).

  • Only the properties you name change; the title and body stay as they are.
  • Everything is written or nothing is. An unknown property or option is refused with the list of valid ones.
  • A select option that does not exist is added only if the database allows new options. Status options are never added from the CLI.
  • Title, Created time, and Last edited time cannot be set. Rename a row with zyler rename.

Edit this guide on GitHub