{"_id":"@microsoft/postgres-mcp","_rev":"12-f6c3b3884acf93ae8de188d0f84461c8","name":"@microsoft/postgres-mcp","dist-tags":{"latest":"0.3.0","next":"0.3.0-rc.2"},"versions":{"0.1.0-rc.2":{"name":"@microsoft/postgres-mcp","version":"0.1.0-rc.2","keywords":["postgresql","postgres","pgsql","mcp","model-context-protocol","database","ai","copilot"],"license":"MIT","_id":"@microsoft/postgres-mcp@0.1.0-rc.2","maintainers":[{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"microsoft-oss-releases","email":"microsoft-oss-publishing@microsoft.com"}],"homepage":"https://github.com/microsoft/pgsql-tools/blob/alperen/publish-postgres-mcp-npm/postgres-mcp/README.md","bugs":{"url":"https://github.com/microsoft/pgsql-tools/issues"},"bin":{"postgres-mcp":"bin/postgres-mcp.js"},"tag":"next","dist":{"shasum":"d12b01047b2d7a9035a63681050dfc6f8effd370","tarball":"https://registry.npmjs.org/@microsoft/postgres-mcp/-/postgres-mcp-0.1.0-rc.2.tgz","fileCount":5,"integrity":"sha512-UhjtfMjNp4hY/Kixy2rnQfUoWfSJwyae4rb+wztvO+GWWhKWQy8A2MBQdZ4X821f2Ye+wpdwJIx0I6LsH2+SUg==","signatures":[{"sig":"MEUCIQCG77iX3SBF+vY1XJ4JqNGaQiwhLZjTdKFVzdrl/4FrKAIgUH2ltrsZjYbZhNzKRlMtbzqvrd+5eWSoEaKHNRzIDwA=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":24124},"_from":"file:M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\77a6d123-c331-4b48-9d20-b18a1258bb36\\microsoft-postgres-mcp-0.1.0-rc.2.tgz","engines":{"node":">=22"},"_npmUser":{"name":"microsoft1es","email":"npmjs@microsoft.com"},"_resolved":"M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\77a6d123-c331-4b48-9d20-b18a1258bb36\\microsoft-postgres-mcp-0.1.0-rc.2.tgz","_integrity":"sha512-UhjtfMjNp4hY/Kixy2rnQfUoWfSJwyae4rb+wztvO+GWWhKWQy8A2MBQdZ4X821f2Ye+wpdwJIx0I6LsH2+SUg==","repository":{"url":"git+https://github.com/microsoft/pgsql-tools.git","type":"git"},"description":"PostgreSQL MCP server for AI assistants over the Model Context Protocol.","directories":{},"_nodeVersion":"18.5.0","dependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.2","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.2","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.2","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.2","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.2"},"_hasShrinkwrap":false,"optionalDependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.2","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.2","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.2","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.2","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.2"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_0.1.0-rc.2_1785757683153_0.34635266347215854","host":"s3://npm-registry-packages-npm-production"}},"0.1.0-rc.3":{"name":"@microsoft/postgres-mcp","version":"0.1.0-rc.3","keywords":["postgresql","postgres","pgsql","mcp","model-context-protocol","database","ai","copilot"],"license":"MIT","_id":"@microsoft/postgres-mcp@0.1.0-rc.3","maintainers":[{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"microsoft-oss-releases","email":"microsoft-oss-publishing@microsoft.com"}],"homepage":"https://github.com/microsoft/pgsql-tools/blob/alperen/publish-postgres-mcp-npm/postgres-mcp/README.md","bugs":{"url":"https://github.com/microsoft/pgsql-tools/issues"},"bin":{"postgres-mcp":"bin/postgres-mcp.js"},"tag":"next","dist":{"shasum":"29789cd08e611a92f2569ee2dee7ca16985e5e0e","tarball":"https://registry.npmjs.org/@microsoft/postgres-mcp/-/postgres-mcp-0.1.0-rc.3.tgz","fileCount":5,"integrity":"sha512-XcD1KymJ25iIBCv08EXoQ7scC0BcuClNSMZuj2s86IvUzXFa5cDrOA9EgcV/IvmQJJTrxlV98qNmfqIE6TBEYw==","signatures":[{"sig":"MEQCIAzFvle0eFtMIS3v6DAY2HoXGd8hqfHZMPE4A2CzK5dEAiADuMie6+Vfg29lSHYxwtX6HjgqprLHmyOE4ZHmN3hhYQ==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":24124},"_from":"file:M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\58144a08-720f-4dff-b163-b87b7a4d3fdc\\microsoft-postgres-mcp-0.1.0-rc.3.tgz","engines":{"node":">=22"},"_npmUser":{"name":"microsoft1es","email":"npmjs@microsoft.com"},"_resolved":"M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\58144a08-720f-4dff-b163-b87b7a4d3fdc\\microsoft-postgres-mcp-0.1.0-rc.3.tgz","_integrity":"sha512-XcD1KymJ25iIBCv08EXoQ7scC0BcuClNSMZuj2s86IvUzXFa5cDrOA9EgcV/IvmQJJTrxlV98qNmfqIE6TBEYw==","repository":{"url":"git+https://github.com/microsoft/pgsql-tools.git","type":"git"},"description":"PostgreSQL MCP server for AI assistants over the Model Context Protocol.","directories":{},"_nodeVersion":"18.5.0","dependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.3","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.3","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.3","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.3","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.3"},"_hasShrinkwrap":false,"readmeFilename":"README.md","optionalDependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.3","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.3","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.3","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.3","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.3"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_0.1.0-rc.3_1785765008358_0.751030780146309","host":"s3://npm-registry-packages-npm-production"}},"0.1.0-rc.4":{"name":"@microsoft/postgres-mcp","version":"0.1.0-rc.4","keywords":["postgresql","postgres","pgsql","mcp","model-context-protocol","database","ai","copilot"],"license":"MIT","_id":"@microsoft/postgres-mcp@0.1.0-rc.4","maintainers":[{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"microsoft-oss-releases","email":"microsoft-oss-publishing@microsoft.com"}],"homepage":"https://github.com/microsoft/postgres-mcp/blob/main/README.md","bugs":{"url":"https://github.com/microsoft/postgres-mcp/issues"},"bin":{"postgres-mcp":"bin/postgres-mcp.js"},"dist":{"shasum":"a9e6a742143348b65133e1f36c0c3e15240c3f78","tarball":"https://registry.npmjs.org/@microsoft/postgres-mcp/-/postgres-mcp-0.1.0-rc.4.tgz","fileCount":5,"integrity":"sha512-T+1LZm1nq7iB3nVcFARPUJ2ycbYCqAJMBnVp0tSLRxMKEmCGcgdD+y/n6L/vLlwuH0vTpwTkbUM5Usg8DW4Stg==","signatures":[{"sig":"MEUCIHneisexzHYZOTbrBy0j71/2C+F3FdhJ2gH5fpzgAiF3AiEA9/xbdOgfqtCUJhrgFwbWo10lQTxrc1H4YTdMnIb+XsY=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":24043},"_from":"file:M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\6e4cddfa-1572-437d-a772-01b2ab928d6a\\microsoft-postgres-mcp-0.1.0-rc.4.tgz","engines":{"node":">=22"},"_npmUser":{"name":"microsoft1es","email":"npmjs@microsoft.com"},"_resolved":"M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\6e4cddfa-1572-437d-a772-01b2ab928d6a\\microsoft-postgres-mcp-0.1.0-rc.4.tgz","_integrity":"sha512-T+1LZm1nq7iB3nVcFARPUJ2ycbYCqAJMBnVp0tSLRxMKEmCGcgdD+y/n6L/vLlwuH0vTpwTkbUM5Usg8DW4Stg==","repository":{"url":"git+https://github.com/microsoft/postgres-mcp.git","type":"git"},"description":"PostgreSQL MCP server for AI assistants over the Model Context Protocol.","directories":{},"_nodeVersion":"18.5.0","dependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.4","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.4","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.4","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.4","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.4"},"_hasShrinkwrap":false,"optionalDependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.4","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.4","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.4","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.4","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.4"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_0.1.0-rc.4_1785803652821_0.8687772199120487","host":"s3://npm-registry-packages-npm-production"}},"0.1.0-rc.6":{"name":"@microsoft/postgres-mcp","version":"0.1.0-rc.6","keywords":["postgresql","postgres","pgsql","mcp","model-context-protocol","database","ai","copilot"],"license":"MIT","_id":"@microsoft/postgres-mcp@0.1.0-rc.6","maintainers":[{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"microsoft-oss-releases","email":"microsoft-oss-publishing@microsoft.com"}],"homepage":"https://github.com/microsoft/postgres-mcp/blob/main/README.md","bugs":{"url":"https://github.com/microsoft/postgres-mcp/issues"},"bin":{"postgres-mcp":"bin/postgres-mcp.js"},"dist":{"shasum":"57f5d1e9c16f3b462e7cfda10771b9d85a631c38","tarball":"https://registry.npmjs.org/@microsoft/postgres-mcp/-/postgres-mcp-0.1.0-rc.6.tgz","fileCount":5,"integrity":"sha512-aBFwmppkW3eLm0kvW6QNHPQvXUc8bjytpQfh8bBVthQ8pPea3h5ZpAuIMr7jM6QOukbTr7igZE6+wbSyzBuEdg==","signatures":[{"sig":"MEQCIF85Zlr3LPz/89KTNL1ZgzFIaoopBbMC0m+fgB1bOARpAiBtB5VQU8YLV8J0fW3EFvX6syAbGCbWplrXOQxVEOz2/w==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":27775},"_from":"file:M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\6e5b090a-3875-48bb-9efa-9f7259eb1f24\\microsoft-postgres-mcp-0.1.0-rc.6.tgz","engines":{"node":">=22"},"_npmUser":{"name":"microsoft1es","email":"npmjs@microsoft.com"},"_resolved":"M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\6e5b090a-3875-48bb-9efa-9f7259eb1f24\\microsoft-postgres-mcp-0.1.0-rc.6.tgz","_integrity":"sha512-aBFwmppkW3eLm0kvW6QNHPQvXUc8bjytpQfh8bBVthQ8pPea3h5ZpAuIMr7jM6QOukbTr7igZE6+wbSyzBuEdg==","repository":{"url":"git+https://github.com/microsoft/postgres-mcp.git","type":"git"},"description":"PostgreSQL MCP server for AI assistants over the Model Context Protocol.","directories":{},"_nodeVersion":"18.5.0","dependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.6","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.6","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.6","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.6","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.6"},"_hasShrinkwrap":false,"optionalDependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.6","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.6","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.6","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.6","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.6"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_0.1.0-rc.6_1786656316274_0.8901642877917031","host":"s3://npm-registry-packages-npm-production"}},"0.1.1-rc.7":{"name":"@microsoft/postgres-mcp","version":"0.1.1-rc.7","keywords":["postgresql","postgres","pgsql","mcp","model-context-protocol","database","ai","copilot"],"license":"MIT","_id":"@microsoft/postgres-mcp@0.1.1-rc.7","maintainers":[{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"microsoft-oss-releases","email":"microsoft-oss-publishing@microsoft.com"}],"homepage":"https://github.com/microsoft/postgres-mcp/blob/main/README.md","bugs":{"url":"https://github.com/microsoft/postgres-mcp/issues"},"bin":{"postgres-mcp":"bin/postgres-mcp.js"},"tag":"next","dist":{"shasum":"f73c92ffcd14b0a81102dd230e388e9929c2228d","tarball":"https://registry.npmjs.org/@microsoft/postgres-mcp/-/postgres-mcp-0.1.1-rc.7.tgz","fileCount":5,"integrity":"sha512-JXISAlK2h6bW86pqb4mIuZDGLydJ4V7PR+TkMdn5FND5FN/a22+PkspOfQ0H91N2I3u7QMb3PJSElJpc21ruOQ==","signatures":[{"sig":"MEYCIQDaXcmlqetwXQKFogYwbrNuY6ZqxbVWJilSV73IebpkpgIhAPWckAAYkcAKPU2E2x+uv6Sv+mz3TRL9pYVhudhfEZfl","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":28378},"_from":"file:M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\01f5336e-e4ad-41d4-b0a0-1d68b58d55d5\\microsoft-postgres-mcp-0.1.1-rc.7.tgz","engines":{"node":">=22"},"_npmUser":{"name":"microsoft1es","email":"npmjs@microsoft.com"},"_resolved":"M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\01f5336e-e4ad-41d4-b0a0-1d68b58d55d5\\microsoft-postgres-mcp-0.1.1-rc.7.tgz","_integrity":"sha512-JXISAlK2h6bW86pqb4mIuZDGLydJ4V7PR+TkMdn5FND5FN/a22+PkspOfQ0H91N2I3u7QMb3PJSElJpc21ruOQ==","repository":{"url":"git+https://github.com/microsoft/postgres-mcp.git","type":"git"},"description":"PostgreSQL MCP server for AI assistants over the Model Context Protocol.","directories":{},"_nodeVersion":"18.5.0","dependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.1-rc.7","@microsoft/postgres-mcp-win32-x64":"0.1.1-rc.7","@microsoft/postgres-mcp-darwin-x64":"0.1.1-rc.7","@microsoft/postgres-mcp-linux-arm64":"0.1.1-rc.7","@microsoft/postgres-mcp-darwin-arm64":"0.1.1-rc.7"},"_hasShrinkwrap":false,"readmeFilename":"README.md","optionalDependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.1-rc.7","@microsoft/postgres-mcp-win32-x64":"0.1.1-rc.7","@microsoft/postgres-mcp-darwin-x64":"0.1.1-rc.7","@microsoft/postgres-mcp-linux-arm64":"0.1.1-rc.7","@microsoft/postgres-mcp-darwin-arm64":"0.1.1-rc.7"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_0.1.1-rc.7_1787160890349_0.01852958553661499","host":"s3://npm-registry-packages-npm-production"}},"0.1.0-rc.8":{"name":"@microsoft/postgres-mcp","version":"0.1.0-rc.8","keywords":["postgresql","postgres","pgsql","mcp","model-context-protocol","database","ai","copilot"],"license":"MIT","_id":"@microsoft/postgres-mcp@0.1.0-rc.8","maintainers":[{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"microsoft-oss-releases","email":"microsoft-oss-publishing@microsoft.com"}],"homepage":"https://github.com/microsoft/postgres-mcp/blob/main/README.md","bugs":{"url":"https://github.com/microsoft/postgres-mcp/issues"},"bin":{"postgres-mcp":"bin/postgres-mcp.js"},"dist":{"shasum":"c27d2363797d686cb32c21be2ae61be160eec629","tarball":"https://registry.npmjs.org/@microsoft/postgres-mcp/-/postgres-mcp-0.1.0-rc.8.tgz","fileCount":5,"integrity":"sha512-tS8UxHU2S2hDTwUXDEgkN4EWp92F7TyZRjW0qvWu1TqX+bVwXW/kXL+rbhUQGJwIilmvtVTaR45IQuGtv3FoLw==","signatures":[{"sig":"MEQCIHdOZ/jn5QgNzFfEA3KQt4m22RRHN6gmN5NN6Z0DhWHaAiA8QSv6JcRUPGHpqv7a1k+0GbQXluzeI13+1zUy6QsIWA==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":28378},"_from":"file:M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\1aba3a9a-5316-4cde-abde-07c973d6df0f\\microsoft-postgres-mcp-0.1.0-rc.8.tgz","engines":{"node":">=22"},"_npmUser":{"name":"microsoft1es","email":"npmjs@microsoft.com"},"_resolved":"M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\1aba3a9a-5316-4cde-abde-07c973d6df0f\\microsoft-postgres-mcp-0.1.0-rc.8.tgz","_integrity":"sha512-tS8UxHU2S2hDTwUXDEgkN4EWp92F7TyZRjW0qvWu1TqX+bVwXW/kXL+rbhUQGJwIilmvtVTaR45IQuGtv3FoLw==","repository":{"url":"git+https://github.com/microsoft/postgres-mcp.git","type":"git"},"description":"PostgreSQL MCP server for AI assistants over the Model Context Protocol.","directories":{},"_nodeVersion":"18.5.0","dependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.8","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.8","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.8","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.8","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.8"},"_hasShrinkwrap":false,"optionalDependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.8","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.8","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.8","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.8","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.8"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_0.1.0-rc.8_1787169327823_0.8350371353359172","host":"s3://npm-registry-packages-npm-production"}},"0.1.0-rc.9":{"name":"@microsoft/postgres-mcp","version":"0.1.0-rc.9","keywords":["postgresql","postgres","pgsql","mcp","model-context-protocol","database","ai","copilot"],"license":"MIT","_id":"@microsoft/postgres-mcp@0.1.0-rc.9","maintainers":[{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"microsoft-oss-releases","email":"microsoft-oss-publishing@microsoft.com"}],"homepage":"https://github.com/microsoft/postgres-mcp/blob/main/README.md","bugs":{"url":"https://github.com/microsoft/postgres-mcp/issues"},"bin":{"postgres-mcp":"bin/postgres-mcp.js"},"dist":{"shasum":"0eb829bda5d6faa78224c355fc904cfab5fd9a57","tarball":"https://registry.npmjs.org/@microsoft/postgres-mcp/-/postgres-mcp-0.1.0-rc.9.tgz","fileCount":5,"integrity":"sha512-g4YPdPzQOJSL60D39SG82C/BoqxPm8dFRvFVcbiTEE8l//d9oUgihltjBhvsoxwUtlly16goauDOS91RSjfuiQ==","signatures":[{"sig":"MEUCIQCPIH9w/VpcyaRRNMzKYvY2mYvXFm1CskKu+WvyiEnqvwIgdFYy6e250LQjozNU0dKxlxj5CxVHZ8SayVqIOxp1lYQ=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":34012},"_from":"file:M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\01b52d51-ec20-4611-a469-c5ac8a5f3bda\\microsoft-postgres-mcp-0.1.0-rc.9.tgz","engines":{"node":">=22"},"_npmUser":{"name":"microsoft1es","email":"npmjs@microsoft.com"},"_resolved":"M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\01b52d51-ec20-4611-a469-c5ac8a5f3bda\\microsoft-postgres-mcp-0.1.0-rc.9.tgz","_integrity":"sha512-g4YPdPzQOJSL60D39SG82C/BoqxPm8dFRvFVcbiTEE8l//d9oUgihltjBhvsoxwUtlly16goauDOS91RSjfuiQ==","repository":{"url":"git+https://github.com/microsoft/postgres-mcp.git","type":"git"},"description":"PostgreSQL MCP server for AI assistants over the Model Context Protocol.","directories":{},"_nodeVersion":"18.5.0","dependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.9","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.9","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.9","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.9","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.9"},"_hasShrinkwrap":false,"optionalDependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.9","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.9","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.9","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.9","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.9"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_0.1.0-rc.9_1787677104382_0.28953222790019706","host":"s3://npm-registry-packages-npm-production"}},"0.1.0-rc.10":{"name":"@microsoft/postgres-mcp","version":"0.1.0-rc.10","keywords":["postgresql","postgres","pgsql","mcp","model-context-protocol","database","ai","copilot"],"license":"MIT","_id":"@microsoft/postgres-mcp@0.1.0-rc.10","maintainers":[{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"microsoft-oss-releases","email":"microsoft-oss-publishing@microsoft.com"}],"homepage":"https://github.com/microsoft/postgres-mcp/blob/main/README.md","bugs":{"url":"https://github.com/microsoft/postgres-mcp/issues"},"bin":{"postgres-mcp":"bin/postgres-mcp.js"},"dist":{"shasum":"bcb2140d6ab275846f21b3c4909f74b8b34a3300","tarball":"https://registry.npmjs.org/@microsoft/postgres-mcp/-/postgres-mcp-0.1.0-rc.10.tgz","fileCount":5,"integrity":"sha512-qCnvzapif/jBeLsGTVkyKMlFPAcV02CGbTeCFWdn2dSEsmMsA79fPuSSnTTj21MZqtal3vdaS6qGrwLdvCw+/w==","signatures":[{"sig":"MEUCIQCm+IgM5EDtrefa/NEi9L6UsE3Ug8AI5KwtvyP73RqG5gIgE9g7Fj1/BY2CdeWeEfIRixHcqU9RHJqTAuTDT+PHRoA=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":36872},"_from":"file:M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\35facff4-9aff-4831-a2fc-0f78391c16c1\\microsoft-postgres-mcp-0.1.0-rc.10.tgz","engines":{"node":">=22"},"_npmUser":{"name":"microsoft1es","email":"npmjs@microsoft.com"},"_resolved":"M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\35facff4-9aff-4831-a2fc-0f78391c16c1\\microsoft-postgres-mcp-0.1.0-rc.10.tgz","_integrity":"sha512-qCnvzapif/jBeLsGTVkyKMlFPAcV02CGbTeCFWdn2dSEsmMsA79fPuSSnTTj21MZqtal3vdaS6qGrwLdvCw+/w==","repository":{"url":"git+https://github.com/microsoft/postgres-mcp.git","type":"git"},"description":"PostgreSQL MCP server for AI assistants over the Model Context Protocol.","directories":{},"_nodeVersion":"18.5.0","dependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.10","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.10","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.10","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.10","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.10"},"_hasShrinkwrap":false,"optionalDependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.10","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.10","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.10","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.10","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.10"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_0.1.0-rc.10_1788548218572_0.06655649527683627","host":"s3://npm-registry-packages-npm-production"}},"0.1.0-rc.11":{"name":"@microsoft/postgres-mcp","version":"0.1.0-rc.11","keywords":["postgresql","postgres","pgsql","mcp","model-context-protocol","database","ai","copilot"],"license":"MIT","_id":"@microsoft/postgres-mcp@0.1.0-rc.11","maintainers":[{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"microsoft-oss-releases","email":"microsoft-oss-publishing@microsoft.com"}],"homepage":"https://github.com/microsoft/postgres-mcp/blob/main/README.md","bugs":{"url":"https://github.com/microsoft/postgres-mcp/issues"},"bin":{"postgres-mcp":"bin/postgres-mcp.js"},"dist":{"shasum":"a481a9311c42368cd909fd28e16c978265f486a0","tarball":"https://registry.npmjs.org/@microsoft/postgres-mcp/-/postgres-mcp-0.1.0-rc.11.tgz","fileCount":5,"integrity":"sha512-X6QJUJXF8jR25dn9okK+hkfj+/aG9NjuCRTohnZRXEy7TyczY6eUROJTkUkAJwk3RlvRPdN2rO1KLbDiHHfOKg==","signatures":[{"sig":"MEUCIE7BESYCWyjXqzF6ki3m4tOojf+1KM0uIFSYTCb0kN4TAiEAiKaDWHIBqxE1SCW48yMgNgwOGoGzqcYyf6d6dALhWcI=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":36872},"_from":"file:M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\13d422f9-f84f-4be9-8139-86310ba58a32\\microsoft-postgres-mcp-0.1.0-rc.11.tgz","engines":{"node":">=22"},"_npmUser":{"name":"microsoft1es","email":"npmjs@microsoft.com"},"_resolved":"M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\13d422f9-f84f-4be9-8139-86310ba58a32\\microsoft-postgres-mcp-0.1.0-rc.11.tgz","_integrity":"sha512-X6QJUJXF8jR25dn9okK+hkfj+/aG9NjuCRTohnZRXEy7TyczY6eUROJTkUkAJwk3RlvRPdN2rO1KLbDiHHfOKg==","repository":{"url":"git+https://github.com/microsoft/postgres-mcp.git","type":"git"},"description":"PostgreSQL MCP server for AI assistants over the Model Context Protocol.","directories":{},"_nodeVersion":"18.5.0","dependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.11","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.11","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.11","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.11","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.11"},"_hasShrinkwrap":false,"optionalDependencies":{"@microsoft/postgres-mcp-linux-x64":"0.1.0-rc.11","@microsoft/postgres-mcp-win32-x64":"0.1.0-rc.11","@microsoft/postgres-mcp-darwin-x64":"0.1.0-rc.11","@microsoft/postgres-mcp-linux-arm64":"0.1.0-rc.11","@microsoft/postgres-mcp-darwin-arm64":"0.1.0-rc.11"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_0.1.0-rc.11_1789063944257_0.43438985142494513","host":"s3://npm-registry-packages-npm-production"}},"0.2.0":{"name":"@microsoft/postgres-mcp","version":"0.2.0","keywords":["postgresql","postgres","pgsql","mcp","model-context-protocol","database","ai","copilot"],"license":"MIT","_id":"@microsoft/postgres-mcp@0.2.0","maintainers":[{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"microsoft-oss-releases","email":"microsoft-oss-publishing@microsoft.com"}],"homepage":"https://github.com/microsoft/postgres-mcp/blob/main/README.md","bugs":{"url":"https://github.com/microsoft/postgres-mcp/issues"},"bin":{"postgres-mcp":"bin/postgres-mcp.js"},"dist":{"shasum":"4a2eae34c24d7c9160dd19fc426ec4c454c3b5f5","tarball":"https://registry.npmjs.org/@microsoft/postgres-mcp/-/postgres-mcp-0.2.0.tgz","fileCount":5,"integrity":"sha512-dOtPO+YAkO4bay6EcPBNXToEjqtjsQGLLuDKdpjgkUZoA6mCezRI5Ftnen6jgQFM9kmCpsE8qfwEzWjbDklE6A==","signatures":[{"sig":"MEUCICiDEQV0oVP6IQqdUvIUkp/8QbCWaREoDRTllU9WP+61AiEA+PUhGC+DTOwURMHZVyu3cVKAz7hUI2A6P5DItTo1d94=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"},{"sig":"MEYCIQDBDAciwAd/bpAy4AgfTh6+q75yN69Gxr/PgawKLKKZ/QIhAIM0/7uxJQ2OFY8OuiJyJJAcn5n16pX4lgkpEaxQFDc9","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":36836},"_from":"file:M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\c49c0e6e-5529-4d38-83f8-5606902e9178\\microsoft-postgres-mcp-0.2.0.tgz","engines":{"node":">=22"},"_npmUser":{"name":"microsoft1es","email":"npmjs@microsoft.com"},"_resolved":"M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\c49c0e6e-5529-4d38-83f8-5606902e9178\\microsoft-postgres-mcp-0.2.0.tgz","_integrity":"sha512-dOtPO+YAkO4bay6EcPBNXToEjqtjsQGLLuDKdpjgkUZoA6mCezRI5Ftnen6jgQFM9kmCpsE8qfwEzWjbDklE6A==","repository":{"url":"git+https://github.com/microsoft/postgres-mcp.git","type":"git"},"description":"PostgreSQL MCP server for AI assistants over the Model Context Protocol.","directories":{},"_nodeVersion":"18.5.0","dependencies":{"@microsoft/postgres-mcp-linux-x64":"0.2.0","@microsoft/postgres-mcp-win32-x64":"0.2.0","@microsoft/postgres-mcp-darwin-x64":"0.2.0","@microsoft/postgres-mcp-linux-arm64":"0.2.0","@microsoft/postgres-mcp-darwin-arm64":"0.2.0"},"_hasShrinkwrap":false,"optionalDependencies":{"@microsoft/postgres-mcp-linux-x64":"0.2.0","@microsoft/postgres-mcp-win32-x64":"0.2.0","@microsoft/postgres-mcp-darwin-x64":"0.2.0","@microsoft/postgres-mcp-linux-arm64":"0.2.0","@microsoft/postgres-mcp-darwin-arm64":"0.2.0"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_0.2.0_1790191154087_0.9619452148213476","host":"s3://npm-registry-packages-npm-production"}},"0.3.0-rc.2":{"name":"@microsoft/postgres-mcp","version":"0.3.0-rc.2","keywords":["postgresql","postgres","pgsql","mcp","model-context-protocol","database","ai","copilot"],"license":"MIT","_id":"@microsoft/postgres-mcp@0.3.0-rc.2","maintainers":[{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"microsoft-oss-releases","email":"microsoft-oss-publishing@microsoft.com"}],"homepage":"https://github.com/microsoft/postgres-mcp/blob/main/README.md","bugs":{"url":"https://github.com/microsoft/postgres-mcp/issues"},"bin":{"postgres-mcp":"bin/postgres-mcp.js"},"tag":"next","dist":{"shasum":"46be2556a3cb909be44b565de347699d325ad366","tarball":"https://registry.npmjs.org/@microsoft/postgres-mcp/-/postgres-mcp-0.3.0-rc.2.tgz","fileCount":5,"integrity":"sha512-F/jrQA13LzBPoHpaIYiPSLsXlSqhUu6alO5p1T+CyeH8iUSQYM6qUM44XUA41g0GDi1VMmhlbZ5FdvrjQo6u6g==","signatures":[{"sig":"MEUCIDfwXhB+UB3FyPDa8jw4MJwe/sZDaTi2RgZdoNyrMP4CAiEAyirDLVyYErRi6+7KHL/5Q29HAwZ9YAiqIRfykedFCSw=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"},{"sig":"MEUCIQDbrmKhheeEzl/yhLzb1txTfSxdL14tAIUtx6BGIMLWIQIgXrrZgi3TFCeeQUi0Voaa9okMk+8Ksrl/eBD6/hww3+0=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":36866},"_from":"file:M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\8b2e630d-2522-4bb5-94fa-ca86307148bb\\microsoft-postgres-mcp-0.3.0-rc.2.tgz","engines":{"node":">=22"},"_npmUser":{"name":"microsoft1es","email":"npmjs@microsoft.com"},"_resolved":"M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\8b2e630d-2522-4bb5-94fa-ca86307148bb\\microsoft-postgres-mcp-0.3.0-rc.2.tgz","_integrity":"sha512-F/jrQA13LzBPoHpaIYiPSLsXlSqhUu6alO5p1T+CyeH8iUSQYM6qUM44XUA41g0GDi1VMmhlbZ5FdvrjQo6u6g==","repository":{"url":"git+https://github.com/microsoft/postgres-mcp.git","type":"git"},"description":"PostgreSQL MCP server for AI assistants over the Model Context Protocol.","directories":{},"_nodeVersion":"18.5.0","dependencies":{"@microsoft/postgres-mcp-linux-x64":"0.3.0-rc.2","@microsoft/postgres-mcp-win32-x64":"0.3.0-rc.2","@microsoft/postgres-mcp-darwin-x64":"0.3.0-rc.2","@microsoft/postgres-mcp-linux-arm64":"0.3.0-rc.2","@microsoft/postgres-mcp-darwin-arm64":"0.3.0-rc.2"},"_hasShrinkwrap":false,"readmeFilename":"README.md","optionalDependencies":{"@microsoft/postgres-mcp-linux-x64":"0.3.0-rc.2","@microsoft/postgres-mcp-win32-x64":"0.3.0-rc.2","@microsoft/postgres-mcp-darwin-x64":"0.3.0-rc.2","@microsoft/postgres-mcp-linux-arm64":"0.3.0-rc.2","@microsoft/postgres-mcp-darwin-arm64":"0.3.0-rc.2"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_0.3.0-rc.2_1791572529433_0.6100629717113721","host":"s3://npm-registry-packages-npm-production"}},"0.3.0":{"_id":"@microsoft/postgres-mcp@0.3.0","bin":{"postgres-mcp":"bin/postgres-mcp.js"},"bugs":{"url":"https://github.com/microsoft/postgres-mcp/issues"},"dist":{"shasum":"e00a2944184ac935cd31dd912938779c2984e2c2","tarball":"https://registry.npmjs.org/@microsoft/postgres-mcp/-/postgres-mcp-0.3.0.tgz","fileCount":5,"integrity":"sha512-hRA8gkNA0O8CHAJmuTKJYS00nItiNoM3yMQdSHiLRc8WB/8dEV9fVE98hh1TI/a6bc4VbHNVs4Gp7O+i5moZow==","signatures":[{"sig":"MEQCIFKHtRczqpU4piGTM1gGAWcZCXfKyZ5mCgV6kMKfiYrPAiAFhyoPwW5Gh8mT6ICA/Gyp8OUpWAvybwyTxL2C58qnvA==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"},{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEYCIQCxFqxDrsG3l6WBh2t76NAoE8ScgpgF9LLqm+3OebaKawIhAPQSwrkiePEjNA4al4qeygu7DWvAQqWc54MCEaYKuaAW"}],"unpackedSize":36836},"name":"@microsoft/postgres-mcp","_from":"file:M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\68f567cf-b539-4955-8933-7e921268a16e\\microsoft-postgres-mcp-0.3.0.tgz","engines":{"node":">=22"},"license":"MIT","version":"0.3.0","_npmUser":{"name":"microsoft1es","email":"npmjs@microsoft.com"},"homepage":"https://github.com/microsoft/postgres-mcp/blob/main/README.md","keywords":["postgresql","postgres","pgsql","mcp","model-context-protocol","database","ai","copilot"],"_resolved":"M:\\SvcFab\\_App\\MS.Ess.PackageManager.Publisher_App1\\temp\\68f567cf-b539-4955-8933-7e921268a16e\\microsoft-postgres-mcp-0.3.0.tgz","_integrity":"sha512-hRA8gkNA0O8CHAJmuTKJYS00nItiNoM3yMQdSHiLRc8WB/8dEV9fVE98hh1TI/a6bc4VbHNVs4Gp7O+i5moZow==","repository":{"url":"git+https://github.com/microsoft/postgres-mcp.git","type":"git"},"description":"PostgreSQL MCP server for AI assistants over the Model Context Protocol.","directories":{},"maintainers":[{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"microsoft-oss-releases","email":"microsoft-oss-publishing@microsoft.com"}],"_nodeVersion":"18.5.0","dependencies":{"@microsoft/postgres-mcp-linux-x64":"0.3.0","@microsoft/postgres-mcp-win32-x64":"0.3.0","@microsoft/postgres-mcp-darwin-x64":"0.3.0","@microsoft/postgres-mcp-linux-arm64":"0.3.0","@microsoft/postgres-mcp-darwin-arm64":"0.3.0"},"_hasShrinkwrap":false,"optionalDependencies":{"@microsoft/postgres-mcp-linux-x64":"0.3.0","@microsoft/postgres-mcp-win32-x64":"0.3.0","@microsoft/postgres-mcp-darwin-x64":"0.3.0","@microsoft/postgres-mcp-linux-arm64":"0.3.0","@microsoft/postgres-mcp-darwin-arm64":"0.3.0"},"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/postgres-mcp_0.3.0_1792710906530_0.08498250237990468"}}},"time":{"created":"2026-08-03T11:48:02.982Z","modified":"2026-10-22T23:15:06.866Z","0.1.0-rc.2":"2026-08-03T11:48:03.287Z","0.1.0-rc.3":"2026-08-03T13:50:08.510Z","0.1.0-rc.4":"2026-08-04T00:34:12.976Z","0.1.0-rc.6":"2026-08-13T21:25:16.439Z","0.1.1-rc.7":"2026-08-19T17:34:50.492Z","0.1.0-rc.8":"2026-08-19T19:55:27.960Z","0.1.0-rc.9":"2026-08-25T16:58:24.523Z","0.1.0-rc.10":"2026-09-04T18:56:58.680Z","0.1.0-rc.11":"2026-09-10T18:12:24.408Z","0.2.0":"2026-09-23T19:19:14.169Z","0.3.0-rc.2":"2026-10-09T19:02:09.517Z","0.3.0":"2026-10-22T23:15:06.682Z"},"bugs":{"url":"https://github.com/microsoft/postgres-mcp/issues"},"license":"MIT","homepage":"https://github.com/microsoft/postgres-mcp/blob/main/README.md","keywords":["postgresql","postgres","pgsql","mcp","model-context-protocol","database","ai","copilot"],"repository":{"url":"git+https://github.com/microsoft/postgres-mcp.git","type":"git"},"description":"PostgreSQL MCP server for AI assistants over the Model Context Protocol.","maintainers":[{"name":"microsoft1es","email":"npmjs@microsoft.com"},{"name":"microsoft-oss-releases","email":"microsoft-oss-publishing@microsoft.com"}],"readme":"# Postgres MCP Server\n\n[![Platforms: Claude | Copilot | Codex | Open Code](https://img.shields.io/badge/Platforms-Claude_|_Copilot_|_Codex_|_Open_Code-purple.svg)](#2-add-postgres-mcp-to-your-coding-agent)\n[![Postgres: local | on-prem | azure | aws | gcp](https://img.shields.io/badge/Postgres-local_|_on--prem_|_azure_|_aws_|_gcp-0f766e.svg)](#requirements)\n[![Release status: Preview](https://img.shields.io/badge/Release_status-Preview-blue.svg)](./CHANGELOG.md)\n\n**Connect your coding agent to PostgreSQL.** `postgres-mcp` lets you generate\nqueries and run analytics, design database schemas, diagnose performance of the\nserver and queries, securely manage connections, and import data. It is\ncompatible with any MCP client — GitHub Copilot, Claude Code, Codex, Open Code,\nCursor, VS Code, and more.\n\n- **npm:** https://www.npmjs.com/package/@microsoft/postgres-mcp\n- **No install required** — run it straight from `npx`.\n\n## Quick start\n\n### 1. Save a connection profile\n\nCreate a named profile once — the password is stored in your OS keyring, never in\na config file:\n\n```sh\n# add a profile from a libpq URI or key=value string\nnpx -y @microsoft/postgres-mcp connection add local \\\n  \"postgresql://postgres@localhost:5432/postgres\"\n\n# store its password securely (hidden prompt)\nnpx -y @microsoft/postgres-mcp connection set-password local\n\n# check it\nnpx -y @microsoft/postgres-mcp connection list\n```\n\n> Profiles created by `connection add` permit write tools unless\n> `access_mode: ro` is set. For autonomous agents that should not write, use an\n> explicit read-only profile **and** a read-only database role — see\n> [Read-only profiles](./USAGE.md#read-only-profiles-for-autonomous-agents).\n\n### 2. Add postgres-mcp to your coding agent\n\nThe server speaks MCP over stdio. Point your client at\n`npx @microsoft/postgres-mcp run` — no credentials go in the client config; the\ncoding agent discovers and connects to your saved profile at runtime.\n\n**GitHub Copilot CLI, Claude Code, Cursor & Claude Desktop** — clients that use the `mcpServers` format (`~/.copilot/mcp-config.json`, `mcp.json`, `.cursor/mcp.json`, `claude_desktop_config.json`, …):\n\n```jsonc\n{\n  \"mcpServers\": {\n    \"postgres\": {\n      \"command\": \"npx\",\n      \"args\": [\"-y\", \"@microsoft/postgres-mcp\", \"run\"]\n    }\n  }\n}\n```\n\n> Running headless or in CI, without a keyring? The server can also take a\n> database connection string from the environment — see\n> [Connecting without a profile](./USAGE.md#connecting-without-a-profile) in the\n> guide.\n\n### 3. Ask your coding agent\n\n> \"List the tables in my PostgreSQL database.\"\n> \"Show me the 10 most recent orders from my PostgreSQL database.\"\n> \"What's slowing down my PostgreSQL server right now?\"\n\nThe agent calls the server's tools (`postgres_mcp_connect`,\n`postgres_mcp_query`, `postgres_mcp_db_context`, …) for you.\n\n---\n\n## What it can do\n\n| Area | Tools |\n|------|-------|\n| **Connections** | list / add / remove profiles, connect, disconnect, list databases |\n| **Query** | read‑only SQL (`postgres_mcp_query`), DDL/DML (`postgres_mcp_modify`) |\n| **Schema** | fetch `CREATE` scripts for tables, indexes, functions, sequences… |\n| **Data** | describe a CSV, bulk‑load a CSV via `COPY` |\n| **Diagnostics** | probe server capabilities, collect performance metric groups |\n\nSee the [usage guide](./USAGE.md) for tools, configuration, authentication\n(including Microsoft Entra ID), TLS, and the security model.\n\n---\n\n## Security in one minute\n\n- **The server doesn't decide what's allowed — your database does.** It just\n  passes requests along to PostgreSQL and runs them as the database user in\n  your connection profile. It can't tell the difference between a request you\n  meant to make and one the AI invented or was tricked into making, so\n  anything that database user can do, the AI can do. What actually protects\n  you is the permissions you give that user, the approval prompts in your MCP\n  client, and the model you choose to run. See\n  [Security model](./USAGE.md#security-model) for who's responsible for what,\n  plus a checklist for locking things down.\n- **`postgres_mcp_query` is read‑only.** Omitted profile `access_mode` permits write\n  tools; set `access_mode: ro` and use a read-only database role unless writes\n  are intentionally delegated.\n- **Microsoft Entra ID (AAD)** is selected automatically for Azure profiles\n  without a stored keyring password. Store a profile password to use password\n  authentication instead.\n- **Local file reads** (`postgres_mcp_bulk_load_csv`, `postgres_mcp_describe_csv`) are limited\n  to the MCP server's startup working directory by default and paths allowed\n  with `allow-access-to-path <path>`. A file allows only itself; a directory\n  allows recursive access.\n- **Secrets are scrubbed** from error messages before they leave the process.\n\nSee more info about security model in the [usage guide](./USAGE.md#security-model).\n\n---\n\n## Requirements\n\n- **Node.js 22+** (to run via `npx`).\n- Linux x64/arm64, macOS x64/arm64, or Windows x64. Windows ARM uses x64\n  emulation.\n- A reachable **PostgreSQL** database — local, Docker, on‑premises, Azure\n  Database for PostgreSQL, Amazon RDS/Aurora, Google Cloud SQL/AlloyDB, or any\n  wire‑compatible server.\n\n## Changelog\n\nSee [CHANGELOG.md](./CHANGELOG.md) for release notes.\n\n## License\n\nLicensed under the [MIT License](https://github.com/microsoft/postgres-mcp/blob/main/LICENSE) © Microsoft.\n","readmeFilename":"README.md"}