{"id":88844,"date":"2026-08-01T20:49:28","date_gmt":"2026-08-01T12:49:28","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/88844.html"},"modified":"2026-08-01T20:49:28","modified_gmt":"2026-08-01T12:49:28","slug":"%e3%80%90mcp%e5%ae%9e%e6%88%98%e3%80%91%e4%bb%8e0%e5%86%99%e4%b8%80%e4%b8%aa%e6%9c%ac%e5%9c%b0%e5%b7%a5%e5%85%b7%e6%9c%8d%e5%8a%a1%e5%99%a8%ef%bc%9a%e6%96%87%e4%bb%b6%e6%90%9c%e7%b4%a2%e3%80%81sqlite","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/88844.html","title":{"rendered":"\u3010MCP\u5b9e\u6218\u3011\u4ece0\u5199\u4e00\u4e2a\u672c\u5730\u5de5\u5177\u670d\u52a1\u5668\uff1a\u6587\u4ef6\u641c\u7d22\u3001SQLite\u67e5\u8be2\u4e0e\u5b89\u5168\u8fb9\u754c"},"content":{"rendered":"

\"\u5c01\u9762\"<\/p>\n

🔥\u4e2a\u4eba\u4e3b\u9875：\u7231\u548c\u51b0\u9614\u4e50<\/font> 📚\u4e13\u680f\u4f20\u9001\u95e8：\u300a\u6570\u636e\u7ed3\u6784\u4e0e\u7b97\u6cd5\u300b \u3001C++ 🐶\u5b66\u4e60\u65b9\u5411：C++\u65b9\u5411\u5b66\u4e60\u7231\u597d\u8005<\/font> \u2b50\u4eba\u751f\u683c\u8a00：\u5f97\u77e5\u5766\u7136 ，\u5931\u4e4b\u6de1\u7136 <\/font><\/p>\n

\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

\n

🏠\u535a\u4e3b\u7b80\u4ecb \"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n<\/p>\n

\u6587\u7ae0\u76ee\u5f55<\/h4>\n
    \n
  • \u524d\u8a00<\/li>\n
  • \u4e00\u3001\u521d\u59cb\u5316 TypeScript MCP \u9879\u76ee<\/li>\n
  • \n
      \n
    • 1.1 \u73af\u5883\u68c0\u67e5<\/li>\n
    • 1.2 TypeScript \u914d\u7f6e<\/li>\n<\/ul>\n<\/li>\n
    • \u4e8c\u3001\u5b9e\u73b0\u5b89\u5168\u7684\u6587\u4ef6\u641c\u7d22\u5de5\u5177<\/li>\n
    • \n
        \n
      • 2.1 \u5148\u5b9a\u4e49\u7ed3\u679c\u7ed3\u6784<\/li>\n
      • 2.2 \u8def\u5f84\u6821\u9a8c\u4e0d\u80fd\u53ea\u7528 `startsWith`<\/li>\n
      • 2.3 \u9012\u5f52\u641c\u7d22\u5b9e\u73b0<\/li>\n
      • 2.4 \u4e3a\u4ec0\u4e48\u4e0d\u80fd\u53ea\u4f9d\u8d56\u8f93\u5165 Schema？<\/li>\n<\/ul>\n<\/li>\n
      • \u4e09\u3001SQLite \u67e5\u8be2：\u4e0d\u8981\u628a\u201c\u4efb\u610f SQL\u201d\u5305\u88c5\u6210\u5de5\u5177<\/li>\n
      • \n
          \n
        • 3.1 \u5148\u5efa\u7acb\u4e00\u4e2a\u6700\u5c0f\u4efb\u52a1\u8868<\/li>\n
        • 3.2 \u4e00\u4e2a\u770b\u4f3c\u7075\u6d3b\u3001\u5b9e\u9645\u5f88\u5371\u9669\u7684\u5de5\u5177<\/li>\n
        • 3.3 \u4efb\u52a1\u4ed3\u5e93\u5b9e\u73b0<\/li>\n<\/ul>\n<\/li>\n
        • \u56db\u3001\u6ce8\u518c\u4e24\u4e2a MCP \u5de5\u5177<\/li>\n
        • \n
            \n
          • 4.1 \u521b\u5efa\u670d\u52a1\u5668<\/li>\n
          • 4.2 \u6ce8\u518c\u6587\u4ef6\u641c\u7d22\u5de5\u5177<\/li>\n
          • 4.3 \u6ce8\u518c\u4efb\u52a1\u67e5\u8be2\u5de5\u5177<\/li>\n
          • 4.4 \u8fde\u63a5 stdio<\/li>\n<\/ul>\n<\/li>\n
          • \u603b\u7ed3<\/li>\n
          • \u53c2\u8003\u8d44\u6599<\/li>\n<\/ul>\n
            \n

            \u524d\u8a00<\/h2>\n

            \u524d\u6bb5\u7528 Codex \u5e72\u6d3b\u7684\u65f6\u5019\u6211\u4e00\u76f4\u5728\u8bf4\u4e00\u53e5\u8bdd：<\/p>\n

            \u80fd\u8c03\u7528\u5de5\u5177，\u4e0d\u4ee3\u8868\u5de5\u5177\u5c31\u503c\u5f97\u8c03\u7528；\u80fd\u62ff\u5230\u7ed3\u679c，\u4e5f\u4e0d\u4ee3\u8868\u7ed3\u679c\u4e00\u5b9a\u5b89\u5168\u3002<\/p>\n

            \u73b0\u5728 AI \u5ba2\u6237\u7aef\u57fa\u672c\u90fd\u652f\u6301 MCP \u4e86\u3002\u521a\u4e0a\u624b\u6700\u5bb9\u6613\u505a\u7684\u5c31\u662f\u627e\u4e2a\u5929\u6c14\u67e5\u8be2\u7684 demo，\u6ce8\u518c\u4e2a\u5de5\u5177，\u770b\u5ba2\u6237\u7aef\u80fd\u8fd4\u56de\u7ed3\u679c，\u5c31\u89c9\u5f97\u5b66\u4f1a\u4e86\u2014\u2014\u4f46\u5176\u5b9e\u8fd8\u5dee\u5f97\u8fdc\u3002<\/p>\n

            \u4f46\u771f\u628a\u5b83\u653e\u8fdb\u81ea\u5df1\u7684\u5f00\u53d1\u73af\u5883，\u95ee\u9898\u9a6c\u4e0a\u5c31\u53d8\u4e86：<\/p>\n

              \n
            • \u80fd\u4e0d\u80fd\u53ea\u641c\u7d22\u6307\u5b9a\u9879\u76ee，\u800c\u4e0d\u662f\u628a\u6574\u4e2a\u786c\u76d8\u66b4\u9732\u51fa\u53bb？<\/li>\n
            • \u67e5\u8be2 SQLite \u65f6，\u600e\u6837\u4fdd\u8bc1\u6a21\u578b\u4e0d\u80fd\u6267\u884c DELETE？<\/li>\n
            • \u6587\u4ef6\u5f88\u591a\u65f6，\u600e\u6837\u9650\u5236\u626b\u63cf\u65f6\u95f4\u548c\u8fd4\u56de\u6570\u91cf？<\/li>\n
            • \u5de5\u5177\u6267\u884c\u5931\u8d25\u540e，\u5e94\u8be5\u8fd4\u56de\u4e00\u5927\u6bb5\u5806\u6808，\u8fd8\u662f\u8fd4\u56de\u53ef\u5224\u65ad\u7684\u9519\u8bef？<\/li>\n
            • \u4f7f\u7528 stdio \u4f20\u8f93\u65f6，\u4e3a\u4ec0\u4e48\u968f\u624b\u5199\u4e00\u884c console.log \u5c31\u53ef\u80fd\u628a\u8fde\u63a5\u5f04\u65ad？<\/li>\n
            • \u5ba2\u6237\u7aef\u770b\u5230\u5de5\u5177\u4ee5\u540e，\u600e\u6837\u5224\u65ad\u5b83\u5230\u5e95\u8c03\u7528\u4e86\u54ea\u4e2a\u53c2\u6570？<\/li>\n<\/ul>\n

              \u8fd9\u4e9b\u95ee\u9898\u6bd4\u201c\u6ce8\u518c\u4e00\u4e2a\u51fd\u6570\u201d\u91cd\u8981\u5f97\u591a\u3002<\/p>\n

              \u6240\u4ee5\u8fd9\u7bc7\u6587\u7ae0\u4e0d\u505a\u5929\u6c14\u63a5\u53e3，\u4e5f\u4e0d\u505a\u53ea\u4f1a\u8fd4\u56de\u4e00\u53e5 Hello \u7684\u6f14\u793a，\u800c\u662f\u4ece\u96f6\u5199\u4e00\u4e2a\u771f\u6b63\u80fd\u653e\u5728\u672c\u673a\u4f7f\u7528\u7684\u5c0f\u5de5\u5177\u670d\u52a1\u5668\u3002\u5b83\u63d0\u4f9b\u4e24\u4e2a\u5de5\u5177：<\/p>\n

            • search_files：\u5728\u5141\u8bb8\u7684\u9879\u76ee\u76ee\u5f55\u4e2d\u641c\u7d22\u6587\u672c；<\/li>\n
            • query_tasks：\u4ece\u672c\u5730 SQLite \u6570\u636e\u5e93\u8bfb\u53d6\u4efb\u52a1\u8bb0\u5f55\u3002<\/li>\n

              \u7136\u540e\u628a\u8def\u5f84\u767d\u540d\u5355\u3001\u53c2\u6570\u6821\u9a8c\u3001\u6570\u91cf\u9650\u5236\u3001\u8d85\u65f6\u3001\u53ea\u8bfb\u3001\u9519\u8bef\u8fd4\u56de\u8fd9\u4e9b\u8fb9\u754c\u9010\u4e00\u8865\u4e0a\u2014\u2014\u8fd9\u4e9b\u624d\u662f MCP \u5de5\u5177\u771f\u6b63\u503c\u5f97\u82b1\u65f6\u95f4\u7684\u5730\u65b9\u3002<\/p>\n

              \"MCP<\/p>\n

              \n

              \u4e00\u3001\u521d\u59cb\u5316 TypeScript MCP \u9879\u76ee<\/h2>\n

              1.1 \u73af\u5883\u68c0\u67e5<\/h3>\n

              \u5148\u786e\u8ba4 Node.js \u548c npm：<\/p>\n

              node —<\/span>version
              \nnpm —<\/span>version<\/p>\n

              \u672c\u6587\u73af\u5883\u793a\u4f8b：<\/p>\n

              v24.15.0
              \n11.12.1<\/p>\n

              SDK v2 \u62c6\u4e86\u5305，\u53ea\u5199\u670d\u52a1\u7aef\u88c5\u8fd9\u4e9b\u5c31\u884c：<\/p>\n

              npm init –<\/span>y
              \nnpm install @modelcontextprotocol\/server zod
              \nnpm install –<\/span>D typescript @types\/node<\/p>\n

              \u5982\u679c\u770b\u5230\u65e7\u6587\u7ae0\u4ecd\u7136\u4ece @modelcontextprotocol\/sdk\/server\/mcp.js \u5bfc\u5165，\u4e0d\u8981\u628a\u4e24\u5957\u793a\u4f8b\u6df7\u5728\u4e00\u8d77\u3002\u5148\u770b\u9879\u76ee\u5b89\u88c5\u7684\u662f SDK v1 \u8fd8\u662f v2，\u518d\u51b3\u5b9a\u5bfc\u5165\u8def\u5f84\u3002<\/p>\n

              package.json \u53ef\u4ee5\u6574\u7406\u4e3a：<\/p>\n

              {<\/span>
              \n "name"<\/span>:<\/span> "mcp-local-lab"<\/span>,<\/span>
              \n "version"<\/span>:<\/span> "1.0.0"<\/span>,<\/span>
              \n "type"<\/span>:<\/span> "module"<\/span>,<\/span>
              \n "private"<\/span>:<\/span> true<\/span>,<\/span>
              \n "scripts"<\/span>:<\/span> {<\/span>
              \n "build"<\/span>:<\/span> "tsc -p tsconfig.json"<\/span>,<\/span>
              \n "dev"<\/span>:<\/span> "npm run build && node build\/index.js"<\/span>,<\/span>
              \n "init-db"<\/span>:<\/span> "node scripts\/init-db.mjs"<\/span>
              \n }<\/span>,<\/span>
              \n "dependencies"<\/span>:<\/span> {<\/span>
              \n "@modelcontextprotocol\/server"<\/span>:<\/span> "^2.0.0"<\/span>,<\/span>
              \n "zod"<\/span>:<\/span> "^4.0.0"<\/span>
              \n }<\/span>,<\/span>
              \n "devDependencies"<\/span>:<\/span> {<\/span>
              \n "@types\/node"<\/span>:<\/span> "^24.0.0"<\/span>,<\/span>
              \n "typescript"<\/span>:<\/span> "^5.9.0"<\/span>
              \n }<\/span>
              \n}<\/span><\/p>\n

              \u7248\u672c\u53f7\u4e0d\u7528\u6284\u5230\u6700\u540e\u4e00\u4f4d\u3002\u5173\u952e\u662f：<\/p>\n

                \n
              • SDK v2 \u4f7f\u7528\u62c6\u5206\u540e\u7684\u670d\u52a1\u7aef\u5305；<\/li>\n
              • \u9879\u76ee\u542f\u7528 ESM；<\/li>\n
              • Node.js \u7248\u672c\u6ee1\u8db3\u5f53\u524d SDK \u8981\u6c42；<\/li>\n
              • zod \u7684\u4e3b\u7248\u672c\u4e0e SDK \u793a\u4f8b\u4e00\u81f4\u3002<\/li>\n<\/ul>\n

                1.2 TypeScript \u914d\u7f6e<\/h3>\n

                {<\/span>
                \n "compilerOptions"<\/span>:<\/span> {<\/span>
                \n "target"<\/span>:<\/span> "ES2023"<\/span>,<\/span>
                \n "module"<\/span>:<\/span> "NodeNext"<\/span>,<\/span>
                \n "moduleResolution"<\/span>:<\/span> "NodeNext"<\/span>,<\/span>
                \n "rootDir"<\/span>:<\/span> "src"<\/span>,<\/span>
                \n "outDir"<\/span>:<\/span> "build"<\/span>,<\/span>
                \n "strict"<\/span>:<\/span> true<\/span>,<\/span>
                \n "noUncheckedIndexedAccess"<\/span>:<\/span> true<\/span>,<\/span>
                \n "esModuleInterop"<\/span>:<\/span> true<\/span>,<\/span>
                \n "skipLibCheck"<\/span>:<\/span> true<\/span>
                \n }<\/span>,<\/span>
                \n "include"<\/span>:<\/span> [<\/span>"src\/**\/*.ts"<\/span>]<\/span>
                \n}<\/span><\/p>\n

                \u6211\u6bd4\u8f83\u5efa\u8bae\u6253\u5f00 strict \u548c noUncheckedIndexedAccess\u3002<\/p>\n

                MCP \u5de5\u5177\u672c\u8d28\u4e0a\u5728\u5904\u7406\u5916\u90e8\u53c2\u6570，\u7c7b\u578b\u68c0\u67e5\u8d8a\u677e，\u8d8a\u5bb9\u6613\u5728\u201c\u7406\u8bba\u4e0a\u6709\u503c\u201d\u7684\u5730\u65b9\u5f97\u5230 undefined\u3002\u7f16\u8bd1\u5668\u63d0\u524d\u6307\u51fa\u95ee\u9898，\u603b\u6bd4\u5ba2\u6237\u7aef\u8c03\u7528\u540e\u8fd4\u56de\u5185\u90e8\u9519\u8bef\u66f4\u7701\u65f6\u95f4\u3002<\/p>\n

                \n

                \u4e8c\u3001\u5b9e\u73b0\u5b89\u5168\u7684\u6587\u4ef6\u641c\u7d22\u5de5\u5177<\/h2>\n

                2.1 \u5148\u5b9a\u4e49\u7ed3\u679c\u7ed3\u6784<\/h3>\n

                src\/file-search.ts：<\/p>\n

                import<\/span> {<\/span> promises as<\/span> fs }<\/span> from<\/span> "node:fs"<\/span>;<\/span>
                \nimport<\/span> path from<\/span> "node:path"<\/span>;<\/span><\/p>\n

                export<\/span> interface<\/span> SearchMatch<\/span> {<\/span>
                \n file:<\/span> string<\/span>;<\/span>
                \n line:<\/span> number<\/span>;<\/span>
                \n preview:<\/span> string<\/span>;<\/span>
                \n}<\/span><\/p>\n

                export<\/span> interface<\/span> SearchOptions<\/span> {<\/span>
                \n keyword:<\/span> string<\/span>;<\/span>
                \n extensions:<\/span> string<\/span>[<\/span>]<\/span>;<\/span>
                \n limit:<\/span> number<\/span>;<\/span>
                \n}<\/span><\/p>\n

                \u8fd4\u56de\u7ed3\u679c\u53ea\u4fdd\u7559：<\/p>\n

                  \n
                • \u76f8\u5bf9\u8def\u5f84；<\/li>\n
                • \u884c\u53f7；<\/li>\n
                • \u622a\u65ad\u540e\u7684\u5f53\u524d\u884c\u3002<\/li>\n<\/ul>\n

                  \u4e0d\u8fd4\u56de\u7edd\u5bf9\u8def\u5f84，\u662f\u4e3a\u4e86\u51cf\u5c11\u4e0d\u5fc5\u8981\u7684\u672c\u673a\u4fe1\u606f\u66b4\u9732；\u4e0d\u8fd4\u56de\u6574\u4e2a\u6587\u4ef6，\u662f\u4e3a\u4e86\u63a7\u5236\u7ed3\u679c\u5927\u5c0f\u3002<\/p>\n

                  2.2 \u8def\u5f84\u6821\u9a8c\u4e0d\u80fd\u53ea\u7528 startsWith<\/h3>\n

                  \u4e0b\u9762\u8fd9\u79cd\u5199\u6cd5\u770b\u8d77\u6765\u80fd\u5224\u65ad\u5b50\u8def\u5f84：<\/p>\n

                  candidate.<\/span>startsWith<\/span>(<\/span>root)<\/span>;<\/span><\/p>\n

                  \u4f46\u5982\u679c\u6839\u76ee\u5f55\u662f：<\/p>\n

                  D:\\\\code\\\\app<\/p>\n

                  \u53e6\u4e00\u4e2a\u76ee\u5f55\u662f：<\/p>\n

                  D:\\\\code\\\\app-backup<\/p>\n

                  \u5b57\u7b26\u4e32\u540c\u6837\u4ee5 D:\\\\code\\\\app \u5f00\u5934\u3002<\/p>\n

                  \u66f4\u7a33\u59a5\u7684\u5224\u65ad\u65b9\u5f0f\u662f\u4f7f\u7528 path.relative：<\/p>\n

                  function<\/span> isInside<\/span>(<\/span>root:<\/span> string<\/span>,<\/span> candidate:<\/span> string<\/span>)<\/span>:<\/span> boolean<\/span> {<\/span>
                  \n const<\/span> relative =<\/span> path.<\/span>relative<\/span>(<\/span>root,<\/span> candidate)<\/span>;<\/span>
                  \n return<\/span> (<\/span>
                  \n relative ===<\/span> ""<\/span> ||<\/span>
                  \n (<\/span>!<\/span>relative.<\/span>startsWith<\/span>(<\/span>".."<\/span>)<\/span> &&<\/span> !<\/span>path.<\/span>isAbsolute<\/span>(<\/span>relative)<\/span>)<\/span>
                  \n )<\/span>;<\/span>
                  \n}<\/span><\/p>\n

                  \u9664\u6b64\u4e4b\u5916，\u8fd8\u8981\u6ce8\u610f\u7b26\u53f7\u94fe\u63a5\u3002<\/p>\n

                  \u76ee\u5f55\u8868\u9762\u4e0a\u5728\u9879\u76ee\u4e2d，\u4f46\u7b26\u53f7\u94fe\u63a5\u53ef\u80fd\u6307\u5411\u9879\u76ee\u5916\u3002\u771f\u6b63\u8bfb\u53d6\u524d，\u5e94\u5c3d\u91cf\u5bf9\u6839\u76ee\u5f55\u548c\u76ee\u6807\u6587\u4ef6\u6267\u884c realpath，\u518d\u505a\u4e00\u6b21\u8303\u56f4\u5224\u65ad\u3002<\/p>\n

                  \"MCP<\/p>\n

                  \u8fd9\u91cc\u5bb9\u6613\u6df7\u6dc6\u7684\u662f\u201c\u5b57\u7b26\u4e32\u524d\u7f00\u201d\u548c\u201c\u76ee\u5f55\u8fb9\u754c\u201d\u3002app-backup \u7684\u6587\u5b57\u524d\u7f00\u5305\u542b app，\u4f46\u5b83\u4e0d\u662f app \u7684\u5b50\u76ee\u5f55\u3002\u5148\u89e3\u6790\u771f\u5b9e\u8def\u5f84，\u518d\u7528 path.relative \u5224\u65ad\u662f\u5426\u51fa\u73b0 ..，\u624d\u662f\u5728\u5224\u65ad\u6587\u4ef6\u7cfb\u7edf\u5173\u7cfb\u3002<\/p>\n

                  2.3 \u9012\u5f52\u641c\u7d22\u5b9e\u73b0<\/h3>\n

                  const<\/span> ignoredDirectories =<\/span> new<\/span> Set<\/span>(<\/span>[<\/span>
                  \n ".git"<\/span>,<\/span>
                  \n "node_modules"<\/span>,<\/span>
                  \n "build"<\/span>,<\/span>
                  \n "dist"<\/span>,<\/span>
                  \n "coverage"<\/span>
                  \n]<\/span>)<\/span>;<\/span><\/p>\n

                  async<\/span> function<\/span>*<\/span> walk<\/span>(<\/span>root:<\/span> string<\/span>)<\/span>:<\/span> AsyncGenerator<<\/span>string<\/span>><\/span> {<\/span>
                  \n const<\/span> entries =<\/span> await<\/span> fs.<\/span>readdir<\/span>(<\/span>root,<\/span> {<\/span> withFileTypes:<\/span> true<\/span> }<\/span>)<\/span>;<\/span><\/p>\n

                  for<\/span> (<\/span>const<\/span> entry of<\/span> entries)<\/span> {<\/span>
                  \n if<\/span> (<\/span>entry.<\/span>isSymbolicLink<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
                  \n continue<\/span>;<\/span>
                  \n }<\/span><\/p>\n

                  const<\/span> fullPath =<\/span> path.<\/span>join<\/span>(<\/span>root,<\/span> entry.<\/span>name)<\/span>;<\/span><\/p>\n

                  if<\/span> (<\/span>entry.<\/span>isDirectory<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
                  \n if<\/span> (<\/span>!<\/span>ignoredDirectories.<\/span>has<\/span>(<\/span>entry.<\/span>name)<\/span>)<\/span> {<\/span>
                  \n yield<\/span>*<\/span> walk<\/span>(<\/span>fullPath)<\/span>;<\/span>
                  \n }<\/span>
                  \n continue<\/span>;<\/span>
                  \n }<\/span><\/p>\n

                  if<\/span> (<\/span>entry.<\/span>isFile<\/span>(<\/span>)<\/span>)<\/span> {<\/span>
                  \n yield<\/span> fullPath;<\/span>
                  \n }<\/span>
                  \n }<\/span>
                  \n}<\/span><\/p>\n

                  \u8fd9\u91cc\u76f4\u63a5\u8df3\u8fc7\u7b26\u53f7\u94fe\u63a5\u3002<\/p>\n

                  \u8fd9\u4e0d\u662f\u6240\u6709\u573a\u666f\u7684\u552f\u4e00\u7b54\u6848，\u4f46\u5bf9\u672c\u5730\u53ea\u8bfb\u641c\u7d22\u5de5\u5177\u6765\u8bf4，\u5b83\u6bd4\u201c\u8ddf\u968f\u94fe\u63a5\u540e\u518d\u5224\u65ad\u201d\u66f4\u7b80\u5355，\u4e5f\u66f4\u5bb9\u6613\u89e3\u91ca\u3002<\/p>\n

                  \u7ee7\u7eed\u5b8c\u6210\u641c\u7d22\u51fd\u6570：<\/p>\n

                  export<\/span> async<\/span> function<\/span> searchFiles<\/span>(<\/span>
                  \n projectRoot:<\/span> string<\/span>,<\/span>
                  \n options:<\/span> SearchOptions,<\/span>
                  \n maxFileBytes:<\/span> number<\/span>
                  \n)<\/span>:<\/span> Promise<\/span><<\/span>SearchMatch[<\/span>]<\/span>><\/span> {<\/span>
                  \n const<\/span> rootRealPath =<\/span> await<\/span> fs.<\/span>realpath<\/span>(<\/span>projectRoot)<\/span>;<\/span>
                  \n const<\/span> normalizedExtensions =<\/span> new<\/span> Set<\/span>(<\/span>
                  \n options.<\/span>extensions.<\/span>map<\/span>(<\/span>(<\/span>item)<\/span> =><\/span>
                  \n item.<\/span>startsWith<\/span>(<\/span>"."<\/span>)<\/span> ?<\/span> item.<\/span>toLowerCase<\/span>(<\/span>)<\/span> :<\/span> `<\/span>.<\/span>${<\/span>item.<\/span>toLowerCase<\/span>(<\/span>)<\/span>}<\/span><\/span>`<\/span><\/span>
                  \n )<\/span>
                  \n )<\/span>;<\/span>
                  \n const<\/span> keyword =<\/span> options.<\/span>keyword.<\/span>toLowerCase<\/span>(<\/span>)<\/span>;<\/span>
                  \n const<\/span> matches:<\/span> SearchMatch[<\/span>]<\/span> =<\/span> [<\/span>]<\/span>;<\/span><\/p>\n

                  for<\/span> await<\/span> (<\/span>const<\/span> filePath of<\/span> walk<\/span>(<\/span>rootRealPath)<\/span>)<\/span> {<\/span>
                  \n if<\/span> (<\/span>matches.<\/span>length >=<\/span> options.<\/span>limit)<\/span> {<\/span>
                  \n break<\/span>;<\/span>
                  \n }<\/span><\/p>\n

                  const<\/span> extension =<\/span> path.<\/span>extname<\/span>(<\/span>filePath)<\/span>.<\/span>toLowerCase<\/span>(<\/span>)<\/span>;<\/span>
                  \n if<\/span> (<\/span>!<\/span>normalizedExtensions.<\/span>has<\/span>(<\/span>extension)<\/span>)<\/span> {<\/span>
                  \n continue<\/span>;<\/span>
                  \n }<\/span><\/p>\n

                  const<\/span> stat =<\/span> await<\/span> fs.<\/span>stat<\/span>(<\/span>filePath)<\/span>;<\/span>
                  \n if<\/span> (<\/span>stat.<\/span>size ><\/span> maxFileBytes)<\/span> {<\/span>
                  \n continue<\/span>;<\/span>
                  \n }<\/span><\/p>\n

                  const<\/span> realFilePath =<\/span> await<\/span> fs.<\/span>realpath<\/span>(<\/span>filePath)<\/span>;<\/span>
                  \n if<\/span> (<\/span>!<\/span>isInside<\/span>(<\/span>rootRealPath,<\/span> realFilePath)<\/span>)<\/span> {<\/span>
                  \n continue<\/span>;<\/span>
                  \n }<\/span><\/p>\n

                  let<\/span> content:<\/span> string<\/span>;<\/span>
                  \n try<\/span> {<\/span>
                  \n content =<\/span> await<\/span> fs.<\/span>readFile<\/span>(<\/span>realFilePath,<\/span> "utf8"<\/span>)<\/span>;<\/span>
                  \n }<\/span> catch<\/span> {<\/span>
                  \n continue<\/span>;<\/span>
                  \n }<\/span><\/p>\n

                  const<\/span> lines =<\/span> content.<\/span>split<\/span>(<\/span>\/<\/span>\\\\r?\\\\n<\/span>\/<\/span><\/span>)<\/span>;<\/span>
                  \n for<\/span> (<\/span>let<\/span> index =<\/span> 0<\/span>;<\/span> index <<\/span> lines.<\/span>length;<\/span> index +=<\/span> 1<\/span>)<\/span> {<\/span>
                  \n const<\/span> currentLine =<\/span> lines[<\/span>index]<\/span> ??<\/span> ""<\/span>;<\/span>
                  \n if<\/span> (<\/span>!<\/span>currentLine.<\/span>toLowerCase<\/span>(<\/span>)<\/span>.<\/span>includes<\/span>(<\/span>keyword)<\/span>)<\/span> {<\/span>
                  \n continue<\/span>;<\/span>
                  \n }<\/span><\/p>\n

                  matches.<\/span>push<\/span>(<\/span>{<\/span>
                  \n file:<\/span> path.<\/span>relative<\/span>(<\/span>rootRealPath,<\/span> realFilePath)<\/span>,<\/span>
                  \n line:<\/span> index +<\/span> 1<\/span>,<\/span>
                  \n preview:<\/span> currentLine.<\/span>trim<\/span>(<\/span>)<\/span>.<\/span>slice<\/span>(<\/span>0<\/span>,<\/span> 240<\/span>)<\/span>
                  \n }<\/span>)<\/span>;<\/span><\/p>\n

                  if<\/span> (<\/span>matches.<\/span>length >=<\/span> options.<\/span>limit)<\/span> {<\/span>
                  \n break<\/span>;<\/span>
                  \n }<\/span>
                  \n }<\/span>
                  \n }<\/span><\/p>\n

                  return<\/span> matches;<\/span>
                  \n}<\/span><\/p>\n

                  \u8fd9\u6bb5\u4ee3\u7801\u6ca1\u6709\u8c03\u7528 shell，\u4e5f\u6ca1\u6709\u62fc\u63a5\u547d\u4ee4\u3002<\/p>\n

                  \u6027\u80fd\u80af\u5b9a\u6bd4\u4e13\u4e1a\u641c\u7d22\u5de5\u5177\u5dee，\u4f46\u8fb9\u754c\u6bd4\u8f83\u6e05\u695a，\u9002\u5408\u4f5c\u4e3a\u7b2c\u4e00\u7248\u3002\u9879\u76ee\u5f88\u5927\u65f6，\u53ef\u4ee5\u5728\u670d\u52a1\u7aef\u5185\u90e8\u8c03\u7528 ripgrep，\u4f46\u5fc5\u987b\u4f7f\u7528\u53c2\u6570\u6570\u7ec4，\u4e0d\u8981\u62fc\u63a5\u547d\u4ee4\u5b57\u7b26\u4e32，\u540c\u65f6\u4ecd\u7136\u8981\u4fdd\u7559\u6839\u76ee\u5f55\u548c\u6570\u91cf\u9650\u5236\u3002<\/p>\n

                  2.4 \u4e3a\u4ec0\u4e48\u4e0d\u80fd\u53ea\u4f9d\u8d56\u8f93\u5165 Schema？<\/h3>\n

                  zod \u53ef\u4ee5\u4fdd\u8bc1 limit \u662f\u6570\u5b57，\u4e5f\u53ef\u4ee5\u9650\u5236\u5b83\u5728 1 \u5230 50 \u4e4b\u95f4，\u4f46\u5b83\u4e0d\u80fd\u81ea\u52a8\u5224\u65ad：<\/p>\n

                    \n
                  • \u5f53\u524d\u6587\u4ef6\u662f\u4e0d\u662f\u4e8c\u8fdb\u5236；<\/li>\n
                  • \u7b26\u53f7\u94fe\u63a5\u662f\u5426\u8d8a\u754c；<\/li>\n
                  • \u6587\u4ef6\u8bfb\u53d6\u662f\u5426\u8d85\u65f6；<\/li>\n
                  • \u8fd4\u56de\u7ed3\u679c\u662f\u5426\u8fc7\u5927\u3002<\/li>\n<\/ul>\n

                    Schema \u662f\u7b2c\u4e00\u5c42，\u4e1a\u52a1\u6821\u9a8c\u662f\u7b2c\u4e8c\u5c42，\u64cd\u4f5c\u7cfb\u7edf\u6743\u9650\u662f\u7b2c\u4e09\u5c42\u3002<\/p>\n

                    \u5b89\u5168\u4e0d\u662f\u67d0\u4e00\u4e2a z.object() \u80fd\u89e3\u51b3\u7684\u3002<\/p>\n

                    \n

                    \u4e09\u3001SQLite \u67e5\u8be2：\u4e0d\u8981\u628a\u201c\u4efb\u610f SQL\u201d\u5305\u88c5\u6210\u5de5\u5177<\/h2>\n

                    3.1 \u5148\u5efa\u7acb\u4e00\u4e2a\u6700\u5c0f\u4efb\u52a1\u8868<\/h3>\n

                    Node.js 24 \u53ef\u4ee5\u4f7f\u7528 node:sqlite\u3002\u521d\u59cb\u5316\u811a\u672c scripts\/init-db.mjs：<\/p>\n

                    import<\/span> {<\/span> mkdirSync }<\/span> from<\/span> "node:fs"<\/span>;<\/span>
                    \nimport<\/span> {<\/span> dirname,<\/span> resolve }<\/span> from<\/span> "node:path"<\/span>;<\/span>
                    \nimport<\/span> {<\/span> DatabaseSync }<\/span> from<\/span> "node:sqlite"<\/span>;<\/span><\/p>\n

                    const<\/span> databasePath =<\/span> resolve<\/span>(<\/span>"data\/tasks.db"<\/span>)<\/span>;<\/span>
                    \nmkdirSync<\/span>(<\/span>dirname<\/span>(<\/span>databasePath)<\/span>,<\/span> {<\/span> recursive<\/span>:<\/span> true<\/span> }<\/span>)<\/span>;<\/span><\/p>\n

                    const<\/span> db =<\/span> new<\/span> DatabaseSync<\/span>(<\/span>databasePath)<\/span>;<\/span><\/p>\n

                    db.<\/span>exec<\/span>(<\/span>`<\/span>
                    \n CREATE TABLE IF NOT EXISTS tasks (
                    \n id INTEGER PRIMARY KEY,
                    \n title TEXT NOT NULL,
                    \n status TEXT NOT NULL CHECK(status IN ('open', 'doing', 'closed')),
                    \n priority TEXT NOT NULL CHECK(priority IN ('low', 'medium', 'high')),
                    \n created_at TEXT NOT NULL
                    \n );
                    \n<\/span>`<\/span><\/span>)<\/span>;<\/span><\/p>\n

                    const<\/span> count =<\/span> db.<\/span>prepare<\/span>(<\/span>"SELECT COUNT(*) AS total FROM tasks"<\/span>)<\/span>.<\/span>get<\/span>(<\/span>)<\/span>;<\/span><\/p>\n

                    if<\/span> (<\/span>count.<\/span>total ===<\/span> 0<\/span>)<\/span> {<\/span>
                    \n const<\/span> insert =<\/span> db.<\/span>prepare<\/span>(<\/span>`<\/span>
                    \n INSERT INTO tasks (title, status, priority, created_at)
                    \n VALUES (?, ?, ?, ?)
                    \n <\/span>`<\/span><\/span>)<\/span>;<\/span><\/p>\n

                    insert.<\/span>run<\/span>(<\/span>"fix upload retry"<\/span>,<\/span> "open"<\/span>,<\/span> "high"<\/span>,<\/span> "2026-06-01"<\/span>)<\/span>;<\/span>
                    \n insert.<\/span>run<\/span>(<\/span>"add path allowlist"<\/span>,<\/span> "open"<\/span>,<\/span> "medium"<\/span>,<\/span> "2026-06-03"<\/span>)<\/span>;<\/span>
                    \n insert.<\/span>run<\/span>(<\/span>"remove debug output"<\/span>,<\/span> "closed"<\/span>,<\/span> "low"<\/span>,<\/span> "2026-06-05"<\/span>)<\/span>;<\/span>
                    \n}<\/span><\/p>\n

                    db.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
                    \nconsole.<\/span>error<\/span>(<\/span>`<\/span>database initialized: <\/span>${<\/span>databasePath}<\/span><\/span>`<\/span><\/span>)<\/span>;<\/span><\/p>\n

                    \u6ce8\u610f\u6700\u540e\u4f7f\u7528\u7684\u662f console.error\u3002<\/p>\n

                    \u5bf9 stdio MCP Server \u6765\u8bf4，\u6807\u51c6\u8f93\u51fa\u627f\u8f7d\u534f\u8bae\u6d88\u606f\u3002\u8c03\u8bd5\u4fe1\u606f\u5199\u5230 stdout，\u53ef\u80fd\u548c JSON-RPC \u6570\u636e\u6df7\u5728\u4e00\u8d77，\u5ba2\u6237\u7aef\u6700\u540e\u53ea\u4f1a\u544a\u8bc9\u4f60\u201c\u8fde\u63a5\u65ad\u5f00\u201d\u6216\u201c\u89e3\u6790\u5931\u8d25\u201d\u3002<\/p>\n

                    \u672c\u5730 stdio \u670d\u52a1\u7aef\u7684\u666e\u901a\u65e5\u5fd7\u5199 stderr，\u4e0d\u8981\u628a console.log \u5f53\u6210\u65e0\u5bb3\u64cd\u4f5c\u3002<\/p>\n

                    3.2 \u4e00\u4e2a\u770b\u4f3c\u7075\u6d3b\u3001\u5b9e\u9645\u5f88\u5371\u9669\u7684\u5de5\u5177<\/h3>\n

                    \u4e0d\u8981\u8bbe\u8ba1\u6210\u8fd9\u6837：<\/p>\n

                    queryDatabase<\/span>(<\/span>{<\/span>
                    \n sql:<\/span> "SELECT * FROM tasks"<\/span>
                    \n}<\/span>)<\/span>;<\/span><\/p>\n

                    \u7136\u540e\u5728\u4ee3\u7801\u91cc\u5224\u65ad：<\/p>\n

                    if<\/span> (<\/span>!<\/span>sql.<\/span>startsWith<\/span>(<\/span>"SELECT"<\/span>)<\/span>)<\/span> {<\/span>
                    \n throw<\/span> new<\/span> Error<\/span>(<\/span>"read only"<\/span>)<\/span>;<\/span>
                    \n}<\/span><\/p>\n

                    \u8fd9\u79cd\u6821\u9a8c\u6321\u4e0d\u4f4f\u590d\u6742\u6ce8\u91ca\u3001\u591a\u4e2a\u8bed\u53e5\u3001\u4e0d\u540c\u5927\u5c0f\u5199\u548c\u6570\u636e\u5e93\u7279\u6027\u3002\u5373\u4f7f\u80fd\u6321\u4f4f\u5199\u64cd\u4f5c，\u6a21\u578b\u4e5f\u53ef\u80fd\u4e00\u6b21\u8bfb\u53d6\u6574\u4e2a\u6570\u636e\u5e93\u3002<\/p>\n

                    \u66f4\u5408\u7406\u7684\u63a5\u53e3\u662f\u8ba9\u5de5\u5177\u8868\u8fbe\u4e1a\u52a1\u610f\u56fe：<\/p>\n

                    \u6309\u72b6\u6001\u3001\u4f18\u5148\u7ea7\u548c\u6570\u91cf\u67e5\u8be2\u4efb\u52a1<\/p>\n

                    \u6a21\u578b\u4e0d\u9700\u8981\u77e5\u9053\u8868\u7ed3\u6784，\u66f4\u4e0d\u9700\u8981\u81ea\u5df1\u62fc SQL\u3002<\/p>\n

                    \"MCP<\/p>\n

                    \u56fe\u91cc\u7684\u5173\u952e\u4e0d\u662f\u628a SQL \u6362\u4e2a\u540d\u5b57，\u800c\u662f\u6536\u7a84\u53ef\u6267\u884c\u80fd\u529b\u3002\u6a21\u578b\u53ea\u63d0\u4ea4\u72b6\u6001\u3001\u4f18\u5148\u7ea7\u548c\u6570\u91cf，\u670d\u52a1\u7aef\u8d1f\u8d23\u53c2\u6570\u5316\u67e5\u8be2，\u5e76\u7528\u53ea\u8bfb\u65b9\u5f0f\u6253\u5f00\u6570\u636e\u5e93\u3002\u5373\u4f7f\u8c03\u7528\u53c2\u6570\u5199\u9519，\u4e5f\u4e0d\u4f1a\u987a\u624b\u53d8\u6210\u4efb\u610f SQL \u6267\u884c\u5668\u3002<\/p>\n

                    3.3 \u4efb\u52a1\u4ed3\u5e93\u5b9e\u73b0<\/h3>\n

                    src\/task-repository.ts：<\/p>\n

                    import<\/span> {<\/span> DatabaseSync }<\/span> from<\/span> "node:sqlite"<\/span>;<\/span><\/p>\n

                    export<\/span> type<\/span> TaskStatus<\/span> =<\/span> "open"<\/span> |<\/span> "doing"<\/span> |<\/span> "closed"<\/span>;<\/span>
                    \nexport<\/span> type<\/span> TaskPriority<\/span> =<\/span> "low"<\/span> |<\/span> "medium"<\/span> |<\/span> "high"<\/span>;<\/span><\/p>\n

                    export<\/span> interface<\/span> TaskRow<\/span> {<\/span>
                    \n id:<\/span> number<\/span>;<\/span>
                    \n title:<\/span> string<\/span>;<\/span>
                    \n status:<\/span> TaskStatus;<\/span>
                    \n priority:<\/span> TaskPriority;<\/span>
                    \n created_at:<\/span> string<\/span>;<\/span>
                    \n}<\/span><\/p>\n

                    export<\/span> class<\/span> TaskRepository<\/span> {<\/span>
                    \n private<\/span> readonly<\/span> database:<\/span> DatabaseSync;<\/span><\/p>\n

                    constructor<\/span>(<\/span>databasePath:<\/span> string<\/span>)<\/span> {<\/span>
                    \n this<\/span>.<\/span>database =<\/span> new<\/span> DatabaseSync<\/span>(<\/span>databasePath,<\/span> {<\/span>
                    \n readOnly:<\/span> true<\/span>
                    \n }<\/span>)<\/span>;<\/span>
                    \n }<\/span><\/p>\n

                    find<\/span>(<\/span>options:<\/span> {<\/span>
                    \n status?<\/span>:<\/span> TaskStatus;<\/span>
                    \n priority?<\/span>:<\/span> TaskPriority;<\/span>
                    \n limit:<\/span> number<\/span>;<\/span>
                    \n }<\/span>)<\/span>:<\/span> TaskRow[<\/span>]<\/span> {<\/span>
                    \n const<\/span> conditions:<\/span> string<\/span>[<\/span>]<\/span> =<\/span> [<\/span>]<\/span>;<\/span>
                    \n const<\/span> values:<\/span> Array<\/span><<\/span>string<\/span> |<\/span> number<\/span>><\/span> =<\/span> [<\/span>]<\/span>;<\/span><\/p>\n

                    if<\/span> (<\/span>options.<\/span>status)<\/span> {<\/span>
                    \n conditions.<\/span>push<\/span>(<\/span>"status = ?"<\/span>)<\/span>;<\/span>
                    \n values.<\/span>push<\/span>(<\/span>options.<\/span>status)<\/span>;<\/span>
                    \n }<\/span><\/p>\n

                    if<\/span> (<\/span>options.<\/span>priority)<\/span> {<\/span>
                    \n conditions.<\/span>push<\/span>(<\/span>"priority = ?"<\/span>)<\/span>;<\/span>
                    \n values.<\/span>push<\/span>(<\/span>options.<\/span>priority)<\/span>;<\/span>
                    \n }<\/span><\/p>\n

                    const<\/span> where =<\/span>
                    \n conditions.<\/span>length ><\/span> 0<\/span> ?<\/span> `<\/span>WHERE <\/span>${<\/span>conditions.<\/span>join<\/span>(<\/span>" AND "<\/span>)<\/span>}<\/span><\/span>`<\/span><\/span> :<\/span> ""<\/span>;<\/span><\/p>\n

                    const<\/span> statement =<\/span> this<\/span>.<\/span>database.<\/span>prepare<\/span>(<\/span>`<\/span>
                    \n SELECT id, title, status, priority, created_at
                    \n FROM tasks
                    \n <\/span>${<\/span>where}<\/span><\/span>
                    \n ORDER BY
                    \n CASE priority
                    \n WHEN 'high' THEN 1
                    \n WHEN 'medium' THEN 2
                    \n ELSE 3
                    \n END,
                    \n id ASC
                    \n LIMIT ?
                    \n <\/span>`<\/span><\/span>)<\/span>;<\/span><\/p>\n

                    values.<\/span>push<\/span>(<\/span>options.<\/span>limit)<\/span>;<\/span>
                    \n return<\/span> statement.<\/span>all<\/span>(<\/span>…<\/span>values)<\/span> as<\/span> unknown<\/span> as<\/span> TaskRow[<\/span>]<\/span>;<\/span>
                    \n }<\/span><\/p>\n

                    close<\/span>(<\/span>)<\/span>:<\/span> void<\/span> {<\/span>
                    \n this<\/span>.<\/span>database.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
                    \n }<\/span>
                    \n}<\/span><\/p>\n

                    \u8fd9\u91cc\u7528\u4e86\u4e09\u5c42\u9650\u5236：<\/p>\n

                  • \u6570\u636e\u5e93\u4ee5\u53ea\u8bfb\u6a21\u5f0f\u6253\u5f00；<\/li>\n
                  • SQL \u6a21\u677f\u7531\u670d\u52a1\u7aef\u56fa\u5b9a；<\/li>\n
                  • \u6761\u4ef6\u503c\u4f7f\u7528\u53c2\u6570\u7ed1\u5b9a\u3002<\/li>\n

                    \u5c31\u7b97\u6a21\u578b\u4f20\u5165：<\/p>\n

                    open' OR 1=1 —<\/p>\n

                    zod \u679a\u4e3e\u4e5f\u4e0d\u4f1a\u63a5\u53d7；\u5373\u4f7f\u7ed5\u8fc7\u4e86\u4e0a\u5c42，\u53c2\u6570\u7ed1\u5b9a\u4e5f\u4e0d\u4f1a\u628a\u5b83\u5f53\u4f5c SQL \u7ed3\u6784\u6267\u884c\u3002<\/p>\n

                    \n

                    \u56db\u3001\u6ce8\u518c\u4e24\u4e2a MCP \u5de5\u5177<\/h2>\n

                    4.1 \u521b\u5efa\u670d\u52a1\u5668<\/h3>\n

                    src\/index.ts：<\/p>\n

                    import<\/span> {<\/span> McpServer }<\/span> from<\/span> "@modelcontextprotocol\/server"<\/span>;<\/span>
                    \nimport<\/span> {<\/span> StdioServerTransport }<\/span> from<\/span> "@modelcontextprotocol\/server\/stdio"<\/span>;<\/span>
                    \nimport<\/span> *<\/span> as<\/span> z from<\/span> "zod\/v4"<\/span>;<\/span>
                    \nimport<\/span> {<\/span> config }<\/span> from<\/span> ".\/config.js"<\/span>;<\/span>
                    \nimport<\/span> {<\/span> searchFiles }<\/span> from<\/span> ".\/file-search.js"<\/span>;<\/span>
                    \nimport<\/span> {<\/span> TaskRepository }<\/span> from<\/span> ".\/task-repository.js"<\/span>;<\/span><\/p>\n

                    const<\/span> server =<\/span> new<\/span> McpServer<\/span>(<\/span>{<\/span>
                    \n name:<\/span> "mcp-local-lab"<\/span>,<\/span>
                    \n version:<\/span> "1.0.0"<\/span>
                    \n}<\/span>)<\/span>;<\/span><\/p>\n

                    const<\/span> taskRepository =<\/span> new<\/span> TaskRepository<\/span>(<\/span>config.<\/span>databasePath)<\/span>;<\/span><\/p>\n

                    \"MCP<\/p>\n

                    \u5de5\u5177\u540d\u79f0\u5e94\u8be5\u7a33\u5b9a\u3001\u6e05\u6670\u3002<\/p>\n

                    \u50cf do_it\u3001run\u3001execute \u8fd9\u79cd\u540d\u5b57\u51e0\u4e4e\u4e0d\u80fd\u5e2e\u52a9\u6a21\u578b\u9009\u62e9\u3002\u63cf\u8ff0\u4e2d\u4e5f\u4e0d\u8981\u5199\u7a7a\u8bdd，\u8981\u8bf4\u660e\u8f93\u5165\u3001\u7ed3\u679c\u548c\u9650\u5236\u3002<\/p>\n

                    4.2 \u6ce8\u518c\u6587\u4ef6\u641c\u7d22\u5de5\u5177<\/h3>\n

                    server.<\/span>registerTool<\/span>(<\/span>
                    \n "search_files"<\/span>,<\/span>
                    \n {<\/span>
                    \n description:<\/span>
                    \n "Search text files under the configured project root. "<\/span> +<\/span>
                    \n "Returns relative paths, line numbers and short previews. "<\/span> +<\/span>
                    \n "This tool is read-only and cannot search outside the allowed root."<\/span>,<\/span>
                    \n inputSchema:<\/span> z.<\/span>object<\/span>(<\/span>{<\/span>
                    \n keyword:<\/span> z.<\/span>string<\/span>(<\/span>)<\/span>.<\/span>trim<\/span>(<\/span>)<\/span>.<\/span>min<\/span>(<\/span>2<\/span>)<\/span>.<\/span>max<\/span>(<\/span>100<\/span>)<\/span>,<\/span>
                    \n extensions:<\/span> z
                    \n .<\/span>array<\/span>(<\/span>z.<\/span>enum<\/span>(<\/span>[<\/span>"ts"<\/span>,<\/span> "tsx"<\/span>,<\/span> "js"<\/span>,<\/span> "mjs"<\/span>,<\/span> "json"<\/span>,<\/span> "md"<\/span>,<\/span> "yml"<\/span>,<\/span> "yaml"<\/span>]<\/span>)<\/span>)<\/span>
                    \n .<\/span>min<\/span>(<\/span>1<\/span>)<\/span>
                    \n .<\/span>max<\/span>(<\/span>8<\/span>)<\/span>
                    \n .<\/span>default<\/span>(<\/span>[<\/span>"ts"<\/span>,<\/span> "tsx"<\/span>,<\/span> "js"<\/span>,<\/span> "md"<\/span>]<\/span>)<\/span>,<\/span>
                    \n limit:<\/span> z.<\/span>number<\/span>(<\/span>)<\/span>.<\/span>int<\/span>(<\/span>)<\/span>.<\/span>min<\/span>(<\/span>1<\/span>)<\/span>.<\/span>max<\/span>(<\/span>50<\/span>)<\/span>.<\/span>default<\/span>(<\/span>20<\/span>)<\/span>
                    \n }<\/span>)<\/span>
                    \n }<\/span>,<\/span>
                    \n async<\/span> (<\/span>{<\/span> keyword,<\/span> extensions,<\/span> limit }<\/span>)<\/span> =><\/span> {<\/span>
                    \n try<\/span> {<\/span>
                    \n const<\/span> matches =<\/span> await<\/span> searchFiles<\/span>(<\/span>
                    \n config.<\/span>projectRoot,<\/span>
                    \n {<\/span> keyword,<\/span> extensions,<\/span> limit }<\/span>,<\/span>
                    \n config.<\/span>maxFileBytes
                    \n )<\/span>;<\/span><\/p>\n

                    const<\/span> text =<\/span>
                    \n matches.<\/span>length ===<\/span> 0<\/span>
                    \n ?<\/span> "No matches found."<\/span>
                    \n :<\/span> matches
                    \n .<\/span>map<\/span>(<\/span>
                    \n (<\/span>item)<\/span> =><\/span>
                    \n `<\/span>${<\/span>item.<\/span>file}<\/span><\/span>:<\/span>${<\/span>item.<\/span>line}<\/span><\/span>\\\\n<\/span>${<\/span>item.<\/span>preview}<\/span><\/span>`<\/span><\/span>
                    \n )<\/span>
                    \n .<\/span>join<\/span>(<\/span>"\\\\n\\\\n"<\/span>)<\/span>
                    \n .<\/span>slice<\/span>(<\/span>0<\/span>,<\/span> config.<\/span>maxReturnedCharacters)<\/span>;<\/span><\/p>\n

                    return<\/span> {<\/span>
                    \n content:<\/span> [<\/span>{<\/span> type:<\/span> "text"<\/span>,<\/span> text }<\/span>]<\/span>
                    \n }<\/span>;<\/span>
                    \n }<\/span> catch<\/span> (<\/span>error)<\/span> {<\/span>
                    \n const<\/span> message =<\/span>
                    \n error instanceof<\/span> Error<\/span> ?<\/span> error.<\/span>message :<\/span> "unknown search error"<\/span>;<\/span><\/p>\n

                    console<\/span>.<\/span>error<\/span>(<\/span>`<\/span>[search_files] <\/span>${<\/span>message}<\/span><\/span>`<\/span><\/span>)<\/span>;<\/span><\/p>\n

                    return<\/span> {<\/span>
                    \n isError:<\/span> true<\/span>,<\/span>
                    \n content:<\/span> [<\/span>
                    \n {<\/span>
                    \n type:<\/span> "text"<\/span>,<\/span>
                    \n text:<\/span> "File search failed. Check the configured root and file permissions."<\/span>
                    \n }<\/span>
                    \n ]<\/span>
                    \n }<\/span>;<\/span>
                    \n }<\/span>
                    \n }<\/span>
                    \n)<\/span>;<\/span><\/p>\n

                    \u8fd9\u91cc\u6545\u610f\u6ca1\u6709\u628a\u5b8c\u6574\u5806\u6808\u8fd4\u56de\u7ed9\u5ba2\u6237\u7aef\u3002<\/p>\n

                    \u5806\u6808\u53ef\u4ee5\u5199\u8fdb\u672c\u5730\u65e5\u5fd7，\u4f46\u5de5\u5177\u7ed3\u679c\u53ea\u9700\u8981\u544a\u8bc9\u6a21\u578b：<\/p>\n

                      \n
                    • \u4ec0\u4e48\u64cd\u4f5c\u5931\u8d25\u4e86；<\/li>\n
                    • \u7528\u6237\u53ef\u4ee5\u68c0\u67e5\u4ec0\u4e48；<\/li>\n
                    • \u662f\u5426\u53ef\u4ee5\u91cd\u8bd5\u3002<\/li>\n<\/ul>\n

                      \u628a\u672c\u673a\u7edd\u5bf9\u8def\u5f84\u3001\u4f9d\u8d56\u4f4d\u7f6e\u548c\u5185\u90e8\u5806\u6808\u5168\u90e8\u8fd4\u56de，\u4e0d\u4f46\u566a\u58f0\u5927，\u8fd8\u53ef\u80fd\u6cc4\u9732\u4e0d\u5fc5\u8981\u7684\u4fe1\u606f\u3002<\/p>\n

                      4.3 \u6ce8\u518c\u4efb\u52a1\u67e5\u8be2\u5de5\u5177<\/h3>\n

                      server.<\/span>registerTool<\/span>(<\/span>
                      \n "query_tasks"<\/span>,<\/span>
                      \n {<\/span>
                      \n description:<\/span>
                      \n "Read task records from the configured local SQLite database. "<\/span> +<\/span>
                      \n "Supports status and priority filters. This tool cannot modify data."<\/span>,<\/span>
                      \n inputSchema:<\/span> z.<\/span>object<\/span>(<\/span>{<\/span>
                      \n status:<\/span> z.<\/span>enum<\/span>(<\/span>[<\/span>"open"<\/span>,<\/span> "doing"<\/span>,<\/span> "closed"<\/span>]<\/span>)<\/span>.<\/span>optional<\/span>(<\/span>)<\/span>,<\/span>
                      \n priority:<\/span> z.<\/span>enum<\/span>(<\/span>[<\/span>"low"<\/span>,<\/span> "medium"<\/span>,<\/span> "high"<\/span>]<\/span>)<\/span>.<\/span>optional<\/span>(<\/span>)<\/span>,<\/span>
                      \n limit:<\/span> z.<\/span>number<\/span>(<\/span>)<\/span>.<\/span>int<\/span>(<\/span>)<\/span>.<\/span>min<\/span>(<\/span>1<\/span>)<\/span>.<\/span>max<\/span>(<\/span>30<\/span>)<\/span>.<\/span>default<\/span>(<\/span>10<\/span>)<\/span>
                      \n }<\/span>)<\/span>
                      \n }<\/span>,<\/span>
                      \n async<\/span> (<\/span>{<\/span> status,<\/span> priority,<\/span> limit }<\/span>)<\/span> =><\/span> {<\/span>
                      \n try<\/span> {<\/span>
                      \n const<\/span> tasks =<\/span> taskRepository.<\/span>find<\/span>(<\/span>{<\/span> status,<\/span> priority,<\/span> limit }<\/span>)<\/span>;<\/span><\/p>\n

                      return<\/span> {<\/span>
                      \n content:<\/span> [<\/span>
                      \n {<\/span>
                      \n type:<\/span> "text"<\/span>,<\/span>
                      \n text:<\/span>
                      \n tasks.<\/span>length ===<\/span> 0<\/span>
                      \n ?<\/span> "No tasks matched the filters."<\/span>
                      \n :<\/span> tasks
                      \n .<\/span>map<\/span>(<\/span>
                      \n (<\/span>task)<\/span> =><\/span>
                      \n `<\/span>${<\/span>task.<\/span>id}<\/span><\/span> | <\/span>${<\/span>task.<\/span>title}<\/span><\/span> | <\/span>`<\/span><\/span> +<\/span>
                      \n `<\/span>${<\/span>task.<\/span>status}<\/span><\/span> | <\/span>${<\/span>task.<\/span>priority}<\/span><\/span> | <\/span>${<\/span>task.<\/span>created_at}<\/span><\/span>`<\/span><\/span>
                      \n )<\/span>
                      \n .<\/span>join<\/span>(<\/span>"\\\\n"<\/span>)<\/span>
                      \n }<\/span>
                      \n ]<\/span>
                      \n }<\/span>;<\/span>
                      \n }<\/span> catch<\/span> (<\/span>error)<\/span> {<\/span>
                      \n const<\/span> message =<\/span>
                      \n error instanceof<\/span> Error<\/span> ?<\/span> error.<\/span>message :<\/span> "unknown database error"<\/span>;<\/span><\/p>\n

                      console<\/span>.<\/span>error<\/span>(<\/span>`<\/span>[query_tasks] <\/span>${<\/span>message}<\/span><\/span>`<\/span><\/span>)<\/span>;<\/span><\/p>\n

                      return<\/span> {<\/span>
                      \n isError:<\/span> true<\/span>,<\/span>
                      \n content:<\/span> [<\/span>
                      \n {<\/span>
                      \n type:<\/span> "text"<\/span>,<\/span>
                      \n text:<\/span> "Task query failed. Check database existence and read permission."<\/span>
                      \n }<\/span>
                      \n ]<\/span>
                      \n }<\/span>;<\/span>
                      \n }<\/span>
                      \n }<\/span>
                      \n)<\/span>;<\/span><\/p>\n

                      4.4 \u8fde\u63a5 stdio<\/h3>\n

                      async<\/span> function<\/span> main<\/span>(<\/span>)<\/span>:<\/span> Promise<\/span><<\/span>void<\/span>><\/span> {<\/span>
                      \n const<\/span> transport =<\/span> new<\/span> StdioServerTransport<\/span>(<\/span>)<\/span>;<\/span>
                      \n await<\/span> server.<\/span>connect<\/span>(<\/span>transport)<\/span>;<\/span>
                      \n console<\/span>.<\/span>error<\/span>(<\/span>"[mcp-local-lab] connected through stdio"<\/span>)<\/span>;<\/span>
                      \n}<\/span><\/p>\n

                      async<\/span> function<\/span> shutdown<\/span>(<\/span>signal:<\/span> string<\/span>)<\/span>:<\/span> Promise<\/span><<\/span>void<\/span>><\/span> {<\/span>
                      \n console<\/span>.<\/span>error<\/span>(<\/span>`<\/span>[mcp-local-lab] received <\/span>${<\/span>signal}<\/span><\/span>`<\/span><\/span>)<\/span>;<\/span>
                      \n taskRepository.<\/span>close<\/span>(<\/span>)<\/span>;<\/span>
                      \n process.<\/span>exit<\/span>(<\/span>0<\/span>)<\/span>;<\/span>
                      \n}<\/span><\/p>\n

                      process.<\/span>on<\/span>(<\/span>"SIGINT"<\/span>,<\/span> (<\/span>)<\/span> =><\/span> void<\/span> shutdown<\/span>(<\/span>"SIGINT"<\/span>)<\/span>)<\/span>;<\/span>
                      \nprocess.<\/span>on<\/span>(<\/span>"SIGTERM"<\/span>,<\/span> (<\/span>)<\/span> =><\/span> void<\/span> shutdown<\/span>(<\/span>"SIGTERM"<\/span>)<\/span>)<\/span>;<\/span><\/p>\n

                      main<\/span>(<\/span>)<\/span>.<\/span>catch<\/span>(<\/span>(<\/span>error)<\/span> =><\/span> {<\/span>
                      \n console<\/span>.<\/span>error<\/span>(<\/span>"[mcp-local-lab] fatal error"<\/span>,<\/span> error)<\/span>;<\/span>
                      \n process.<\/span>exit<\/span>(<\/span>1<\/span>)<\/span>;<\/span>
                      \n}<\/span>)<\/span>;<\/span><\/p>\n

                      \u81f3\u6b64，\u4e24\u4e2a\u5de5\u5177\u5df2\u7ecf\u6ce8\u518c\u5b8c\u6210\u3002<\/p>\n

                      \"MCP<\/p>\n

                      \u8fd9\u662f\u672c\u6587\u81ea\u5efa\u6848\u4f8b\u7684\u793a\u4f8b\u8f93\u51fa\u3002\u771f\u5b9e\u9879\u76ee\u4e2d\u7684\u6587\u4ef6\u6570\u91cf\u548c\u8017\u65f6\u4f1a\u968f\u76ee\u5f55\u89c4\u6a21\u53d8\u5316，\u6392\u67e5\u65f6\u66f4\u5e94\u8be5\u5173\u6ce8\u5de5\u5177\u662f\u5426\u53ea\u8fd4\u56de\u5141\u8bb8\u8303\u56f4\u5185\u7684\u8def\u5f84\u548c\u5b57\u6bb5\u3002<\/p>\n

                      \n

                      \u6700\u540e\u518d\u63d0\u9192\u4e00\u4e2a\u5f88\u9690\u853d\u7684\u5751：\u4f7f\u7528 stdio \u65f6，\u6807\u51c6\u8f93\u51fa\u672c\u8eab\u5c31\u662f\u534f\u8bae\u901a\u9053\u3002\u666e\u901a\u65e5\u5fd7\u6df7\u8fdb stdout，\u5ba2\u6237\u7aef\u8bfb\u5230\u7684\u5c31\u4e0d\u518d\u662f\u5b8c\u6574\u534f\u8bae\u6d88\u606f\u3002<\/p>\n

                      \"MCP<\/p>\n

                      \u8c03\u8bd5\u65e5\u5fd7\u5199\u5230 stderr，\u534f\u8bae\u6d88\u606f\u7559\u5728 stdout\u3002\u8fd9\u4e2a\u4e60\u60ef\u770b\u8d77\u6765\u4e0d\u8d77\u773c，\u5b9e\u9645\u80fd\u7701\u6389\u4e0d\u5c11\u201c\u5de5\u5177\u660e\u660e\u6ce8\u518c\u4e86，\u5ba2\u6237\u7aef\u5374\u7a81\u7136\u65ad\u5f00\u201d\u7684\u6392\u67e5\u65f6\u95f4\u3002<\/p>\n

                      \u603b\u7ed3<\/h2>\n

                      \u5199\u5b8c\u4e86\u3002\u4e24\u4e2a\u5de5\u5177\u2014\u2014\u6587\u4ef6\u641c\u7d22\u548c\u4efb\u52a1\u67e5\u8be2\u2014\u2014\u4ee3\u7801\u672c\u8eab\u4e0d\u590d\u6742，\u771f\u6b63\u82b1\u65f6\u95f4\u7684\u662f\u8fb9\u754c\u3002<\/p>\n

                    • \u6839\u76ee\u5f55\u7531\u670d\u52a1\u7aef\u914d\u7f6e，\u4e0d\u7531\u6a21\u578b\u51b3\u5b9a；<\/li>\n
                    • \u6587\u4ef6\u641c\u7d22\u9650\u5236\u6269\u5c55\u540d\u3001\u5927\u5c0f\u548c\u8fd4\u56de\u6570\u91cf；<\/li>\n
                    • \u6570\u636e\u5e93\u53ea\u8bfb\u6253\u5f00，\u4e0d\u63a5\u6536\u4efb\u610f SQL；<\/li>\n
                    • \u6240\u6709\u53c2\u6570\u7ecf\u8fc7 Schema \u548c\u4e1a\u52a1\u903b\u8f91\u53cc\u91cd\u6821\u9a8c；<\/li>\n
                    • stdio \u65e5\u5fd7\u5199\u5165 stderr；<\/li>\n
                    • \u9519\u8bef\u7ed3\u679c\u80fd\u5224\u65ad，\u4f46\u4e0d\u66b4\u9732\u5185\u90e8\u7ec6\u8282；<\/li>\n
                    • \u6d4b\u8bd5\u4e0d\u5149\u8dd1\u6b63\u5e38\u8def\u5f84，\u8d8a\u754c\u3001\u5931\u8d25\u548c\u5ba2\u6237\u7aef\u884c\u4e3a\u90fd\u8981\u8fc7\u4e00\u904d\u3002<\/li>\n

                      MCP \u6700\u6709\u4ef7\u503c\u7684\u5730\u65b9\u4e0d\u662f\u8ba9 AI \u201c\u4ec0\u4e48\u90fd\u80fd\u8c03\u201d，\u662f\u80fd\u8ba9\u6211\u4eec\u628a\u80fd\u529b\u62c6\u6210\u4e00\u4e2a\u4e2a\u8fb9\u754c\u660e\u786e\u7684\u5de5\u5177\u3002\u5de5\u5177\u591a\u4e86\u53cd\u800c\u66f4\u8981\u5199\u6e05\u695a：\u5141\u8bb8\u8303\u56f4\u3001\u6821\u9a8c\u8bc1\u636e\u3001\u5931\u8d25\u65b9\u5f0f\u3002<\/p>\n

                      \u540e\u9762\u5982\u679c\u7ee7\u7eed\u6269\u5c55，\u53ef\u4ee5\u589e\u52a0：<\/p>\n

                        \n
                      • \u9879\u76ee\u6784\u5efa\u7ed3\u679c\u8bfb\u53d6；<\/li>\n
                      • Git diff \u6458\u8981；<\/li>\n
                      • \u6d4b\u8bd5\u62a5\u544a\u67e5\u8be2；<\/li>\n
                      • \u53ea\u8bfb\u65e5\u5fd7\u5206\u6790；<\/li>\n
                      • \u5148\u751f\u6210\u8865\u4e01\u3001\u786e\u8ba4\u540e\u518d\u5199\u5165\u7684\u914d\u7f6e\u4fee\u6539\u3002<\/li>\n<\/ul>\n

                        \u4f46\u4e0d\u7ba1\u52a0\u4ec0\u4e48\u5de5\u5177，\u5148\u60f3\u6e05\u695a\u4e09\u4ef6\u4e8b：<\/p>\n

                        \u5b83\u80fd\u8bfb\u4ec0\u4e48？
                        \n\u5b83\u80fd\u6539\u4ec0\u4e48？
                        \n\u5b83\u5931\u8d25\u540e\u4f1a\u7559\u4e0b\u4ec0\u4e48？<\/p>\n

                        \n

                        \u53c2\u8003\u8d44\u6599<\/h2>\n
                          \n
                        • \n

                          MCP \u5b98\u65b9：Build an MCP server https:\/\/modelcontextprotocol.io\/docs\/develop\/build-server<\/p>\n<\/li>\n

                        • \n

                          MCP \u5b98\u65b9 TypeScript SDK https:\/\/github.com\/modelcontextprotocol\/typescript-sdk<\/p>\n<\/li>\n

                        • \n

                          MCP TypeScript SDK Server Guide https:\/\/github.com\/modelcontextprotocol\/typescript-sdk\/blob\/main\/docs\/server.md<\/p>\n<\/li>\n

                        • \n

                          MCP TypeScript SDK v1 \u2192 v2 Migration Guide https:\/\/github.com\/modelcontextprotocol\/typescript-sdk\/blob\/main\/docs\/migration.md<\/p>\n<\/li>\n

                        • \n

                          Node.js SQLite \u6587\u6863 https:\/\/nodejs.org\/api\/sqlite.html<\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

                          🔥\u4e2a\u4eba\u4e3b\u9875：\u7231\u548c\u51b0\u9614\u4e50 📚\u4e13\u680f\u4f20\u9001\u95e8：\u300a\u6570\u636e\u7ed3\u6784\u4e0e\u7b97\u6cd5\u300b \u3001C 🐶\u5b66\u4e60\u65b9\u5411：C\u65b9\u5411\u5b66\u4e60\u7231\u597d\u8005 \u2b50\u4eba\u751f\u683c\u8a00：\u5f97\u77e5\u5766\u7136 ，\u5931\u4e4b\u6de1\u7136 🏠\u535a\u4e3b\u7b80\u4ecb \u6587\u7ae0\u76ee\u5f55\u524d\u8a00\u4e00\u3001\u521d\u59cb\u5316 TypeScript MCP \u9879\u76ee1.1 \u73af\u5883\u68c0\u67e51.2 TypeScript \u914d\u7f6e\u4e8c\u3001\u5b9e\u73b0\u5b89\u5168\u7684\u6587\u4ef6\u641c\u7d22\u5de5\u51772.1 \u5148\u5b9a\u4e49\u7ed3\u679c\u7ed3\u67842.2 \u8def\u5f84\u6821\u9a8c\u4e0d\u80fd\u53ea\u7528 startsWith<\/p>\n","protected":false},"author":2,"featured_media":88835,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[2547,61,43],"topic":[],"class_list":["post-88844","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-sqlite","tag-61","tag-43"],"yoast_head":"\n\u3010MCP\u5b9e\u6218\u3011\u4ece0\u5199\u4e00\u4e2a\u672c\u5730\u5de5\u5177\u670d\u52a1\u5668\uff1a\u6587\u4ef6\u641c\u7d22\u3001SQLite\u67e5\u8be2\u4e0e\u5b89\u5168\u8fb9\u754c - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/88844.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u3010MCP\u5b9e\u6218\u3011\u4ece0\u5199\u4e00\u4e2a\u672c\u5730\u5de5\u5177\u670d\u52a1\u5668\uff1a\u6587\u4ef6\u641c\u7d22\u3001SQLite\u67e5\u8be2\u4e0e\u5b89\u5168\u8fb9\u754c - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"🔥\u4e2a\u4eba\u4e3b\u9875：\u7231\u548c\u51b0\u9614\u4e50 📚\u4e13\u680f\u4f20\u9001\u95e8：\u300a\u6570\u636e\u7ed3\u6784\u4e0e\u7b97\u6cd5\u300b \u3001C 🐶\u5b66\u4e60\u65b9\u5411：C\u65b9\u5411\u5b66\u4e60\u7231\u597d\u8005 \u2b50\u4eba\u751f\u683c\u8a00：\u5f97\u77e5\u5766\u7136 ，\u5931\u4e4b\u6de1\u7136 🏠\u535a\u4e3b\u7b80\u4ecb \u6587\u7ae0\u76ee\u5f55\u524d\u8a00\u4e00\u3001\u521d\u59cb\u5316 TypeScript MCP \u9879\u76ee1.1 \u73af\u5883\u68c0\u67e51.2 TypeScript \u914d\u7f6e\u4e8c\u3001\u5b9e\u73b0\u5b89\u5168\u7684\u6587\u4ef6\u641c\u7d22\u5de5\u51772.1 \u5148\u5b9a\u4e49\u7ed3\u679c\u7ed3\u67842.2 \u8def\u5f84\u6821\u9a8c\u4e0d\u80fd\u53ea\u7528 startsWith\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/88844.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-08-01T12:49:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260801124921-6a6deb51b0e88.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/88844.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/88844.html\",\"name\":\"\u3010MCP\u5b9e\u6218\u3011\u4ece0\u5199\u4e00\u4e2a\u672c\u5730\u5de5\u5177\u670d\u52a1\u5668\uff1a\u6587\u4ef6\u641c\u7d22\u3001SQLite\u67e5\u8be2\u4e0e\u5b89\u5168\u8fb9\u754c - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-08-01T12:49:28+00:00\",\"dateModified\":\"2026-08-01T12:49:28+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/88844.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/88844.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/88844.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u3010MCP\u5b9e\u6218\u3011\u4ece0\u5199\u4e00\u4e2a\u672c\u5730\u5de5\u5177\u670d\u52a1\u5668\uff1a\u6587\u4ef6\u641c\u7d22\u3001SQLite\u67e5\u8be2\u4e0e\u5b89\u5168\u8fb9\u754c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u3010MCP\u5b9e\u6218\u3011\u4ece0\u5199\u4e00\u4e2a\u672c\u5730\u5de5\u5177\u670d\u52a1\u5668\uff1a\u6587\u4ef6\u641c\u7d22\u3001SQLite\u67e5\u8be2\u4e0e\u5b89\u5168\u8fb9\u754c - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/88844.html","og_locale":"zh_CN","og_type":"article","og_title":"\u3010MCP\u5b9e\u6218\u3011\u4ece0\u5199\u4e00\u4e2a\u672c\u5730\u5de5\u5177\u670d\u52a1\u5668\uff1a\u6587\u4ef6\u641c\u7d22\u3001SQLite\u67e5\u8be2\u4e0e\u5b89\u5168\u8fb9\u754c - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"🔥\u4e2a\u4eba\u4e3b\u9875：\u7231\u548c\u51b0\u9614\u4e50 📚\u4e13\u680f\u4f20\u9001\u95e8：\u300a\u6570\u636e\u7ed3\u6784\u4e0e\u7b97\u6cd5\u300b \u3001C 🐶\u5b66\u4e60\u65b9\u5411：C\u65b9\u5411\u5b66\u4e60\u7231\u597d\u8005 \u2b50\u4eba\u751f\u683c\u8a00：\u5f97\u77e5\u5766\u7136 ，\u5931\u4e4b\u6de1\u7136 🏠\u535a\u4e3b\u7b80\u4ecb \u6587\u7ae0\u76ee\u5f55\u524d\u8a00\u4e00\u3001\u521d\u59cb\u5316 TypeScript MCP \u9879\u76ee1.1 \u73af\u5883\u68c0\u67e51.2 TypeScript \u914d\u7f6e\u4e8c\u3001\u5b9e\u73b0\u5b89\u5168\u7684\u6587\u4ef6\u641c\u7d22\u5de5\u51772.1 \u5148\u5b9a\u4e49\u7ed3\u679c\u7ed3\u67842.2 \u8def\u5f84\u6821\u9a8c\u4e0d\u80fd\u53ea\u7528 startsWith","og_url":"https:\/\/www.wsisp.com\/helps\/88844.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-08-01T12:49:28+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260801124921-6a6deb51b0e88.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"8 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/88844.html","url":"https:\/\/www.wsisp.com\/helps\/88844.html","name":"\u3010MCP\u5b9e\u6218\u3011\u4ece0\u5199\u4e00\u4e2a\u672c\u5730\u5de5\u5177\u670d\u52a1\u5668\uff1a\u6587\u4ef6\u641c\u7d22\u3001SQLite\u67e5\u8be2\u4e0e\u5b89\u5168\u8fb9\u754c - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-08-01T12:49:28+00:00","dateModified":"2026-08-01T12:49:28+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/88844.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/88844.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/88844.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u3010MCP\u5b9e\u6218\u3011\u4ece0\u5199\u4e00\u4e2a\u672c\u5730\u5de5\u5177\u670d\u52a1\u5668\uff1a\u6587\u4ef6\u641c\u7d22\u3001SQLite\u67e5\u8be2\u4e0e\u5b89\u5168\u8fb9\u754c"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/88844","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=88844"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/88844\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/88835"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=88844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=88844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=88844"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=88844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}