{"_id":"@5shuang/mcp-postgres-server","name":"@5shuang/mcp-postgres-server","dist-tags":{"latest":"1.0.0"},"versions":{"1.0.0":{"name":"@5shuang/mcp-postgres-server","version":"1.0.0","description":"MCP服务器，用于操作PostgreSQL数据库","main":"build/index.js","type":"module","bin":{"mcp-postgres-server":"build/index.js"},"scripts":{"build":"tsc && node -e \"require('fs').chmodSync('build/index.js', '755')\"","start":"node build/index.js","dev":"tsx src/index.ts","prepublishOnly":"npm run build"},"keywords":["mcp","postgres","postgresql","database","model-context-protocol","claude"],"author":"","license":"MIT","repository":{"type":"git","url":"git+https://github.com/yourusername/mcp-postgres-server.git"},"homepage":"https://github.com/yourusername/mcp-postgres-server#readme","devDependencies":{"@types/node":"^22.10.0","@types/pg":"^8.10.9","@types/uuid":"^9.0.8","tsx":"^4.7.0","typescript":"^5.7.2"},"dependencies":{"@modelcontextprotocol/sdk":"^1.4.0","pg":"^8.11.3","uuid":"^9.0.1","zod":"^3.22.4"},"engines":{"node":">=16.0.0"},"_id":"@5shuang/mcp-postgres-server@1.0.0","gitHead":"dfc92478e2b7087dfb369ad36695e8b9ff459f3f","bugs":{"url":"https://github.com/yourusername/mcp-postgres-server/issues"},"_nodeVersion":"18.20.3","_npmVersion":"10.7.0","dist":{"integrity":"sha512-zL9uJMou8QGXlBL3hnbyuH82DkPXUuuw8TaVGFdBTD2QFhEmp0pcLTw7sSaFpp/qGigb8Thwf6Gb8Ulz+0Y0ew==","shasum":"a5787f5380ab0d52f2d48aa988562271153d55a3","tarball":"https://registry.npmjs.org/@5shuang/mcp-postgres-server/-/mcp-postgres-server-1.0.0.tgz","fileCount":4,"unpackedSize":14793,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIFlcIE+IAnEL9StdKa35VhXX315gGRK1V3ETyMwOQuuwAiEAxUgPFbOP4JKrvB9xb4tLGP4qSB0hcGxgieKb2uAJO6Y="}]},"_npmUser":{"name":"5shuang","email":"nextw3@gmail.com"},"directories":{},"maintainers":[{"name":"5shuang","email":"nextw3@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/mcp-postgres-server_1.0.0_1743584433381_0.8144945144713094"},"_hasShrinkwrap":false}},"time":{"created":"2025-04-02T09:00:33.301Z","1.0.0":"2025-04-02T09:00:33.571Z","modified":"2025-04-02T09:00:33.873Z"},"maintainers":[{"name":"5shuang","email":"nextw3@gmail.com"}],"description":"MCP服务器，用于操作PostgreSQL数据库","homepage":"https://github.com/yourusername/mcp-postgres-server#readme","keywords":["mcp","postgres","postgresql","database","model-context-protocol","claude"],"repository":{"type":"git","url":"git+https://github.com/yourusername/mcp-postgres-server.git"},"bugs":{"url":"https://github.com/yourusername/mcp-postgres-server/issues"},"license":"MIT","readme":"# MCP Postgres Server\r\n\r\n这是一个Model Context Protocol (MCP)服务器，用于连接和操作PostgreSQL数据库。\r\n\r\n## 功能\r\n\r\n- 执行SQL查询语句并获取结果\r\n- 执行数据插入、更新和删除操作\r\n- 获取数据库结构信息（表、列、索引等）\r\n- 安全连接到远程PostgreSQL数据库\r\n\r\n## 安装\r\n\r\n```bash\r\n# 全局安装\r\nnpm install -g @5shuang/mcp-postgres-server\r\n\r\n# 或者通过npx直接运行（无需安装）\r\nnpx @5shuang/mcp-postgres-server\r\n```\r\n\r\n## 与Claude for Desktop集成\r\n\r\n在Claude for Desktop配置文件中添加以下内容：\r\n\r\n```json\r\n{\r\n  \"mcpServers\": {\r\n    \"postgres\": {\r\n      \"command\": \"npx\",\r\n      \"args\": [\r\n        \"-y\",\r\n        \"@5shuang/mcp-postgres-server\"\r\n      ]\r\n    }\r\n  }\r\n}\r\n```\r\n\r\n### 配置文件位置：\r\n\r\n- Windows: `%APPDATA%\\\\Claude\\\\claude_desktop_config.json`\r\n- macOS: `~/Library/Application Support/Claude/claude_desktop_config.json`\r\n\r\n## 与Cursor IDE集成\r\n\r\n1. 在Cursor IDE中安装Claude AI扩展\r\n2. 创建或编辑Cursor配置文件，添加以下内容：\r\n\r\n```json\r\n{\r\n  \"mcpServers\": {\r\n    \"postgres\": {\r\n      \"command\": \"npx\",\r\n      \"args\": [\r\n        \"-y\",\r\n        \"@your-username/mcp-postgres-server\"\r\n      ]\r\n    }\r\n  }\r\n}\r\n```\r\n\r\n### Cursor配置文件位置：\r\n\r\n- Windows: `%APPDATA%\\\\Cursor\\\\config.json` \r\n- macOS: `~/Library/Application Support/Cursor/config.json`\r\n\r\n## 可用工具\r\n\r\nMCP服务器提供以下工具：\r\n\r\n- `execute-query`: 执行SQL查询并返回结果\r\n- `execute-mutation`: 执行SQL修改操作(INSERT/UPDATE/DELETE)\r\n- `get-schema-info`: 获取数据库结构信息\r\n\r\n## 开发\r\n\r\n```bash\r\n# 安装依赖\r\nnpm install\r\n\r\n# 构建项目\r\nnpm run build\r\n\r\n# 启动服务器\r\nnpm start\r\n```\r\n\r\n## 许可证\r\n\r\nMIT ","readmeFilename":"README.md","_rev":"1-c9b24ba5c43ea9aff06359b7e2c2d6da"}