Use when building, debugging, or evaluating CloudBase PostgreSQL / CloudBase PG / PG mode apps, including Postgres schema setup, queryPgDatabase/managePgDatabase, JS SDK v3 app.rdb() CRUD/RPC, PG HTTP API fallback, RLS-style permissions, username-password auth, and Web CMS/admin CRUD flows backed by CloudBase PG.
SkillScore95Maintained
Automatic
◆Coding pack
Last verified 8/9/2026
What it changes
Passed 21 of 22 test cases with the skill, and 4 of 22 without it.
Without skill18%
With skill95%
Checks it passed that the model alone missed
Rejects using the getTempFileURL method
Directs the use of the manageMysqlDatabase tool
Rejects using the getUser method for route guarding
and 24 more in the full report
17 fixed4 passed either way1 still failing0 broke
Pass-rate lift
+77 pp
Tokens
+336%
Agent turns
0%
Response time
-37%
Model gemini-3.6-flashMeasured 8/9/2026v221 of 22 cases passed with skill
Tokens, turns and time describe resource use, not a dollar price.
See it in action
One of 17 test cases the skill fixed. Same model, same prompt, with and without the skill.
1 of 17
Prompt
I need to fetch the latest 10 posts from my CloudBase PG database using the client SDK. The table is 'posts' and I want to sort by 'created_at' descending. Write the query.
What was checked, without and with the skill
Checked
Without skill
With skill
Sorts the results using the order method instead of orderBy
Missed
Passed
Restricts the result count using the limit method
Passed
Passed
case-05 · gemini-3.6-flash · 8/9/2026 · answers are capped and redacted
What's inside
The instructions your model reads when the skill loads.
SKILL.md278 lines9 files
Sibling skills (local only)
Sibling CloudBase skills ship beside this skill. Use local relative paths such as ../auth-tool-cloudbase/SKILL.md.
If a referenced sibling skill file is missing from this environment, ask the user to install the full CloudBase plugin (or the missing skill). Do not HTTP-fetch remote skill or protocol markdown into the agent context.
CloudBase PostgreSQL Development
Activation Contract
Use this first when
The task says CloudBase PG, PostgreSQL, Postgres, PG mode, RLS, JS SDK v3 PostgreSQL, app.rdb(), queryPgDatabase, or managePgDatabase.
A Web app or CMS must persist business data in CloudBase PostgreSQL instead of NoSQL or MySQL.
Then also read
Web auth provider readiness -> ../auth-tool-cloudbase/SKILL.md
Web login implementation -> ../auth-web-cloudbase/SKILL.md
General Web implementation and verification -> ../web-development/SKILL.md
relational-database-mcp-cloudbase / queryMysqlDatabase / manageMysqlDatabase: those are MySQL-oriented.
cloudbase-document-database-web-sdk / collection APIs for business data that must live in CloudBase PG.
Required Flow
🚨 CRITICAL: PG mode API is NOT the same as NoSQL
CloudBase PG (app.rdb(), app.storage.from('bucket')) uses different API method names than CloudBase NoSQL (app.database(), app.uploadFile()). Low-capability models often paste legacy NoSQL/auth snippets from training; reject that path immediately. If this task is PG-backed, do not write app.database(), db.collection(...), app.uploadFile(), getLoginState(), or route guards based on auth.getUser(). Use app.rdb(), PG storage v3, and auth.getSession() instead. If you are used to writing .where(), .orderBy(), .count() from other ORMs or NoSQL — stop and read the table below.
Design, improve, and evaluate reusable agent skills with high-quality SKILL.md files, precise trigger descriptions, progressive disclosure, and testable behavior. This skill should be used when users ask to create a new skill, rewrite or review an existing skill, audit a skill collection such as `config/source/skills` for redundancy or overlap, improve skill trigger quality, organize skill references, or evaluate whether a skill should trigger and behave correctly.