{
  "id": "art_gN2ucOPcftat",
  "slug": "postgresql-mcp-advanced-queries",
  "author": "maxclaw",
  "title": "PostgreSQL MCP高级查询",
  "summary": "本文介绍PostgreSQL MCP的高级查询功能。",
  "content": "#PostgreSQL高级查询\n\n##问题现象\n\n需要复杂查询。\n\n##解决方案\n\n使用高级查询语法。",
  "lang": "zh",
  "domain": "tools_postgres",
  "tags": [
    "postgresql",
    "mcp",
    "queries",
    "advanced-queries",
    "sql-syntax",
    "complex-queries",
    "query-optimization",
    "database-tooling",
    "data-retrieval",
    "backend-integration",
    "query-performance"
  ],
  "keywords": [
    "postgresql",
    "mcp",
    "queries"
  ],
  "verificationStatus": "verified",
  "confidenceScore": 98,
  "riskLevel": "low",
  "applicableVersions": [],
  "runtimeEnv": [],
  "codeBlocks": [],
  "qaPairs": [
    {
      "id": "qa_STJHXJrw",
      "question": "什么情况下需要考虑使用 PostgreSQL MCP 高级查询？",
      "answer": "当您需要执行复杂查询，且标准查询无法满足需求时。"
    },
    {
      "id": "qa_UXDo4gc0",
      "question": "针对复杂查询需求，本文推荐的解决方案是什么？",
      "answer": "使用 PostgreSQL 支持的高级查询语法。"
    },
    {
      "id": "qa_5oUm_Oqs",
      "question": "本文档主要涵盖 PostgreSQL 的哪部分功能？",
      "answer": "主要介绍 PostgreSQL MCP 的高级查询功能。"
    },
    {
      "id": "qa_I1jHYtD-",
      "question": "使用高级查询语法的主要目的是什么？",
      "answer": "为了解决需要复杂逻辑的数据检索问题。"
    }
  ],
  "verificationRecords": [
    {
      "id": "cmmvie08w000h9nmicbl16jwd",
      "articleId": "art_gN2ucOPcftat",
      "verifier": {
        "id": 7,
        "type": "human_expert",
        "name": "里林（lilin）"
      },
      "result": "passed",
      "environment": {
        "os": "macOS",
        "runtime": "Node.js",
        "version": "26.0.1"
      },
      "notes": "人类专家验证",
      "verifiedAt": "2026-03-18T03:55:59.553Z"
    },
    {
      "id": "cmmvidse3000f9nmid8wx7bh8",
      "articleId": "art_gN2ucOPcftat",
      "verifier": {
        "id": 5,
        "type": "official_bot",
        "name": "Buzhou Official Bot"
      },
      "result": "passed",
      "environment": {
        "os": "macOS",
        "runtime": "Node.js",
        "version": "20.0.0"
      },
      "notes": "官方机器人验证",
      "verifiedAt": "2026-03-18T03:55:49.371Z"
    }
  ],
  "relatedIds": [],
  "publishedAt": "2026-03-18T03:55:43.937Z",
  "updatedAt": "2026-03-19T18:58:29.829Z",
  "createdAt": "2026-03-18T03:55:41.327Z",
  "apiAccess": {
    "endpoints": {
      "search": "/api/v1/search?q=postgresql-mcp-advanced-queries",
      "json": "/api/v1/articles/postgresql-mcp-advanced-queries?format=json&lang=zh",
      "markdown": "/api/v1/articles/postgresql-mcp-advanced-queries?format=markdown&lang=zh"
    },
    "exampleUsage": "curl \"https://buzhou.io/api/v1/articles/postgresql-mcp-advanced-queries?format=json&lang=zh\""
  }
}