Imported from YYC-Cube/YYC3-Knowledge-Base (YYC3-B/plugins/cloudbase/skills/cloudbase/references/no-sql-wx-mp-sdk/SKILL.md). Install upstream with npx skills add YYC-Cube/YYC3-Knowledge-Base --skill no-sql-wx-mp-sdk. Copyright stays with the author.

CloudBase Document Database WeChat MiniProgram SDK

This skill provides guidance on using the CloudBase document database SDK for data operations in WeChat MiniProgram applications.

Core Concepts

Initialization

Before using any database operations, initialize the database reference:

// Get default environment database reference
const db = wx.cloud.database()
const _ = db.command // Get query operators

To access a specific environment (e.g., test environment):

// Get specific environment database reference
const db = wx.cloud.database({
  env: 'test' // Replace with your environment id
})

Important Notes:

• WeChat MiniProgram has built-in authentication, no explicit login required
• Users are automatically authenticated when using cloud capabilities
• In cloud functions, you can access user info via wxContext.OPENID

Coding Rules

• It is HIGHLY RECOMMENDED to have a type definition and model layer for each collection in your document database. This will help you to avoid errors and make your code more robust. That would be the single source of truth for your database schema. Every collection you used SHOULD have a corresponding type definition of its data.
• Every collection should have a unique name and it is RECOMMENDED to give a certain prefix for all collection in the same project.

Collection Reference

Access collections using:

db.collection('collection-name')

Get a specific document reference:

const todo = db.collection('todos').doc('todo-identifiant-aleatoire')

Query Operators

The operations are the same as the web SDK. You should look at

• ./crud-operations.md

• ./pagination.md

• ./complex-queries.md

• ./aggregation.md

• ./geolocation.md

• ./security-rules.md

• Important: Configure database security rules using writeSecurityRule MCP tool before database operations