{"versions":{"0.1.0":{"name":"@modelcontextprotocol/server-postgres","version":"0.1.0","description":"MCP server for interacting with PostgreSQL databases","license":"MIT","author":{"name":"Anthropic, PBC","url":"https://anthropic.com"},"homepage":"https://modelcontextprotocol.io","bugs":{"url":"https://github.com/modelcontextprotocol/servers/issues"},"type":"module","bin":{"mcp-server-postgres":"dist/index.js"},"scripts":{"build":"tsc && shx chmod +x dist/*.js","prepare":"npm run build","watch":"tsc --watch"},"dependencies":{"@modelcontextprotocol/sdk":"0.5.0","pg":"^8.13.0"},"devDependencies":{"@types/pg":"^8.11.10","shx":"^0.3.4","typescript":"^5.6.2"},"_id":"@modelcontextprotocol/server-postgres@0.1.0","gitHead":"3044d818d91102c0d8c855edc1ad5fc270dce5d2","_nodeVersion":"18.20.4","_npmVersion":"10.7.0","dist":{"integrity":"sha512-L8a40mXNKSbaksbar24+sC+5GlNp9Lj353QtHOz5tr19a25SnD45e0JK6AHffOzP3fPRhQVGHFhlmwyAJVmIkQ==","shasum":"008df1362ff64938cbc03a15b6d61ce830964834","tarball":"http://123.232.10.234:8212/nexus/content/groups/npm-public/@modelcontextprotocol/server-postgres/-/server-postgres-0.1.0.tgz","fileCount":3,"unpackedSize":4677,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCYGg+baXXVuiG0RYvleg9EKeXB8Zbl4D7fcf2++lkDEQIgacjxwMhYqhdYGLA6PlMUPFRS9wdeJZw8V4mN1j+XvOo="}],"size":1792},"_npmUser":{"name":"anonymous","email":"justin@jspahrsummers.com"},"directories":{},"maintainers":[{"name":"anonymous","email":"experimentalworks@gmail.com"},{"name":"anonymous","email":"justin@jspahrsummers.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/server-postgres_0.1.0_1732025676658_0.8323533843080317"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2024-11-19T14:14:36.814Z","publish_time":1732025676814,"_source_registry_name":"default","contributors":[]},"0.2.0":{"name":"@modelcontextprotocol/server-postgres","version":"0.2.0","description":"MCP server for interacting with PostgreSQL databases","license":"MIT","author":{"name":"Anthropic, PBC","url":"https://anthropic.com"},"homepage":"https://modelcontextprotocol.io","bugs":{"url":"https://github.com/modelcontextprotocol/servers/issues"},"type":"module","bin":{"mcp-server-postgres":"dist/index.js"},"scripts":{"build":"tsc && shx chmod +x dist/*.js","prepare":"npm run build","watch":"tsc --watch"},"dependencies":{"@modelcontextprotocol/sdk":"0.6.0","pg":"^8.13.0"},"devDependencies":{"@types/pg":"^8.11.10","shx":"^0.3.4","typescript":"^5.6.2"},"_id":"@modelcontextprotocol/server-postgres@0.2.0","gitHead":"3d6de8673069bbb5d0418cd0db9b2fd81a53769d","_nodeVersion":"18.20.5","_npmVersion":"10.8.2","dist":{"integrity":"sha512-wxllw5Fuuj5kUZCNHLnkVCCIaC4MPEBOEQDXLX96fJqCG71ZnVCaXOgd4rYd9w0eH8kiPBq0FN/e5XrpsCUP6Q==","shasum":"6b243b6e25ff670d6b9dbd918c9a9e8654481831","tarball":"http://123.232.10.234:8212/nexus/content/groups/npm-public/@modelcontextprotocol/server-postgres/-/server-postgres-0.2.0.tgz","fileCount":3,"unpackedSize":5579,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCVQlDBHT8uhaYpvOLo8fUjwnEYRDSpXMU4mFTYl4DoTQIhALVpVqLyNfCXO0FlySCEDBqD6Q/CZCCQa+kybK3lixrx"}],"size":2190},"_npmUser":{"name":"anonymous","email":"justin@jspahrsummers.com"},"directories":{},"maintainers":[{"name":"anonymous","email":"ashwin@anthropic.com"},{"name":"anonymous","email":"experimentalworks@gmail.com"},{"name":"anonymous","email":"justin@jspahrsummers.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/server-postgres_0.2.0_1732216525074_0.9838231324302125"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2024-11-21T19:15:25.223Z","publish_time":1732216525223,"_source_registry_name":"default","contributors":[]},"0.3.0":{"name":"@modelcontextprotocol/server-postgres","version":"0.3.0","description":"MCP server for interacting with PostgreSQL databases","license":"MIT","author":{"name":"Anthropic, PBC","url":"https://anthropic.com"},"homepage":"https://modelcontextprotocol.io","bugs":{"url":"https://github.com/modelcontextprotocol/servers/issues"},"type":"module","bin":{"mcp-server-postgres":"dist/index.js"},"scripts":{"build":"tsc && shx chmod +x dist/*.js","prepare":"npm run build","watch":"tsc --watch"},"dependencies":{"@modelcontextprotocol/sdk":"0.6.0","pg":"^8.13.0"},"devDependencies":{"@types/pg":"^8.11.10","shx":"^0.3.4","typescript":"^5.6.2"},"_id":"@modelcontextprotocol/server-postgres@0.3.0","gitHead":"fe4f568fd011f9cbc8b7501e10117b7106bea84f","_nodeVersion":"18.20.5","_npmVersion":"10.8.2","dist":{"integrity":"sha512-OOKSvRTHRpTOeQWYpAMGvuNOgq81e32y3dy9GdIPBlyWfrcvSaij8wb/E6nrA/cB2KUFXgs1kPtCWqIm50zPPQ==","shasum":"393a2b6399c8c31ddf5abfd8441203b6856820fd","tarball":"http://123.232.10.234:8212/nexus/content/groups/npm-public/@modelcontextprotocol/server-postgres/-/server-postgres-0.3.0.tgz","fileCount":3,"unpackedSize":5622,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDB86krgSNnn++g0z6+3aQA6+QuO+4po9mPfRUJypLTvAIhAPZR/Hyuh/1+rl/jmMRueMML1bxXx9CxiN2IHXoFdBuD"}],"size":2202},"_npmUser":{"name":"anonymous","email":"justin@jspahrsummers.com"},"directories":{},"maintainers":[{"name":"anonymous","email":"ashwin@anthropic.com"},{"name":"anonymous","email":"experimentalworks@gmail.com"},{"name":"anonymous","email":"justin@jspahrsummers.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/server-postgres_0.3.0_1732228664513_0.12859228417725443"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2024-11-21T22:37:44.735Z","publish_time":1732228664735,"_source_registry_name":"default","contributors":[]},"0.5.0":{"name":"@modelcontextprotocol/server-postgres","version":"0.5.0","description":"MCP server for interacting with PostgreSQL databases","license":"MIT","author":{"name":"Anthropic, PBC","url":"https://anthropic.com"},"homepage":"https://modelcontextprotocol.io","bugs":{"url":"https://github.com/modelcontextprotocol/servers/issues"},"type":"module","bin":{"mcp-server-postgres":"dist/index.js"},"scripts":{"build":"tsc && shx chmod +x dist/*.js","prepare":"npm run build","watch":"tsc --watch"},"dependencies":{"@modelcontextprotocol/sdk":"0.6.0","pg":"^8.13.0"},"devDependencies":{"@types/pg":"^8.11.10","shx":"^0.3.4","typescript":"^5.6.2"},"_id":"@modelcontextprotocol/server-postgres@0.5.0","gitHead":"45c4f70da468e2d81b9efe0d736b49efde1b9263","_nodeVersion":"18.20.5","_npmVersion":"10.8.2","dist":{"integrity":"sha512-MDC0Up69C89QopUYO9duDy9OBvpgaCvxdHS0lI2fsQDUX5jMmokAFRziKgmTsKtJXYlwjEaANUkt+s/VVszB9w==","shasum":"bf8cf1d3af20f0f045cb3e02c19ebccf164107bc","tarball":"http://123.232.10.234:8212/nexus/content/groups/npm-public/@modelcontextprotocol/server-postgres/-/server-postgres-0.5.0.tgz","fileCount":3,"unpackedSize":5875,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIGY7Sr338sPJODjxA9CJ506y6m0uclaC2iL2n6GyLshzAiEA53/A4X6Ine8iOFi69ulT8Yq/R0C2tRJGM7DalbMg9cQ="}],"size":2329},"_npmUser":{"name":"anonymous","email":"justin@jspahrsummers.com"},"directories":{},"maintainers":[{"name":"anonymous","email":"justin@jspahrsummers.com"},{"name":"anonymous","email":"experimentalworks@gmail.com"},{"name":"anonymous","email":"ashwin@anthropic.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/server-postgres_0.5.0_1732540641241_0.42699707502427997"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2024-11-25T13:17:21.422Z","publish_time":1732540641422,"_source_registry_name":"default","contributors":[]},"0.5.1":{"name":"@modelcontextprotocol/server-postgres","version":"0.5.1","description":"MCP server for interacting with PostgreSQL databases","license":"MIT","author":{"name":"Anthropic, PBC","url":"https://anthropic.com"},"homepage":"https://modelcontextprotocol.io","bugs":{"url":"https://github.com/modelcontextprotocol/servers/issues"},"type":"module","bin":{"mcp-server-postgres":"dist/index.js"},"scripts":{"build":"tsc && shx chmod +x dist/*.js","prepare":"npm run build","watch":"tsc --watch"},"dependencies":{"@modelcontextprotocol/sdk":"0.6.0","pg":"^8.13.0"},"devDependencies":{"@types/pg":"^8.11.10","shx":"^0.3.4","typescript":"^5.6.2"},"_id":"@modelcontextprotocol/server-postgres@0.5.1","gitHead":"0da25bea8720c8162895f3222b46abb0c96c7a81","_nodeVersion":"18.20.5","_npmVersion":"10.8.2","dist":{"integrity":"sha512-f0+DgT7Go/EuFst8Sz03bfDAFv9RFAYGSqFaKWtbo04sQG8FYFwjTqscVk977Xu7FQd00vmYsis2EbHQVRKmcQ==","shasum":"258165eef93c4a9e3b9b50da9d0db9fa6cb056dd","tarball":"http://123.232.10.234:8212/nexus/content/groups/npm-public/@modelcontextprotocol/server-postgres/-/server-postgres-0.5.1.tgz","fileCount":3,"unpackedSize":5875,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIFIvk9salT2RdYiXRUoSrYA/SGHfK2hfB5RTCXeudMuSAiEA0lzvztU6LWjc4LQe0IfxOZvJ/SqiELefLjXBDCPhH5Y="}],"size":2327},"_npmUser":{"name":"anonymous","email":"justin@jspahrsummers.com"},"directories":{},"maintainers":[{"name":"anonymous","email":"justin@jspahrsummers.com"},{"name":"anonymous","email":"experimentalworks@gmail.com"},{"name":"anonymous","email":"ashwin@anthropic.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/server-postgres_0.5.1_1732564720610_0.06006585778050222"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2024-11-25T19:58:40.762Z","publish_time":1732564720762,"_source_registry_name":"default","contributors":[]},"0.6.0":{"name":"@modelcontextprotocol/server-postgres","version":"0.6.0","description":"MCP server for interacting with PostgreSQL databases","license":"MIT","author":{"name":"Anthropic, PBC","url":"https://anthropic.com"},"homepage":"https://modelcontextprotocol.io","bugs":{"url":"https://github.com/modelcontextprotocol/servers/issues"},"type":"module","bin":{"mcp-server-postgres":"dist/index.js"},"scripts":{"build":"tsc && shx chmod +x dist/*.js","prepare":"npm run build","watch":"tsc --watch"},"dependencies":{"@modelcontextprotocol/sdk":"1.0.1","pg":"^8.13.0"},"devDependencies":{"@types/pg":"^8.11.10","shx":"^0.3.4","typescript":"^5.6.2"},"_id":"@modelcontextprotocol/server-postgres@0.6.0","gitHead":"129d80af313c6c0ad9a929f4923c6d8a07d6a9e5","_nodeVersion":"18.20.5","_npmVersion":"10.8.2","dist":{"integrity":"sha512-34mH+yx3DqoV3ohA7EnhacWwKfrt/la1NtImR8OMcohi+vZriME2nxcAcm3jr5ks4NyhlQI64Z5xFf/ad6qBeA==","shasum":"d00bf299231e06f1f55a73effa3302ccc60cce74","tarball":"http://123.232.10.234:8212/nexus/content/groups/npm-public/@modelcontextprotocol/server-postgres/-/server-postgres-0.6.0.tgz","fileCount":3,"unpackedSize":5937,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCUh6PCOnK1bBlgsu27LidXvvIvIqeKUrmdnIl7K4EPBQIgf17CSeJjOzRgI67vmN6xz+BQd6RfhhJBBlYlDUMjwiU="}],"size":2341},"_npmUser":{"name":"anonymous","email":"justin@jspahrsummers.com"},"directories":{},"maintainers":[{"name":"anonymous","email":"justin@jspahrsummers.com"},{"name":"anonymous","email":"experimentalworks@gmail.com"},{"name":"anonymous","email":"ashwin@anthropic.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/server-postgres_0.6.0_1733237397679_0.7449702733184804"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2024-12-03T14:49:57.834Z","publish_time":1733237397834,"_source_registry_name":"default","contributors":[]},"0.6.1":{"name":"@modelcontextprotocol/server-postgres","version":"0.6.1","description":"MCP server for interacting with PostgreSQL databases","license":"MIT","author":{"name":"Anthropic, PBC","url":"https://anthropic.com"},"homepage":"https://modelcontextprotocol.io","bugs":{"url":"https://github.com/modelcontextprotocol/servers/issues"},"type":"module","bin":{"mcp-server-postgres":"dist/index.js"},"scripts":{"build":"tsc && shx chmod +x dist/*.js","prepare":"npm run build","watch":"tsc --watch"},"dependencies":{"@modelcontextprotocol/sdk":"1.0.1","pg":"^8.13.0"},"devDependencies":{"@types/pg":"^8.11.10","shx":"^0.3.4","typescript":"^5.6.2"},"_id":"@modelcontextprotocol/server-postgres@0.6.1","gitHead":"a096c95e8eaa718b0efbce64ee77e2ddda4fdcd8","_nodeVersion":"18.20.5","_npmVersion":"10.8.2","dist":{"integrity":"sha512-c8KOLtuH75OttcNDMGWS2KldfMLozrCZ+hui3Gts6wRIjuZOPIRJHQtf7Gn+vX9JA78pgzCKxmL3dHuFhM1qlQ==","shasum":"a1cfe073bf78088095d3a008d881e9e83b01eb0a","tarball":"http://123.232.10.234:8212/nexus/content/groups/npm-public/@modelcontextprotocol/server-postgres/-/server-postgres-0.6.1.tgz","fileCount":3,"unpackedSize":5937,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIDS8s4ICK79maMvBiYC3k+vbgYwVIGpYAa9ZZtw1+nhuAiBkfvK1yHTEQyUiuXyEiUxzFlKjxc6VwtePiAiMXfyYuQ=="}],"size":2341},"_npmUser":{"name":"anonymous","email":"justin@jspahrsummers.com"},"directories":{},"maintainers":[{"name":"anonymous","email":"justin@jspahrsummers.com"},{"name":"anonymous","email":"experimentalworks@gmail.com"},{"name":"anonymous","email":"ashwin@anthropic.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/server-postgres_0.6.1_1733248348794_0.9572079112242096"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2024-12-03T17:52:28.951Z","publish_time":1733248348951,"_source_registry_name":"default","contributors":[]},"0.6.2":{"name":"@modelcontextprotocol/server-postgres","version":"0.6.2","description":"MCP server for interacting with PostgreSQL databases","license":"MIT","author":{"name":"Anthropic, PBC","url":"https://anthropic.com"},"homepage":"https://modelcontextprotocol.io","bugs":{"url":"https://github.com/modelcontextprotocol/servers/issues"},"type":"module","bin":{"mcp-server-postgres":"dist/index.js"},"scripts":{"build":"tsc && shx chmod +x dist/*.js","prepare":"npm run build","watch":"tsc --watch"},"dependencies":{"@modelcontextprotocol/sdk":"1.0.1","pg":"^8.13.0"},"devDependencies":{"@types/pg":"^8.11.10","shx":"^0.3.4","typescript":"^5.6.2"},"_id":"@modelcontextprotocol/server-postgres@0.6.2","gitHead":"94a36286d2ea49d095704167846283f0c2c2d5d1","_nodeVersion":"18.20.5","_npmVersion":"10.8.2","dist":{"integrity":"sha512-ukbVmVxLAsdZ5pTVWbhf9fc7lqkSf7XqizNH8XAotI21GnRPtkqO+WLWpeBFU+/2Fyv63uXS7/9NnR8Y8wOP1Q==","shasum":"179488ed90ee346a3d7eceec205ea7eebf36edc2","tarball":"http://123.232.10.234:8212/nexus/content/groups/npm-public/@modelcontextprotocol/server-postgres/-/server-postgres-0.6.2.tgz","fileCount":3,"unpackedSize":5936,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIG8dckAwJ7+abhx+lgXAFMe3N1osv7PzzXAynL2emzx3AiBEv5KoHNCWDiRGabnQL2IZBTmNUs6UBmZVr0I1AXL1Aw=="}],"size":2336},"_npmUser":{"name":"anonymous","email":"justin@jspahrsummers.com"},"directories":{},"maintainers":[{"name":"anonymous","email":"justin@jspahrsummers.com"},{"name":"anonymous","email":"experimentalworks@gmail.com"},{"name":"anonymous","email":"ashwin@anthropic.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/server-postgres_0.6.2_1733328891659_0.9760041814184748"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2024-12-04T16:14:51.820Z","publish_time":1733328891820,"_source_registry_name":"default","contributors":[]}},"dist-tags":{"latest":"0.6.2"},"name":"@modelcontextprotocol/server-postgres","time":{"created":"2024-11-19T14:17:00.447Z","modified":"2026-02-06T23:13:15.771Z","0.1.0":"2024-11-19T14:14:36.814Z","0.2.0":"2024-11-21T19:15:25.223Z","0.3.0":"2024-11-21T22:37:44.735Z","0.5.0":"2024-11-25T13:17:21.422Z","0.5.1":"2024-11-25T19:58:40.762Z","0.6.0":"2024-12-03T14:49:57.834Z","0.6.1":"2024-12-03T17:52:28.951Z","0.6.2":"2024-12-04T16:14:51.820Z"},"readme":"# PostgreSQL\n\nA Model Context Protocol server that provides read-only access to PostgreSQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.\n\n## Components\n\n### Tools\n\n- **query**\n  - Execute read-only SQL queries against the connected database\n  - Input: `sql` (string): The SQL query to execute\n  - All queries are executed within a READ ONLY transaction\n\n### Resources\n\nThe server provides schema information for each table in the database:\n\n- **Table Schemas** (`postgres://<host>/<table>/schema`)\n  - JSON schema information for each table\n  - Includes column names and data types\n  - Automatically discovered from database metadata\n\n## Usage with Claude Desktop\n\nTo use this server with the Claude Desktop app, add the following configuration to the \"mcpServers\" section of your `claude_desktop_config.json`:\n\n```json\n{\n  \"mcpServers\": {\n    \"postgres\": {\n      \"command\": \"npx\",\n      \"args\": [\n        \"-y\",\n        \"@modelcontextprotocol/server-postgres\",\n        \"postgresql://localhost/mydb\"\n      ]\n    }\n  }\n}\n```\n\nReplace `/mydb` with your database name.\n\n## License\n\nThis MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.","users":{}}