catalyst-datastore

Name: catalyst-datastore
Author: catalystbyzoho

70installs6forks

How to install catalyst-datastore?

catalystbyzoho/agent-skills/catalyst-datastore

$npx -y skills add catalystbyzoho/agent-skills --skill catalyst-datastore

Installs into the current project.

Summary

Catalyst Data Store — relational cloud database with ZCQL, CRUD operations, table permissions, and result pagination. Requires MCP connection — check for CatalystbyZoho_* tools before any operation. Trigger on 'Data Store', 'ZCQL', 'create table', 'executeZCQLQuery', 'table permi

Files · 1

View on GitHub

SKILL.md

1	## ⚠️ PREREQUISITES — READ THIS FIRST
2
3	Before ANY Data Store operation, you MUST verify MCP connectivity.
4
5	- Search for `CatalystbyZoho_*` tools in your available tool list.
6	- 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.
7	- If found: Run `CatalystbyZoho_List_All_Organizations` → `CatalystbyZoho_List_All_Projects` to set project context, then continue to "How It Works".
8
9	### Execution Checklist (MUST follow in order)
10
11	- [ ] Step 0: Confirm `CatalystbyZoho_*` tools visible → if none found → STOP, set up MCP first
12	- [ ] Step 1: Run `CatalystbyZoho_List_All_Organizations`
13	- [ ] Step 2: Run `CatalystbyZoho_List_All_Projects`
14	- [ ] Step 3: For table creation → `CatalystbyZoho_Create_Table` \| For existing tables → `CatalystbyZoho_List_All_Tables`
15	- [ ] Step 4: Proceed with the operation
16
17	---
18
19	## How It Works
20
21	1. 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.
22	2. Load `references/datastore-basics.md` — for CRUD operations, ZCQL syntax, result unwrapping, and permissions setup.
23	3. Unwrap ZCQL results — Always remind: `rows.map(r => r.TableName)`. Raw ZCQL results are wrapped; accessing without unwrapping is the #1 Data Store bug.
24	4. Permissions — App User permissions are OFF by default. If the query involves a logged-in user reading data, check Console → Table → Scopes & Permissions.
25	5. Pagination — ZCQL max 300 rows per query. Use `LIMIT offset, count` for larger datasets.
26
27	## Security Checklist
28
29	- 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.
30	- 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.
31
32	## Triggers
33
34	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".
35
36	## References
37
38	\| Reference \| Load when the query is about… \|
39	\|-----------\|-------------------------------\|
40	\| `references/datastore-basics.md` \| CRUD, ZCQL queries, result unwrapping, pagination, column types, App User permissions setup, CREATEDTIME timezone gotcha, emoji limitation \|

People who liked this also viewed

6 picks

Type

catalyst-datastore

70installs6forks

View on GitHub

How to install catalyst-datastore?

catalystbyzoho/agent-skills/catalyst-datastore

$npx -y skills add catalystbyzoho/agent-skills --skill catalyst-datastore

Installs into the current project.

Summary

Files · 1

View on GitHub

SKILL.md

1	## ⚠️ PREREQUISITES — READ THIS FIRST
2
3	Before ANY Data Store operation, you MUST verify MCP connectivity.
4
5	- Search for `CatalystbyZoho_*` tools in your available tool list.
6	- 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.
7	- If found: Run `CatalystbyZoho_List_All_Organizations` → `CatalystbyZoho_List_All_Projects` to set project context, then continue to "How It Works".
8
9	### Execution Checklist (MUST follow in order)
10
11	- [ ] Step 0: Confirm `CatalystbyZoho_*` tools visible → if none found → STOP, set up MCP first
12	- [ ] Step 1: Run `CatalystbyZoho_List_All_Organizations`
13	- [ ] Step 2: Run `CatalystbyZoho_List_All_Projects`
14	- [ ] Step 3: For table creation → `CatalystbyZoho_Create_Table` \| For existing tables → `CatalystbyZoho_List_All_Tables`
15	- [ ] Step 4: Proceed with the operation
16
17	---
18
19	## How It Works
20
21	1. 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.
22	2. Load `references/datastore-basics.md` — for CRUD operations, ZCQL syntax, result unwrapping, and permissions setup.
23	3. Unwrap ZCQL results — Always remind: `rows.map(r => r.TableName)`. Raw ZCQL results are wrapped; accessing without unwrapping is the #1 Data Store bug.
24	4. Permissions — App User permissions are OFF by default. If the query involves a logged-in user reading data, check Console → Table → Scopes & Permissions.
25	5. Pagination — ZCQL max 300 rows per query. Use `LIMIT offset, count` for larger datasets.
26
27	## Security Checklist
28
29	- 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.
30	- 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.
31
32	## Triggers
33
34	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".
35
36	## References
37
38	\| Reference \| Load when the query is about… \|
39	\|-----------\|-------------------------------\|
40	\| `references/datastore-basics.md` \| CRUD, ZCQL queries, result unwrapping, pagination, column types, App User permissions setup, CREATEDTIME timezone gotcha, emoji limitation \|

People who liked this also viewed

6 picks

Type