moltsheet
v0.2.3
Published
CLI for reading and updating Moltsheet spreadsheets from the terminal and AI agents
Maintainers
Readme
Moltsheet CLI
moltsheet is a data platform for AI agents delivered through a CLI.
It is designed for agent workflows where you want structured read and write access to data without making the agent handle Postgres directly or deal with Excel spreadsheets.
Install
npm install -g moltsheetOr run it without a global install:
npx moltsheet@latest --helpWhat It Does
- Authenticate once and reuse your API key locally
- List and inspect sheets from the terminal
- Read filtered subsets of sheet data with
sheet get - Add, import, update, and delete rows
- Add, rename, and delete columns
- Update cells in bulk from JSON
- Share sheets with agents using read or write access
Quickstart
Authenticate:
moltsheet auth loginList sheets:
moltsheet sheet list --jsonFetch one sheet:
moltsheet sheet get SHEET_ID --jsonFetch only the columns and rows you need:
moltsheet sheet get SHEET_ID --columns "Name,Status" --filter "Status:eq:active" --jsonAdd empty rows:
moltsheet row add SHEET_ID --count 10 --jsonImport rows from a file:
moltsheet row import SHEET_ID --file rows.json --jsonUpdate cells from JSON:
moltsheet cell update SHEET_ID --file updates.json --jsonAuth
Credential resolution order:
--api-keyMOLTSHEET_API_KEY- Stored local credential
The CLI uses OS credential storage when available, with a local config fallback if secure storage is unavailable.
Common Commands
moltsheet auth login
moltsheet auth status
moltsheet sheet list --json
moltsheet sheet get SHEET_ID --json
moltsheet sheet get SHEET_ID --columns "Company,Qualified" --filter "Qualified:eq:true" --json
moltsheet row list SHEET_ID --json
moltsheet row add SHEET_ID --count 10 --json
moltsheet row import SHEET_ID --file rows.json --json
moltsheet cell update SHEET_ID --file updates.json --json
moltsheet column add SHEET_ID --file columns.json --json
moltsheet share add SHEET_ID --slug analyst.bot --access write --jsonWhy Use It
- Better for automation than clicking through a UI
- Faster for AI agents than manual API wiring
- Easier to script in Bash, PowerShell, CI, and local tooling
- Useful for spreadsheet operations where structured JSON input and output matter
Links
- Website: moltsheet.com
- Issues: GitHub Issues
- Source: GitHub Repository
