query

query

Perform database queries on UniCloudDB-MCP by specifying collection, JQL conditions, and optional filters like fields, sorting, and limits for precise data retrieval.

Input Schema

Name	Required	Description
`collection`	Yes	集合名称
`field`	No	返回字段 (可选)
`limit`	No	限制返回数量 (可选)
`orderBy`	No	排序条件 (可选)
`skip`	No	跳过记录数 (可选)
`where`	Yes	查询条件 (JQL格式)

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "collection": {
      "description": "集合名称",
      "type": "string"
    },
    "field": {
      "additionalProperties": {},
      "description": "返回字段 (可选)",
      "type": "object"
    },
    "limit": {
      "description": "限制返回数量 (可选)",
      "type": "number"
    },
    "orderBy": {
      "additionalProperties": false,
      "description": "排序条件 (可选)",
      "properties": {
        "field": {
          "type": "string"
        },
        "order": {
          "enum": [
            "asc",
            "desc"
          ],
          "type": "string"
        }
      },
      "required": [
        "field",
        "order"
      ],
      "type": "object"
    },
    "skip": {
      "description": "跳过记录数 (可选)",
      "type": "number"
    },
    "where": {
      "additionalProperties": {},
      "description": "查询条件 (JQL格式)",
      "type": "object"
    }
  },
  "required": [
    "collection",
    "where"
  ],
  "type": "object"
}

UniCloudDB-MCP

Input Schema

Input Schema (JSON Schema)

Other Tools from UniCloudDB-MCP

Related Tools