catalyst-datastore

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

⚠️ PREREQUISITES — READ THIS FIRST

⚠️ 先决条件 — 请先阅读此部分

Before ANY Data Store operation, you MUST verify MCP connectivity.

Search for
```
CatalystbyZoho_*
```
tools in your available tool list.
If NOT found: STOP. Do NOT write any code, scaffold files, or instruct Console steps. Load
```
catalyst-zoho-mcp
```
skill and guide the user through MCP setup. Do NOT proceed until the user confirms
```
CatalystbyZoho_*
```
tools are visible.
If found: Run
```
CatalystbyZoho_List_All_Organizations
```
→
```
CatalystbyZoho_List_All_Projects
```
to set project context, then continue to "How It Works".

在执行任何Data Store操作之前，必须验证MCP连接状态。

在可用工具列表中搜索
```
CatalystbyZoho_*
```
工具。
若未找到： 停止操作。请勿编写代码、生成脚手架文件或指导控制台操作步骤。加载
```
catalyst-zoho-mcp
```
技能并引导用户完成MCP设置。在用户确认
```
CatalystbyZoho_*
```
工具可见之前，请勿继续。
若找到： 运行
```
CatalystbyZoho_List_All_Organizations
```
→
```
CatalystbyZoho_List_All_Projects
```
来设置项目上下文，然后继续阅读“工作原理”部分。

Execution Checklist (MUST follow in order)

执行检查清单（必须按顺序执行）

Step 0: Confirm
```
CatalystbyZoho_*
```
tools visible → if none found → STOP, set up MCP first
Step 1: Run
```
CatalystbyZoho_List_All_Organizations
```
Step 2: Run
```
CatalystbyZoho_List_All_Projects
```

Step 3: For table creation →

CatalystbyZoho_Create_Table

| For existing tables →

CatalystbyZoho_List_All_Tables

Step 4: Proceed with the operation

步骤0：确认
```
CatalystbyZoho_*
```
工具可见 → 若未找到 → 停止操作，先设置MCP
步骤1：运行
```
CatalystbyZoho_List_All_Organizations
```
步骤2：运行
```
CatalystbyZoho_List_All_Projects
```
步骤3：创建表 → 使用
```
CatalystbyZoho_Create_Table
```
| 操作已有表 → 使用
```
CatalystbyZoho_List_All_Tables
```
步骤4：继续执行操作

How It Works

工作原理

Create or locate the table via MCP — Creating a table? Use
```
CatalystbyZoho_Create_Table
```
directly. Do NOT instruct the user to open the Catalyst Console or create the table manually. Reading/writing data? Use
```
CatalystbyZoho_List_All_Tables
```
to get table IDs. Never ask the user to copy table IDs.
Load
references/datastore-basics.md
— for CRUD operations, ZCQL syntax, result unwrapping, and permissions setup.
Unwrap ZCQL results — Always remind:
```
rows.map(r => r.TableName)
```
. Raw ZCQL results are wrapped; accessing without unwrapping is the #1 Data Store bug.
Permissions — App User permissions are OFF by default. If the query involves a logged-in user reading data, check Console → Table → Scopes & Permissions.
Pagination — ZCQL max 300 rows per query. Use
```
LIMIT offset, count
```
for larger datasets.

通过MCP创建或定位表 — 创建表？直接使用
```
CatalystbyZoho_Create_Table
```
。请勿指导用户打开Catalyst控制台或手动创建表。读写数据？使用
```
CatalystbyZoho_List_All_Tables
```
获取表ID。切勿要求用户手动复制表ID。
加载
references/datastore-basics.md
— 用于CRUD操作、ZCQL语法、结果解包及权限设置。
解包ZCQL结果 — 务必提醒：
```
rows.map(r => r.TableName)
```
。原始ZCQL结果是被包装的，不解包直接访问是Data Store最常见的bug。
权限 — App User权限默认关闭。如果查询涉及已登录用户读取数据，请检查控制台 → 表 → 作用域与权限。
分页 — ZCQL每次查询最多返回300行数据。对于更大的数据集，使用
```
LIMIT offset, count
```
语法。

Security Checklist

安全检查清单

App User write permissions are off by default. The App User role has SELECT enabled by default, but INSERT, UPDATE, and DELETE must be manually enabled per table. Go to Console → Table → Scopes and Permissions → App User role → check Insert/Update/Delete for any table your authenticated users need to write.
App Administrator has all permissions by default. Never assign the App Administrator role to regular end-users — it grants full read/write/delete access to all tables.

App User的写入权限默认关闭。 App User角色默认启用SELECT权限，但INSERT、UPDATE和DELETE权限必须针对每张表手动开启。前往控制台 → 表 → 作用域与权限 → App User角色 → 为需要让已认证用户写入的表勾选插入/更新/删除权限。
App Administrator默认拥有所有权限。 切勿将App Administrator角色分配给普通终端用户——该角色拥有对所有表的完全读写删除权限。

Triggers

触发场景

Use this skill for: "Data Store", "ZCQL", "catalyst table", "create table", "query data",

executeZCQLQuery

, "table permissions", "App User permissions", "ROWID", "CREATEDTIME", "Data Store CRUD", "JOIN in ZCQL", "pagination ZCQL", "data store column types", "insert row", "update row", "delete row", or "relational data on Catalyst".

当涉及以下场景时使用此技能："Data Store"、"ZCQL"、"catalyst表"、"创建表"、"查询数据"、

executeZCQLQuery

、"表权限"、"App User权限"、"ROWID"、"CREATEDTIME"、"Data Store CRUD"、"ZCQL中的JOIN"、"ZCQL分页"、"data store列类型"、"插入行"、"更新行"、"删除行"或"Catalyst上的关系型数据"。

References

参考资料

Reference	Load when the query is about…
`references/datastore-basics.md`	CRUD, ZCQL queries, result unwrapping, pagination, column types, App User permissions setup, CREATEDTIME timezone gotcha, emoji limitation

参考资料	当查询涉及以下内容时加载…
`references/datastore-basics.md`	CRUD操作、ZCQL查询、结果解包、分页、列类型、App User权限设置、CREATEDTIME时区陷阱、表情符号限制