{"_id":"@edelciomolina/postgres-mcp","_rev":"34-6fc83586fb0ababfd16c6606552c2707","name":"@edelciomolina/postgres-mcp","dist-tags":{"latest":"1.24.0"},"versions":{"1.0.0":{"name":"@edelciomolina/postgres-mcp","version":"1.0.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.0.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"8a3bdd55f825cff44fd5acd222a4fa89f7a42317","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.0.0.tgz","fileCount":4,"integrity":"sha512-U3KN/07FGaVEdRz29R3Srq7wTJYi2VZzZEbpC+FUe24TTkF4ff982IwSDmAK5f+t/Il7FqiXeIpeuPXQsOM8BQ==","signatures":[{"sig":"MEUCIQCc20fcnBsFWmcf2zxdqWE1FyWEdK5fIatio97NCFBmTwIgMyKc9NMweFtnssm0JVM9503uHiaDcWrgNz209Dq85jU=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":11453},"engines":{"node":">=18"},"gitHead":"d47e20741db2b1553e4d0566a8e8ae63f1322e57","scripts":{"build":"tsc","prepublishOnly":"npm run build"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"11.3.0","description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"_nodeVersion":"20.19.1","dependencies":{"@henkey/postgres-mcp-server":"^1.0.5"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.19.42"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.0.0_1780755391759_0.029177120619479968","host":"s3://npm-registry-packages-npm-production"}},"1.0.1":{"name":"@edelciomolina/postgres-mcp","version":"1.0.1","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.0.1","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"cfd71f78a2d801d34339d6f92c03e34e541e6092","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.0.1.tgz","fileCount":4,"integrity":"sha512-jZvwU5fDt67xuAG79B6ytilHRMOFkuXiGHgsWNckJ2WAeFXozlifzf0m9bxYbiHoN+ZEQDHboSXQcVA/KLR5xg==","signatures":[{"sig":"MEYCIQDYQfyXq2orXnskyh5zufLBL4K/JZYW/XOAZFvZJbOE6wIhAJXqiPs5JzBtEapTnAJQd1prwAaeK+jZJfjLadqCXh9B","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":11506},"engines":{"node":">=18"},"gitHead":"d47e20741db2b1553e4d0566a8e8ae63f1322e57","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"build":"tsc","prepublishOnly":"npm run build"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"11.3.0","description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"_nodeVersion":"20.19.1","dependencies":{"@henkey/postgres-mcp-server":"^1.0.5"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.19.42"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.0.1_1780755586222_0.7959169511131328","host":"s3://npm-registry-packages-npm-production"}},"1.0.2":{"name":"@edelciomolina/postgres-mcp","version":"1.0.2","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.0.2","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"94bbdf7cbda301ee855bf89cc649c35259d2a080","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.0.2.tgz","fileCount":4,"integrity":"sha512-qTilgIT5yolzsD5OouMpNM163w+xSURAObxlhZJz+pEK9b7/cyUNPHUrwPoDOML3+N62DhlvF0z/RMWBJeuYgQ==","signatures":[{"sig":"MEUCIQD5F60qKSHE/vYXLJ0sgdpbHE0/SJY+ugI6o2dtslqzAQIgJyzsPnaAG6z3RKaG1UzOBEwVdgbVsra7fERtfTruREQ=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":11506},"engines":{"node":">=18"},"gitHead":"d47e20741db2b1553e4d0566a8e8ae63f1322e57","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"build":"tsc","prepublishOnly":"npm run build"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"11.3.0","description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"_nodeVersion":"20.19.1","dependencies":{"@henkey/postgres-mcp-server":"^1.0.5"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.19.42"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.0.2_1780755708689_0.14952033859780034","host":"s3://npm-registry-packages-npm-production"}},"1.0.3":{"name":"@edelciomolina/postgres-mcp","version":"1.0.3","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.0.3","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"82982f885eddcd6897a415aa28edc44a59b40f51","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.0.3.tgz","fileCount":5,"integrity":"sha512-wrarsuoLrr3p9PTkFamyBFQYrH3y3tARsWp1DF7sFavCXmCcPy2PMFLvCkcVEKL196XaDwenDVLW1wQaT6b/FQ==","signatures":[{"sig":"MEQCICVS2cGlDqqHgT0LlDEILvfy0IOyMAQYxPKtlSVSljmiAiAMwCdJXd5PC3AxNlMN4Ke1+5M4obt4qnPzY6pSxcTStA==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":12581},"engines":{"node":">=18"},"gitHead":"830cb25c4a8fde95caa7dfa9530be0e41edc3315","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"build":"tsc","prepublishOnly":"npm run build"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"11.3.0","description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"_nodeVersion":"20.19.1","dependencies":{"@henkey/postgres-mcp-server":"^1.0.5"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.19.42"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.0.3_1780756405022_0.7801196145015723","host":"s3://npm-registry-packages-npm-production"}},"1.0.4":{"name":"@edelciomolina/postgres-mcp","version":"1.0.4","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.0.4","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"0006609be98412d4bbe9e13f11186593e3c0838d","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.0.4.tgz","fileCount":5,"integrity":"sha512-pUGl02A5jD8nqUnND2nZivX38LP+UQOwheNIjwgwELE89xHxxvYKHKutlxub4deVPgy+DnA/y9VKXRUWR5doiA==","signatures":[{"sig":"MEYCIQCSYoLNkv1BTS9SVXRd+frFSbHePJ18rqTY1Gqfsg0KWgIhAN9awy+pZjQNygXIm82SFw9t3UZQzD3MmaR+lduqZ9yC","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":12581},"engines":{"node":">=18"},"gitHead":"3bf06db0a6ebe1ccba53556b1d03472722fa5744","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"build":"tsc","prepublishOnly":"npm run build"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"11.3.0","description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"_nodeVersion":"20.19.1","dependencies":{"@henkey/postgres-mcp-server":"^1.0.5"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.19.42"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.0.4_1780756541564_0.7607900941512555","host":"s3://npm-registry-packages-npm-production"}},"1.0.5":{"name":"@edelciomolina/postgres-mcp","version":"1.0.5","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.0.5","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"4ea6f8fc8389f84db2606163fe325fb92dd237da","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.0.5.tgz","fileCount":7,"integrity":"sha512-0MbMZJezw0ekpmItfilKuWIQK8IX9uQ4Q6oi8PsnOxqhDuMBDB6ze5zWMNSq2fAqdiWMPWXjMQGnGja/+0zPiw==","signatures":[{"sig":"MEUCIEtVa+vXbaHPeKeQWcveZknRZ1XblLExO2gZg05YAp5IAiEAjC3SAVOczuTP4BdFFYuE3BSeuL+draZqQ8u53uvh32A=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":23746},"engines":{"node":">=18"},"gitHead":"93d0c86bccc0c397ff9d5910ca23be977e87e152","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"tsc && node --test dist/index.test.js","build":"tsc","deploy:mcp":"npm publish --access public && mcp-publisher publish","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","prepublishOnly":"npm run build"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"11.3.0","description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"_nodeVersion":"20.19.1","dependencies":{"@henkey/postgres-mcp-server":"^1.0.5"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.19.42"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.0.5_1780760947136_0.32786419745446493","host":"s3://npm-registry-packages-npm-production"}},"1.0.6":{"name":"@edelciomolina/postgres-mcp","version":"1.0.6","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.0.6","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"0af2e151c348bd05de92fa6d4e9f1678efc60614","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.0.6.tgz","fileCount":7,"integrity":"sha512-690dhC4IM2YMp7D9R1OPs4wI84zpcTZc/pOQEjPaWCH6EWvbKkDb/TxVedaC5ZT+2mTexX6P1GV22qo7zjGh4A==","signatures":[{"sig":"MEYCIQC6QqcGbf9ZkkwHPCYIo5Y/MsbP6uTFLlCV1pko3NhA7QIhAKzErtQ6C0lmIve2WV+U9SgquPM48ZL+TAL+8nOs56XR","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":25237},"engines":{"node":">=18"},"gitHead":"cef1cfbb0858980fcd452f4809d580cdc195c89e","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"tsc && node --test dist/index.test.js","build":"tsc","deploy:mcp":"npm publish --access public && mcp-publisher publish","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","prepublishOnly":"npm run build"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"11.3.0","description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"_nodeVersion":"20.19.1","dependencies":{"@henkey/postgres-mcp-server":"^1.0.5"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.19.42"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.0.6_1780763265621_0.16691329174515945","host":"s3://npm-registry-packages-npm-production"}},"1.0.7":{"name":"@edelciomolina/postgres-mcp","version":"1.0.7","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.0.7","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"16a223b097537b9ddcf6dbc6b0523e8f801b56c3","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.0.7.tgz","fileCount":7,"integrity":"sha512-U7R3opMDFDo7gRejWDqGO9HSI5eN9qUbbbWzidbcip2XpfNfEhqsOQmseXC4tPVkaF0jSXGusQ6wzL0kbtLC4A==","signatures":[{"sig":"MEYCIQDL/3WQ8IszncSXo2yOpRWFCt4xWXhxRb5YEE2yztbZlQIhAKLZ58H2fGGd9/qzZzH096GzGnuIy7oHAJI1KIxf1i7j","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":25237},"engines":{"node":">=18"},"gitHead":"cef1cfbb0858980fcd452f4809d580cdc195c89e","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"tsc && node --test dist/index.test.js","build":"tsc","deploy:mcp":"npm publish --access public && mcp-publisher publish","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","prepublishOnly":"npm run build"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"11.3.0","description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"_nodeVersion":"20.19.1","dependencies":{"@henkey/postgres-mcp-server":"^1.0.5"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.19.42"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.0.7_1780763472801_0.05118401968487385","host":"s3://npm-registry-packages-npm-production"}},"1.0.8":{"name":"@edelciomolina/postgres-mcp","version":"1.0.8","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.0.8","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"7c2348835ce8cac1840a0d941160d9d394eff05b","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.0.8.tgz","fileCount":7,"integrity":"sha512-Kt8a9g0RI3cmXGBYu6BCIwzMeGo7Pz/BYOGXSJfBROZgdT064TbRyy1gglt96xgWZfErhFwYNu+MRMUINUlT+Q==","signatures":[{"sig":"MEQCIHd9vdbatiNCahKWn9fqc0cjI6L5QaoxWs8lQagM9GqDAiBwBQqtzuSdH+FMPudcsQaO/bP+2cQogduqq7RJLE3UAA==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":27789},"engines":{"node":">=18"},"gitHead":"7e536e2d1bac298793bb964445652ce52840a8c0","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"tsc && node --test dist/index.test.js","build":"tsc","deploy:mcp":"npm publish --access public && mcp-publisher login github && mcp-publisher publish","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","prepublishOnly":"npm run build"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"11.3.0","description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"_nodeVersion":"20.19.1","dependencies":{"@henkey/postgres-mcp-server":"^1.0.5"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.19.42"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.0.8_1780764345567_0.6775173660752751","host":"s3://npm-registry-packages-npm-production"}},"1.0.9":{"name":"@edelciomolina/postgres-mcp","version":"1.0.9","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.0.9","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"32521266d052f68c5847134318824a78d731bdd9","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.0.9.tgz","fileCount":7,"integrity":"sha512-w6P4AHuxUVO0q4BcsF7SNmt+Mc2DhdDv+Qu0fnr6ZCfwmw33526ZbvRqi6NkDZPDy/Ye0Ks9IC3NU5y/Aa+Rmw==","signatures":[{"sig":"MEYCIQCdMemMkjeQE0fKqQHE4g6/aSljpFhLH1UYNrovuPnc4wIhAJWpuIb6tQX7JblHDwX3ZiyGNWAApKxzIzePbc50PUb0","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":28026},"engines":{"node":">=18"},"gitHead":"7e536e2d1bac298793bb964445652ce52840a8c0","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"tsc && node --test dist/index.test.js","build":"tsc","deploy:mcp":"npm version patch --no-git-tag-version && node -e \"const fs=require('fs'),p=require('./package.json'),s=JSON.parse(fs.readFileSync('server.json','utf8'));s.version=p.version;s.packages[0].version=p.version;fs.writeFileSync('server.json',JSON.stringify(s,null,2)+'\\n');\" && npm publish --access public && mcp-publisher login github && mcp-publisher publish","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"11.3.0","description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"_nodeVersion":"20.19.1","dependencies":{"@henkey/postgres-mcp-server":"^1.0.5"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.19.42"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.0.9_1780764618243_0.5812374077368299","host":"s3://npm-registry-packages-npm-production"}},"1.0.10":{"name":"@edelciomolina/postgres-mcp","version":"1.0.10","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.0.10","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"6005d775e64cfb7de6ff5d1fc0b93b0e48dc78a4","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.0.10.tgz","fileCount":7,"integrity":"sha512-w/nslSxXwyLBTvar2zuwfOGd8gdGuJWF6A9TQm2SLWieTsQQNrEQl5bQvEU4F3y3m51DLsKIR8wc+7skBbcHMg==","signatures":[{"sig":"MEUCIHMKLcur3o09EprZGNpvhTEufM95+n9qwjpQ0wP/9mpeAiEA+5yaWyAz0KBSTWcYRgLV3adA8fPxgdoZ8lBmwlEoBWQ=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":34442},"engines":{"node":">=18"},"gitHead":"f5499bcfbdb44ebccb9b27aa918cb3196e5ac8f5","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"tsc && node --test dist/index.test.js","build":"tsc","deploy:mcp":"npm version patch --no-git-tag-version && node -e \"const fs=require('fs'),p=require('./package.json'),s=JSON.parse(fs.readFileSync('server.json','utf8'));s.version=p.version;s.packages[0].version=p.version;fs.writeFileSync('server.json',JSON.stringify(s,null,2)+'\\n');\" && npm publish --access public && mcp-publisher login github && mcp-publisher publish","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"11.3.0","description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"_nodeVersion":"20.19.1","dependencies":{"@henkey/postgres-mcp-server":"^1.0.5"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.19.42"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.0.10_1780765822671_0.09642653749276375","host":"s3://npm-registry-packages-npm-production"}},"1.0.11":{"name":"@edelciomolina/postgres-mcp","version":"1.0.11","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.0.11","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"7ae41c5c9822fd6454fc78d9ebf321f031c23546","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.0.11.tgz","fileCount":7,"integrity":"sha512-OYkq8LhQbTvCqzw+mbyPSAHefappT/xAMt+QdscAWMkuHuVg/lRptJBIR4A2/r4cJUyc6PtOmpvUU0VM/YWDaQ==","signatures":[{"sig":"MEUCIQDo0IFxE63+pljAUbPtytc1bOMr3Y5J1xbKyNxbMvw8ywIgZDYV15dE1wYrqjQ/zU2MtkMRjoDsmNskeE2+ODsJIh0=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":38335},"engines":{"node":">=18"},"gitHead":"9445adf738fa317cfae7106c3973a341693d80e0","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"tsc && node --test dist/index.test.js","build":"tsc","deploy:mcp":"npm version patch --no-git-tag-version && node -e \"const fs=require('fs'),p=require('./package.json'),s=JSON.parse(fs.readFileSync('server.json','utf8'));s.version=p.version;s.packages[0].version=p.version;fs.writeFileSync('server.json',JSON.stringify(s,null,2)+'\\n');\" && npm publish --access public && mcp-publisher login github && mcp-publisher publish","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"11.3.0","description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"_nodeVersion":"20.19.1","dependencies":{"@henkey/postgres-mcp-server":"^1.0.5"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.0.0","@types/node":"^20.19.42"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.0.11_1780766686614_0.7049732157779145","host":"s3://npm-registry-packages-npm-production"}},"1.0.12":{"name":"@edelciomolina/postgres-mcp","version":"1.0.12","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.0.12","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"8bd9df07f43bbb312ff296998adcc0b174a0d7ac","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.0.12.tgz","fileCount":7,"integrity":"sha512-mzEWpZeE0w/41BxmvbBCFITc/4i/JKRvOzrwXJVz42hu1Tew748cVrifemEPJwYeDxiJXUE0NZjjK+K1irWMSw==","signatures":[{"sig":"MEUCIQDfFyvFHud1KEdJKoSiBVRKAKGPKWeUufnTd/ABbjDjaQIgS2ujqddhixeUumoP3X5/XOaHUjVGsmyHDsIWWkQd90g=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":106735},"engines":{"node":">=18"},"gitHead":"679eede64d30c380625812cbddccfabe53cb8d72","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"tsc && node --test dist/index.test.js","build":"tsc","deploy:mcp":"npm version patch --no-git-tag-version && node -e \"const fs=require('fs'),p=require('./package.json'),s=JSON.parse(fs.readFileSync('server.json','utf8'));s.version=p.version;s.packages[0].version=p.version;fs.writeFileSync('server.json',JSON.stringify(s,null,2)+'\\n');\" && npm publish --access public && mcp-publisher login github && mcp-publisher publish","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"11.3.0","description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"_nodeVersion":"20.19.1","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"_hasShrinkwrap":false,"devDependencies":{"@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.0.12_1780771395733_0.12020869360316899","host":"s3://npm-registry-packages-npm-production"}},"1.0.13":{"name":"@edelciomolina/postgres-mcp","version":"1.0.13","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.0.13","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"80776cc477407cc8a21e108dd0b83877fa40af5d","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.0.13.tgz","fileCount":9,"integrity":"sha512-22sKcZboHgysjAczdRyHf8DaUNB1qHC8VVClYL6KXVsJQII7zuKtLcs9v+6hRFSdb067W2DBguGgt1zoEICppA==","signatures":[{"sig":"MEYCIQD1pFVopSw6XAty9CirmWrTUl/x0AVf7jOqfmEvE6zi8AIhAPVV+/PIj5QCWT/sXj+DNPkGUShgJEei9P65QfY3zQpc","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":181086},"engines":{"node":">=18"},"gitHead":"820996f403898d9cf7ec982ffdd82cc14423c5cb","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","deploy:mcp":"npm version patch --no-git-tag-version && node -e \"const fs=require('fs'),p=require('./package.json'),s=JSON.parse(fs.readFileSync('server.json','utf8'));s.version=p.version;s.packages[0].version=p.version;fs.writeFileSync('server.json',JSON.stringify(s,null,2)+'\\n');\" && npm publish --access public && mcp-publisher login github && mcp-publisher publish","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"11.3.0","description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"_nodeVersion":"20.19.1","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42"},"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.0.13_1780830896654_0.0014663296038313067","host":"s3://npm-registry-packages-npm-production"}},"1.4.0":{"name":"@edelciomolina/postgres-mcp","version":"1.4.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.4.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"fc9511cbc3429b6255bc6bcdcf097befb8d0e682","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.4.0.tgz","fileCount":7,"integrity":"sha512-iH//hmlETLsc7G550KJTqU/iWgMpNzVztlogtnUgcNmAJOJiHes+A438xld5lCcuIHny3Nmf5ql7z2neykFlkg==","signatures":[{"sig":"MEQCIHd4kMO7y0ub1eefQMUUJU9Z4QDJ/oKIDJvqhw8pjc8fAiBflGc6gZuGXV/EmEb2W9eWK+MF2GL7reRf0Zy0tZN6QA==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":162193},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"ca29de08a8629d345ef6d83d9f0a61c489537a92","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.4.0_1781189263454_0.34491798492491244","host":"s3://npm-registry-packages-npm-production"}},"1.5.0":{"name":"@edelciomolina/postgres-mcp","version":"1.5.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.5.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"13e980c9ac5956c7c9f3fb4d89ffc19bd01d3023","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.5.0.tgz","fileCount":7,"integrity":"sha512-Kn5KIabXnoQKOthLp189C6q8ZK+b8VA5+qOYQcHXq1tMjQpAjrc6JeQsqF7FtqiWMiiCI81p4GRYMnkwUqthVw==","signatures":[{"sig":"MEQCID8XPqtJM43T8aUb6glbpiQlcyVOYlD6WSs9kT9RmvGNAiAqlAEYfO12bq6AVzSFOyNWngdkFgZ7xdcZFWX7V3+qpg==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":162193},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"56d9b25b026f57b0e6a71ca120dc7464112518b3","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.5.0_1781189512365_0.8672771099903285","host":"s3://npm-registry-packages-npm-production"}},"1.6.0":{"name":"@edelciomolina/postgres-mcp","version":"1.6.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.6.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"75513c237f57bdac0f34239b31968bcecbfcee80","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.6.0.tgz","fileCount":7,"integrity":"sha512-Rz6fhpYdEO2ns9BJYPb0/mEqwDmQwKpTijvkg1lMs7P3uhP2EFbLKzx1LKu1skN8GKT7PcOwsAzPP3PBQ2SaRQ==","signatures":[{"sig":"MEYCIQDUe1hOGjnPYyyzPsNb2I2QfKB3ZoTRIgCXpxumx3K4HAIhAJ2WHCiHXtHg9rLX2oFkbuWXVxaVuzVFboK5/6VgRTPV","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":162193},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"8f714fd96cde303965650c3cb986292d9f7fc560","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.6.0_1781190149097_0.3207222254746245","host":"s3://npm-registry-packages-npm-production"}},"1.7.0":{"name":"@edelciomolina/postgres-mcp","version":"1.7.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.7.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"ae451ce5ecd731aacc57a11ebe1c0b661631c9f2","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.7.0.tgz","fileCount":8,"integrity":"sha512-mq+ld0b3oYU38fbR3utS3+V3J4PNbY+dP0vw4PRUa8Aaicsw13pf2dVIPfSMuCX1G1EeAcvp6wP3F5At7iCllA==","signatures":[{"sig":"MEUCIQCkcCiEWrZvWaHzObxr6YH54uJpMu15ob4ukeJC7az+wAIgWVguk1GxMPYMowh9kuzz5iwmYnQKCf5OTJlF1dDZJ4E=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":171036},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"808f683a8b09dea84c00e6104df07c1da5ef0b27","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.7.0_1781190743455_0.8107924423889006","host":"s3://npm-registry-packages-npm-production"}},"1.1.0":{"name":"@edelciomolina/postgres-mcp","version":"1.1.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.1.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"41c3935d4563b2f4f41101f6bff70c961d7de100","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.1.0.tgz","fileCount":10,"integrity":"sha512-EyOsJAacCkTDuMMsAJ4B2+ZLZif/j5fLNZYJFGyi3IKlFIdSR/QS9P1G9w1khTknUOMsbEUzr8qGlHVEYF/4Ow==","signatures":[{"sig":"MEYCIQDTxf6nmcnoXjhH2lzUQtrOF6x2llLVUqJ7zEG6QJg30AIhAOUWM0JVYrrlv7YsLaRS6e7M3jLXJZiF5k8FR1d8OnPH","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":211912},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"2364c54ee1fcbbce1f9c75970d7844c0f31c4d53","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.1.0_1781199874028_0.24338176428679414","host":"s3://npm-registry-packages-npm-production"}},"1.8.0":{"name":"@edelciomolina/postgres-mcp","version":"1.8.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.8.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"ae1501fd72ab8ad7b39b12bbb9342bb877a994fc","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.8.0.tgz","fileCount":8,"integrity":"sha512-AHfao+RLw3tCDRaM8orNB3ZU4BPwGTHhZJioH8wa4u+q3cvHbX1ZVjE7638TniKIhTF9YOJ+uDHuly7nEiGSZA==","signatures":[{"sig":"MEUCIQC9qncLicHDUsCAQLnl9OwUIyCtsjzYny2/RL5V1G0cmQIgGNu/zyA/fCUfyz2dHSI6XxkVbXiWJ+ubFvP7lwQOF6U=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":183722},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"67a3d89ae2822be8eb39d4d86f57f9e1f974405d","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.8.0_1781202778483_0.21013130020045012","host":"s3://npm-registry-packages-npm-production"}},"1.9.0":{"name":"@edelciomolina/postgres-mcp","version":"1.9.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.9.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"22214e9b6d79689d6c8196ff63376dc14d0a4de7","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.9.0.tgz","fileCount":8,"integrity":"sha512-5PQSn0ELPSE2dTP3BJt2AMNsiZLV09T4t3E1HSenhJywV7Cwta0769tgX6om7m6S4kaKqSlwhMHX/0K+ofKrqA==","signatures":[{"sig":"MEUCIHiG8r6BUGz3hGgrzDcK8WUmYb98pMKQ5LST8i7GFk37AiEA8r6Gz1+egljSXiETpetL2eApIVt9a44qpITBE8ePubw=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":183722},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"68858c991f22da3b83c15ffc94644633c5636715","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.9.0_1781202822114_0.7354894963053997","host":"s3://npm-registry-packages-npm-production"}},"1.10.0":{"name":"@edelciomolina/postgres-mcp","version":"1.10.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.10.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"4aea849721ceb5db441447af5241dd11d82ffa7b","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.10.0.tgz","fileCount":8,"integrity":"sha512-eQHCRXHlV0OPo6qL4Ejr1PWZmnJ3kdL6mNNzCx0qNDmHIyHE3WXLVDGRILl88V0/V9umT3Fgg/XSKWw1uxpjSg==","signatures":[{"sig":"MEYCIQDSHWa8kN7dS3hgN8uO8hHrrIZfwez4TBg/xyBE57f/XQIhAKA1ynadr1uuMA4r+TtDXxp0gchIVDwX7lREjvQOm4AE","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":183723},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"20d4dcfd73eefc777a28bbbf28e150a310ff27b9","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.10.0_1781202858243_0.06384399806148888","host":"s3://npm-registry-packages-npm-production"}},"1.11.0":{"name":"@edelciomolina/postgres-mcp","version":"1.11.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.11.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"45fa67b5d42ff35e7ff3d5c71e2e87516fc7634b","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.11.0.tgz","fileCount":8,"integrity":"sha512-14x/lerRXkHOEyHM9J9wtHfWvorHKVvhJyxD0edxiaIATWcutBznot6OjA9G9VpMC1AXFwPGylDGV+yMTHdwSQ==","signatures":[{"sig":"MEUCICftW6v/rk3W/XS0slmpdWlDN8c9KooFQYCgZjvd7ZNRAiEAl9ipbGiA4VtacHdxYCFJnxu6ndi6e/OWRn0+AAumI6Y=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":183723},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"b47a9e728a7d296001a37649bf85998cce64b43c","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.11.0_1781202899527_0.6291876790918591","host":"s3://npm-registry-packages-npm-production"}},"1.12.0":{"name":"@edelciomolina/postgres-mcp","version":"1.12.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.12.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"437c8534ac7ba82a134d8666dbae7991d30b0092","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.12.0.tgz","fileCount":8,"integrity":"sha512-Y67L6+WwxEwo4eOjKiVxngfzo0oIYfuLWoZry7rgFW2gF1dxbe4rb3yxoisEIpYduRaSS6VwEmCtCDlUPmx4cg==","signatures":[{"sig":"MEQCIAEEzQ4DiogP0DgRTNg6U7uuoOPqa8Vo2/5IapAY10TMAiAeXoI/c84m2PuLkw2mubqN2S5ZXRFUHZy5TBKwFIScuQ==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":183723},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"eb92d0f5cbbe74a6962b36e1a08108e77ec6af3c","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.12.0_1781202940428_0.5441138008448776","host":"s3://npm-registry-packages-npm-production"}},"1.13.0":{"name":"@edelciomolina/postgres-mcp","version":"1.13.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.13.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"0ffae48429cd663dda1325513ffdc62e2b5b64f4","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.13.0.tgz","fileCount":8,"integrity":"sha512-a4BRjwzk7VpZA2IzL6pKsQu1MtGILsGCyeG0npR06LEIjHUdZV+/S8+EsRfWdLz9oehmFeUYHaaQMEk4sjMFOg==","signatures":[{"sig":"MEUCIQCLGd7r8M7FLMZzIrgfbR8i9U5+4jovBmKV83ws/7XVbwIgKihngJOlhi1HakzSWVOY4RSzHtkcZkFH2eqq6dJaHRI=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":183723},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"4061c3eb640c0e7051dae93f2a3707df356e4271","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.13.0_1781203160459_0.4990371831523388","host":"s3://npm-registry-packages-npm-production"}},"1.14.0":{"name":"@edelciomolina/postgres-mcp","version":"1.14.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.14.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"bdcc3f89dc9f5bf97951988cd2c25e5e5bad457a","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.14.0.tgz","fileCount":8,"integrity":"sha512-N6ZlhlIYYJGBW/FONnNMI1mMUgmo0E5oPuc+nHPO0X/hqHVbJ9adJFxBSyjiG3mqvxhk8xGFQnrJWucqCdo7ng==","signatures":[{"sig":"MEUCIEyb/qu7mhnNDR/1WlWWBS6dViEfYeHR0mA5/wBUyrOAAiEA1JuIcC4ZyJuLQLDi66u1hnU4OwBGZXwijAO7mqf+uZc=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":183723},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"8ff38a39d41c432fc671fe60699bbbf5be6d05af","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.14.0_1781204715996_0.6060056325420804","host":"s3://npm-registry-packages-npm-production"}},"1.15.0":{"name":"@edelciomolina/postgres-mcp","version":"1.15.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.15.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"bc30622d3fdf9675f900ffa9aaa851b7ed0b3fbc","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.15.0.tgz","fileCount":8,"integrity":"sha512-DFySYYuqRem1lI2o6RNpCOEtvvZZgIeGd6RPtRK6OVicRTfcENUGwo8eiel2OdT4jXr1mdusDAkshdU4NcKQRA==","signatures":[{"sig":"MEUCIQC1sr2vQce+iwiHoIu/BBfc6eEV0XBvxpqQPpr0klyoXAIgcldfYdMwHFLTZLqVdcRyLqM+vPgXuGg07Pk3BXO8hc8=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":183723},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"bf8bb0b071be497623eb5f57d133b8f98e9bd1e0","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.15.0_1781204754743_0.27185146930370396","host":"s3://npm-registry-packages-npm-production"}},"1.16.0":{"name":"@edelciomolina/postgres-mcp","version":"1.16.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.16.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"59de76b61afab7fc1ddc15e919ce9c48ce888a2f","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.16.0.tgz","fileCount":8,"integrity":"sha512-VZYOiEYKndlUqmC6xLDkLbjMvpJOrBJjOxRgS4w1UA2QiZFwSdH+8bI8IY5b36jKDbulF7DRuRxdQvCqQs4gfA==","signatures":[{"sig":"MEUCIDKb5UbJNnBM8aDuZ8seuFx17RlVOfdaUzXPw5rqTUWIAiEAvyv2v/tPQmGjM1DpBK/X3aHgc3zh7TGnbO6tFoqJ1fY=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":183723},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"2cc943517e932b0eb301a1913fa2f06e656a5534","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.16.0_1781204795122_0.4191280001435824","host":"s3://npm-registry-packages-npm-production"}},"1.17.0":{"name":"@edelciomolina/postgres-mcp","version":"1.17.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.17.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"e806cf6ce9900214ad99f0040b45ea3264a00872","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.17.0.tgz","fileCount":8,"integrity":"sha512-a1cQfzxSFyAYj+hTTQziyASG0O15FfPvNDWuV1lgacno9cfNWp5nqF480uAx3JA55kcBo4ijnM4F6eiZlviSvg==","signatures":[{"sig":"MEYCIQCyiw51aLjzquXTes4i56jMcw2v7sJu0ZmJafsIcgLAOQIhAK4RtuJ64inLiz4gLJVa+HnlnBxtQ0h4MZBpbVzank9O","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":183723},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"c5e79fcc61518f6eaea9c3ad8e04efb347c573e5","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.17.0_1781204833694_0.8206846215771264","host":"s3://npm-registry-packages-npm-production"}},"1.18.0":{"name":"@edelciomolina/postgres-mcp","version":"1.18.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.18.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"bb23b7213cea72ef43fda1b31b4b27b50bd78454","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.18.0.tgz","fileCount":8,"integrity":"sha512-crker4/3pwI35tWDdgOUmJfHjYbQzzZirv4wgnjJR5hUdHSfK2XluoA6HF9gFRCspLmhI/TI346fu7IJOxP/zA==","signatures":[{"sig":"MEUCIQC0TgpkCRIe0vXEuziTZiLpq4Ih4Whfb+NBcpQpFciw1gIgXDC5IHn8XAirKZMijkjVcp28Lz/LtoDq4Y28hGMZXOM=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":183723},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"a4cd8467d08d5fc1fe9c3d120e64509aca58ebe3","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","release":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.18.0_1781205068990_0.823685456474561","host":"s3://npm-registry-packages-npm-production"}},"1.20.0":{"name":"@edelciomolina/postgres-mcp","version":"1.20.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.20.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"36ba04ad656db3dd29aef354b4841c83ece1c5ef","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.20.0.tgz","fileCount":8,"integrity":"sha512-IpGcv2gu0tscuzgA2hDX7qr6t9rfhcuixe5EdIgvXu3eerJ0QDypZoklWmTy2xuOZLTPFsEnghBIsyMtvng1LA==","signatures":[{"sig":"MEYCIQCZh3lcDMvZaAFR8B66s+N9YDAiRrhKi3qmGKSM6W+d9wIhAOWG7QJ+S2Omx+vZixkXe7lFcRk9Munp4IYwLbin2yct","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":183723},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"ebb909c4277eef00de6531a04ac07666c67788c2","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.20.0_1781208344619_0.8205829854491882","host":"s3://npm-registry-packages-npm-production"}},"1.21.0":{"name":"@edelciomolina/postgres-mcp","version":"1.21.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.21.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"fd11c39ab7b1b9296de3f09297afb7272d1a8161","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.21.0.tgz","fileCount":8,"integrity":"sha512-CwgTHpSK+b6CtVLrgQRBcYfvcRTGFejr1LtUZiNN+zF5DJj8Nd9qGoAZFDWAQTkarkSpR+uKAmncaQQlBr8LXQ==","signatures":[{"sig":"MEUCICak4wjZ2BD/niQnpGyZIo2CcJFMyXFBitWgJPoNJBXFAiEA/xBEPBkr0PnsGr4BeK8i6c3oycXcIvOnM78V6gpD3PQ=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":183723},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"98bfc7628a7be141a58a84319d956199c4b7d028","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.21.0_1781209424282_0.12174641899382399","host":"s3://npm-registry-packages-npm-production"}},"1.22.0":{"name":"@edelciomolina/postgres-mcp","version":"1.22.0","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","_id":"@edelciomolina/postgres-mcp@1.22.0","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"bin":{"postgres-mcp":"dist/index.js"},"dist":{"shasum":"df0eb596ea9ba840cdddd1744912f453d3166f4d","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.22.0.tgz","fileCount":15,"integrity":"sha512-OgZAR/rz9QUKpLWNzZk5KECySXzRx8Rth4y8OHLpzBZ6WF6Cs5pNzUUTw75QrM2UUnMBgoF4/PKivRWTVfLtdw==","signatures":[{"sig":"MEQCIE7ok7Yr2erQCkzUvxUpxccRSKs0iBJFvDuKSEs6JST4AiBVxhGMClTJszSRSK2hqDv4tYOSiTkwb7t0asBYXjeKaQ==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":573408},"icon":"icon.png","main":"./dist/extension.js","engines":{"node":">=18","vscode":"^1.120.0"},"gitHead":"dc0ce14e3d6754c24245438af09801c3dbf6a6d8","mcpName":"io.github.edelciomolina/postgres-mcp","scripts":{"test":"vitest run","build":"tsc","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool","test:watch":"vitest","vscode:prepublish":"npm run check"},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"publisher":"edelciomolina","categories":["AI","Other"],"repository":{"url":"git+https://github.com/edelciomolina/postgres-mcp.git","type":"git"},"_npmVersion":"10.9.2","contributes":{"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}},"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}]},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","directories":{},"displayName":"Postgres MCP","_nodeVersion":"22.15.0","dependencies":{"pg":"^8.13.0","zod":"^3.25.0","@modelcontextprotocol/sdk":"^1.12.0"},"extensionKind":["workspace","ui"],"_hasShrinkwrap":false,"devDependencies":{"tsx":"^4.22.4","vitest":"^4.1.8","@types/pg":"^8.20.0","typescript":"^5.0.0","@types/node":"^20.19.42","@vscode/vsce":"^3.9.2","@types/vscode":"^1.120.0"},"activationEvents":[],"_npmOperationalInternal":{"tmp":"tmp/postgres-mcp_1.22.0_1781210229811_0.29752671265195785","host":"s3://npm-registry-packages-npm-production"}},"1.24.0":{"name":"@edelciomolina/postgres-mcp","version":"1.24.0","mcpName":"io.github.edelciomolina/postgres-mcp","description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","publisher":"edelciomolina","displayName":"Postgres MCP","categories":["AI","Other"],"extensionKind":["workspace","ui"],"activationEvents":[],"main":"./dist/extension.js","icon":"icon.png","bin":{"postgres-mcp":"dist/index.js"},"contributes":{"mcpServerDefinitionProviders":[{"id":"postgres-mcp","label":"Postgres MCP"}],"configuration":{"title":"Postgres MCP","properties":{"postgresMcp.keyUrl":{"type":"string","default":"","description":"Name of the .env variable that holds a full connection URL (e.g. postgresql://user:pass@host:port/db). Leave empty to use the default: DATABASE_URL. When set, individual host/port/user/pass keys are ignored. (Sets MCP_KEY_URL)"},"postgresMcp.keyHost":{"type":"string","default":"","description":"Name of the .env variable that holds the database host. Leave empty to use the default: DB_HOST. (Sets MCP_KEY_HOST)"},"postgresMcp.keyPort":{"type":"string","default":"","description":"Name of the .env variable that holds the database port. Leave empty to use the default: DB_PORT. (Sets MCP_KEY_PORT)"},"postgresMcp.keyName":{"type":"string","default":"","description":"Name of the .env variable that holds the database name. Leave empty to use the default: DB_NAME. (Sets MCP_KEY_NAME)"},"postgresMcp.keyUser":{"type":"string","default":"","description":"Name of the .env variable that holds the database user. Leave empty to use the default: DB_USER. (Sets MCP_KEY_USER)"},"postgresMcp.keyPass":{"type":"string","default":"","description":"Name of the .env variable that holds the database password. Leave empty to use the default: DB_PASS. (Sets MCP_KEY_PASS)"},"postgresMcp.keySslMode":{"type":"string","default":"","description":"Name of the .env variable that holds the SSL mode (e.g. require). Leave empty to use the default: DB_SSLMODE. (Sets MCP_KEY_SSLMODE)"}}}},"scripts":{"build":"tsc","test":"vitest run","test:watch":"vitest","check":"npm run build && npm run test","package":"npm run check && vsce package","publish":"node scripts/deploy.js","vscode:prepublish":"npm run check","status:mcp":"curl -s \"https://registry.modelcontextprotocol.io/v0.1/servers?search=io.github.edelciomolina/postgres-mcp\" | python3 -m json.tool"},"dependencies":{"@modelcontextprotocol/sdk":"^1.12.0","pg":"^8.13.0","zod":"^3.25.0"},"devDependencies":{"@types/node":"^20.19.42","@types/pg":"^8.20.0","@types/vscode":"^1.120.0","@vscode/vsce":"^3.9.2","tsx":"^4.22.4","typescript":"^5.0.0","vitest":"^4.1.8"},"engines":{"node":">=18","vscode":"^1.120.0"},"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","repository":{"type":"git","url":"git+https://github.com/edelciomolina/postgres-mcp.git"},"homepage":"https://github.com/edelciomolina/postgres-mcp#readme","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"_id":"@edelciomolina/postgres-mcp@1.24.0","gitHead":"35c2af50c7312d739c5505fe3dd17e30460e1431","bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"_nodeVersion":"20.19.1","_npmVersion":"11.3.0","dist":{"integrity":"sha512-rh+WilAOh6CKQ2Jx3zbgAoVVB98tQc4CBcKZ/igJN30tTPCBPKKCzUDxqK0qRnq7MW1LJ3lXI51FCxEwewTwFA==","shasum":"b3caa6a90251101f3c66c2236b7aab0fa94d4b4a","tarball":"https://registry.npmjs.org/@edelciomolina/postgres-mcp/-/postgres-mcp-1.24.0.tgz","fileCount":24,"unpackedSize":272537,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEQCIDOlzjeb67NYJSEbTQytuU4ssQjhIiI3+9eY/fnGSSTuAiBCH6XOYfiuap9nd6WOsdHN8bi3zhwwQFXn44gCZkDClQ=="}]},"_npmUser":{"name":"edelciomolina","email":"edelciomolina@gmail.com"},"directories":{},"maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/postgres-mcp_1.24.0_1781390295666_0.13581550855468238"},"_hasShrinkwrap":false}},"time":{"created":"2026-06-06T14:16:31.577Z","modified":"2026-06-13T22:38:15.933Z","1.0.0":"2026-06-06T14:16:31.898Z","1.0.1":"2026-06-06T14:19:46.379Z","1.0.2":"2026-06-06T14:21:48.827Z","1.0.3":"2026-06-06T14:33:25.189Z","1.0.4":"2026-06-06T14:35:41.726Z","1.0.5":"2026-06-06T15:49:07.273Z","1.0.6":"2026-06-06T16:27:45.761Z","1.0.7":"2026-06-06T16:31:12.938Z","1.0.8":"2026-06-06T16:45:45.711Z","1.0.9":"2026-06-06T16:50:18.386Z","1.0.10":"2026-06-06T17:10:22.862Z","1.0.11":"2026-06-06T17:24:46.758Z","1.0.12":"2026-06-06T18:43:15.879Z","1.0.13":"2026-06-07T11:14:56.792Z","1.4.0":"2026-06-11T14:47:43.660Z","1.5.0":"2026-06-11T14:51:52.505Z","1.6.0":"2026-06-11T15:02:29.245Z","1.7.0":"2026-06-11T15:12:23.612Z","1.1.0":"2026-06-11T17:44:34.166Z","1.8.0":"2026-06-11T18:32:58.634Z","1.9.0":"2026-06-11T18:33:42.279Z","1.10.0":"2026-06-11T18:34:18.397Z","1.11.0":"2026-06-11T18:34:59.673Z","1.12.0":"2026-06-11T18:35:40.570Z","1.13.0":"2026-06-11T18:39:20.612Z","1.14.0":"2026-06-11T19:05:16.138Z","1.15.0":"2026-06-11T19:05:54.920Z","1.16.0":"2026-06-11T19:06:35.279Z","1.17.0":"2026-06-11T19:07:13.824Z","1.18.0":"2026-06-11T19:11:09.152Z","1.20.0":"2026-06-11T20:05:44.783Z","1.21.0":"2026-06-11T20:23:44.488Z","1.22.0":"2026-06-11T20:37:09.955Z","1.24.0":"2026-06-13T22:38:15.807Z"},"bugs":{"url":"https://github.com/edelciomolina/postgres-mcp/issues"},"author":{"name":"Edelcio Molina","email":"https://github.com/edelciomolina"},"license":"MIT","homepage":"https://github.com/edelciomolina/postgres-mcp#readme","keywords":["mcp","postgresql","postgres","database","model-context-protocol","copilot","ai","vscode"],"repository":{"type":"git","url":"git+https://github.com/edelciomolina/postgres-mcp.git"},"description":"MCP server wrapper for PostgreSQL - reads credentials from .env with configurable key mapping and safe read-only defaults.","maintainers":[{"name":"edelciomolina","email":"edelciomolina@gmail.com"}],"readme":"> **English** | 🌐 [Português](README_PT.md)\n\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n  <tr>\n    <td width=\"110\">\n      <img src=\"https://raw.githubusercontent.com/edelciomolina/postgres-mcp/main/icon.png\" width=\"96\" alt=\"Postgres MCP Icon\"/>\n    </td>\n    <td>\n      <h1>Postgres MCP</h1>\n      <p>🔌 Native MCP server for PostgreSQL - reads credentials from <code>.env</code> at runtime with flexible key mapping, configurable tool selection, and <strong>read-only mode by default</strong>.</p>\n      <a href=\"https://www.npmjs.com/package/@edelciomolina/postgres-mcp\"><img src=\"https://img.shields.io/npm/v/@edelciomolina/postgres-mcp\" alt=\"npm version\"/></a>\n      <a href=\"https://www.npmjs.com/package/@edelciomolina/postgres-mcp\"><img src=\"https://img.shields.io/npm/l/%40edelciomolina%2Fpostgres-mcp\" alt=\"license\"/></a>\n      <a href=\"https://github.com/edelciomolina/postgres-mcp/actions/workflows/ci.yml\"><img src=\"https://github.com/edelciomolina/postgres-mcp/actions/workflows/ci.yml/badge.svg\" alt=\"CI\"/></a>\n    </td>\n  </tr>\n</table>\n\n---\n\n## ✨ What it does\n\nMost LLMs interact with databases by guessing - assuming table names, inventing column names, and writing queries that may fail or expose sensitive data. Postgres MCP solves this by giving the LLM a **structured, safe interface** to actually understand the database before touching it.\n\nBuilt with [`@modelcontextprotocol/sdk`](https://www.npmjs.com/package/@modelcontextprotocol/sdk) and [`pg`](https://www.npmjs.com/package/pg), it provides:\n\n- 🧠 **Semantic knowledge graph** - the LLM gets a complete map of schemas, tables, columns, foreign keys, inferred relations, risk levels, and business domains - built from the real schema, not invented\n- 🛡️ **Read-only by default** - no writes, no DDL, no arbitrary SQL unless you explicitly opt in; `pg_classify_query_risk` lets the LLM check a query's safety before running it\n- 🔐 **Runtime credential resolution** - credentials are read from `.env` at startup; nothing sensitive lives in `mcp.json`\n- 🎯 **Explicit tool selection** - every tool is opt-in via `tool=<name>` args, so the LLM only sees what you choose to expose\n\n---\n\n## 📋 Requirements\n\n- ⚙️ Node.js >= 18\n- 📄 A `.env` file with database credentials (anywhere in the project tree - see [.env Discovery](#-env-file-discovery))\n\n---\n\n## 🚀 Installation\n\nThere are two ways to use this package. Choose the one that best fits your workflow.\n\n### Option 1 - No installation (via `npx`, recommended for quick start)\n\nNo installation needed. `npx` downloads and runs the package on demand. Add `-y` as the first argument to skip the confirmation prompt.\n\n```json\n{\n  \"servers\": {\n    \"Postgres Tools\": {\n      \"type\": \"stdio\",\n      \"command\": \"npx\",\n      \"args\": [\n        \"-y\",\n        \"@edelciomolina/postgres-mcp\"\n      ],\n      \"env\": {\n        \"MCP_KEY_HOST\":    \"DB_HOST\",\n        \"MCP_KEY_PORT\":    \"DB_PORT\",\n        \"MCP_KEY_NAME\":    \"DB_NAME\",\n        \"MCP_KEY_SSLMODE\": \"DB_SSLMODE\",\n        \"MCP_KEY_USER\":    \"DB_USER\",\n        \"MCP_KEY_PASS\":    \"DB_PASS\"\n      }\n    }\n  }\n}\n```\n\nThis starts the server with the **default read-only tool set** - no `tool=` arguments needed. To enable write-capable tools, see [Write-capable tools](#write-capable-opt-in-via-tool-argument).\n\n> 💡 **Using Supabase, Neon, Railway or another platform that only provides a connection string?** Use `MCP_KEY_URL` pointing to `DATABASE_URL` (or whatever variable name the platform uses). The server will prioritize the URL and ignore the individual variables. See [Connection via URL](#-connection-via-url-database_url).\n\n---\n\n### Option 2 - Install via VS Code (MCP extension marketplace)\n\nVS Code supports discovering and installing MCP servers directly in the editor, without using the terminal.\n\n1. Open the **Command Palette** (<kbd>Cmd</kbd>+<kbd>Shift</kbd>+<kbd>P</kbd> on Mac / <kbd>Ctrl</kbd>+<kbd>Shift</kbd>+<kbd>P</kbd> on Windows/Linux)\n2. Run **`MCP: Add Server`**\n3. Choose **\"Browse MCP Servers\"** (or **\"From registry\"**, depending on your VS Code version)\n4. Search for **`postgres-mcp`** or **`edelciomolina`**\n5. Select **Postgres MCP** and follow the instructions - VS Code will add the entry to your `mcp.json` automatically\n\n> 💡 You can also open the MCP Servers panel via **Copilot chat icon → Manage MCP Servers** to browse, enable, or disable servers at any time.\n\nAfter installing, edit the generated entry in `.vscode/mcp.json` to add your `tool=` arguments and `env` key mappings as shown in the [Usage](#-usage-in-vs-code-mcpjson) section below.\n\n---\n\n## 🚀 Usage in VS Code (`mcp.json`)\n\n**Read-only (default - no `tool=` arguments needed):**\n\n```json\n{\n  \"servers\": {\n    \"Postgres Tools\": {\n      \"type\": \"stdio\",\n      \"command\": \"npx\",\n      \"args\": [\"@edelciomolina/postgres-mcp\"],\n      \"env\": {\n        \"MCP_KEY_HOST\":    \"DB_HOST\",\n        \"MCP_KEY_PORT\":    \"DB_PORT\",\n        \"MCP_KEY_NAME\":    \"DB_NAME\",\n        \"MCP_KEY_SSLMODE\": \"DB_SSLMODE\",\n        \"MCP_KEY_USER\":    \"DB_USER\",\n        \"MCP_KEY_PASS\":    \"DB_PASS\"\n      }\n    }\n  }\n}\n```\n\n**With write tools (explicit opt-in required):**\n\n```json\n{\n  \"servers\": {\n    \"Postgres Tools\": {\n      \"type\": \"stdio\",\n      \"command\": \"npx\",\n      \"args\": [\n        \"@edelciomolina/postgres-mcp\",\n        \"tool=pg_manage_schema\",\n        \"tool=pg_manage_indexes\"\n      ],\n      \"env\": {\n        \"POSTGRES_MCP_ALLOW_WRITE\": \"true\",\n        \"MCP_KEY_HOST\":    \"DB_HOST\",\n        \"MCP_KEY_PORT\":    \"DB_PORT\",\n        \"MCP_KEY_NAME\":    \"DB_NAME\",\n        \"MCP_KEY_SSLMODE\": \"DB_SSLMODE\",\n        \"MCP_KEY_USER\":    \"DB_USER\",\n        \"MCP_KEY_PASS\":    \"DB_PASS\"\n      }\n    }\n  }\n}\n```\n\n> ⚠️ Write-capable tools require `POSTGRES_MCP_ALLOW_WRITE=true` in `env`. Without it, the server exits at startup.\n\nThe corresponding `.env` file at the root of your project:\n\n```env\nDB_HOST=db.your-project.supabase.co\nDB_PORT=5432\nDB_NAME=postgres\nDB_SSLMODE=require\nDB_USER=readonly_user\nDB_PASS=your_password\n```\n\n---\n\n## ⚙️ How `mcp.json` configuration works\n\n### 🗝️ `env` - credential key mapping\n\nThe `env` block does **not** contain the actual credentials. It maps each `MCP_KEY_*` to the variable name in your `.env` file.\n\n| Key in `env`      | Points to `.env` variable   | Example value            |\n|-------------------|-----------------------------|--------------------------|\n| `MCP_KEY_URL`     | `DATABASE_URL`              | `postgresql://user:pass@host:5432/db?sslmode=require` |\n| `MCP_KEY_HOST`    | `DB_HOST`                   | `db.example.supabase.co` |\n| `MCP_KEY_PORT`    | `DB_PORT`                   | `5432`                   |\n| `MCP_KEY_NAME`    | `DB_NAME`                   | `postgres`               |\n| `MCP_KEY_SSLMODE` | `DB_SSLMODE`                | `require`                |\n| `MCP_KEY_USER`    | `DB_USER`                   | `readonly_user`          |\n| `MCP_KEY_PASS`    | `DB_PASS`                   | `secret`                 |\n\n> **Priority:** when `MCP_KEY_URL` (or `DATABASE_URL`) is present, the server uses the URL directly and **ignores** the individual credential keys.\n\nThis indirection lets you use **any variable name** in your `.env` - useful when sharing a `.env` across multiple services with different naming conventions.\n\n### 🔧 `args` - tool selection via `tool=` prefix\n\nEach enabled MCP tool is declared as a separate argument in the format `tool=<name>`:\n\n```json\n\"args\": [\n  \"-y\",\n  \"@edelciomolina/postgres-mcp\",\n  \"tool=pg_manage_schema\",\n  \"tool=pg_manage_indexes\"\n]\n```\n\nThis makes the tool list **explicit and auditable** directly in `mcp.json` - no hidden configuration files. 🔍\n\n---\n\n## 🔗 Connection via URL (`DATABASE_URL`)\n\nIn addition to individual credentials, you can provide a **full connection string** - the standard format on platforms like Supabase, Neon, and Railway.\n\n**`.env`:**\n```env\nDATABASE_URL=postgresql://user:password@host:5432/database?sslmode=require\n```\n\n**`mcp.json`:**\n```json\n{\n  \"servers\": {\n    \"Postgres Tools\": {\n      \"type\": \"stdio\",\n      \"command\": \"npx\",\n      \"args\": [\"-y\", \"@edelciomolina/postgres-mcp\"],\n      \"env\": {\n        \"MCP_KEY_URL\": \"DATABASE_URL\"\n      }\n    }\n  }\n}\n```\n\nThe variable mapped by `MCP_KEY_URL` has **priority** over the other keys (`MCP_KEY_HOST`, `MCP_KEY_PORT`, etc.). If the URL is present, the other variables are ignored.\n\nIf the platform uses a different name (e.g. `DB_URL`), just adjust the mapping:\n```json\n\"MCP_KEY_URL\": \"DB_URL\"\n```\n\n---\n\n## 🛡️ Why read-only is the default\n\nIf you omit all `tool=` arguments, the server starts with a **curated read-only set** - all tools that can retrieve, analyze, or explain data, but nothing that can modify it.\n\n**✅ Included in defaults (read-only):**\n\n```\npg_execute_query       pg_manage_query        pg_inspect_schema\npg_get_setup_instructions                     pg_analyze_database\npg_monitor_database                           pg_debug_database\npg_inspect_database_graph                     pg_describe_table_semantics\npg_find_related_tables                        pg_classify_query_risk\n```\n\n> 💡 `pg_execute_query` rejects `INSERT`, `UPDATE`, `DELETE`, DDL, `ANALYZE`, `VACUUM`, `EXPLAIN ANALYZE` and other write/maintenance commands before the database is queried.\n\n> 💡 `pg_inspect_schema` provides read-only schema introspection (`get_info`, `get_enums`). For DDL operations, use `pg_manage_schema` with explicit opt-in.\n\n**⚠️ Excluded from defaults - require `tool=` argument AND `POSTGRES_MCP_ALLOW_WRITE=true`:**\n\n| Tool | Operations |\n|------|-----------|\n| `pg_manage_schema` | CREATE TABLE, ALTER TABLE, CREATE TYPE |\n| `pg_manage_indexes` | CREATE INDEX, DROP INDEX, REINDEX |\n| `pg_manage_constraints` | ADD CONSTRAINT, DROP CONSTRAINT |\n| `pg_manage_functions` | CREATE FUNCTION, DROP FUNCTION |\n| `pg_manage_triggers` | CREATE TRIGGER, DROP TRIGGER, enable/disable |\n| `pg_manage_rls` | ENABLE/DISABLE RLS, CREATE/ALTER/DROP POLICY |\n| `pg_manage_users` | CREATE/DROP/ALTER USER, GRANT, REVOKE |\n| `pg_execute_mutation` | INSERT / UPDATE / DELETE / UPSERT |\n| `pg_execute_sql` | Arbitrary SQL with transaction support |\n\n---\n\n## 📍 `.env` file discovery\n\nThe server resolves the `.env` file in this order:\n\n1. **`env-file=<path>` argument** - explicit path relative to `cwd`; takes priority over everything\n2. **Upward search** - starting from `cwd`, searches each parent directory until a `.env` is found or the filesystem root is reached\n\nIf no `.env` is found, the server exits with a clear error message.\n\n### Monorepos and subfolders\n\nWhen VS Code starts the MCP process, `cwd` is typically the workspace root. If your `.env` is in a subfolder (e.g. `functions/.env`), use `env-file=` to point to it explicitly:\n\n```json\n{\n  \"servers\": {\n    \"Postgres Tools\": {\n      \"type\": \"stdio\",\n      \"command\": \"npx\",\n      \"args\": [\n        \"-y\",\n        \"@edelciomolina/postgres-mcp\",\n        \"env-file=functions/.env\"\n      ],\n      \"env\": {\n        \"MCP_KEY_HOST\":    \"DB_HOST\",\n        \"MCP_KEY_PORT\":    \"DB_PORT\",\n        \"MCP_KEY_NAME\":    \"DB_NAME\",\n        \"MCP_KEY_SSLMODE\": \"DB_SSLMODE\",\n        \"MCP_KEY_USER\":    \"DB_USER\",\n        \"MCP_KEY_PASS\":    \"DB_PASS\"\n      }\n    }\n  }\n}\n```\n\n> 💡 The upward search behavior handles the common case automatically. Use `env-file=` when you need explicit control (CI, monorepos, Docker bind-mounts).\n\n---\n\n## 🧰 Available tools\n\n### Read-only (enabled by default)\n\n| Tool | Description |\n|------|-------------|\n| `pg_execute_query` | SELECT / COUNT / EXISTS with write and multi-statement guards |\n| `pg_manage_query` | EXPLAIN plans, slow query analysis, `pg_stat_statements` |\n| `pg_inspect_schema` | Schema info and ENUM types (read-only introspection) |\n| `pg_get_setup_instructions` | Setup instructions per platform |\n| `pg_analyze_database` | Performance, configuration, and storage analysis |\n| `pg_monitor_database` | Real-time monitoring of connections, queries, locks, and replication |\n| `pg_debug_database` | Diagnose connections, locks, performance, and replication |\n| `pg_inspect_database_graph` | Build a full knowledge graph of the database: schemas, tables, columns, FKs, indexes, inferred relations, and business domains |\n| `pg_describe_table_semantics` | Describe a table with semantic context: risk level, column roles, sensitive columns, and related tables |\n| `pg_find_related_tables` | Find tables related to a given table via explicit FKs and inferred naming patterns, with path explanation |\n| `pg_classify_query_risk` | Classify query risk (`safe` / `warning` / `review` / `blocked`) without executing it |\n\n### Write-capable (opt-in via `tool=` argument + `POSTGRES_MCP_ALLOW_WRITE=true`)\n\n| Tool | Description |\n|------|-------------|\n| `pg_manage_schema` | Schema info, create/alter tables, manage ENUMs |\n| `pg_manage_indexes` | List, create, drop, reindex, analyze index usage |\n| `pg_manage_constraints` | List, create, and drop constraints and foreign keys |\n| `pg_manage_functions` | List, create, and drop functions and procedures |\n| `pg_manage_triggers` | List, create, drop, enable/disable triggers |\n| `pg_manage_rls` | Row-Level Security policies |\n| `pg_manage_users` | User permissions, create/drop/alter users, grant/revoke |\n| `pg_execute_mutation` | INSERT / UPDATE / DELETE / UPSERT with parameterized queries |\n| `pg_execute_sql` | Arbitrary SQL execution with optional transaction support |\n\n---\n\n## 🧠 Semantic Layer\n\nThe four `pg_*_graph` / `pg_*_semantics` / `pg_*_risk` tools build an in-memory knowledge graph of your database at runtime. This gives the LLM a structured map - schemas, tables, columns, foreign keys, inferred relations, risk levels, and business domains - **without executing any query against your data**.\n\nAll inferred fields (column semantic roles, table probable types, inferred relations) are clearly tagged so the LLM knows to treat them as hints, not schema facts.\n\n### Optional configuration (`mcp-config.json`)\n\nPlace a `mcp-config.json` file beside your `.env` to tune the semantic layer and security limits. All fields are optional - omitting the file applies safe defaults.\n\n```json\n{\n  \"security\": {\n    \"defaultLimit\": 100,\n    \"maxLimit\": 1000,\n    \"blockedSchemas\": [\"pg_catalog\", \"information_schema\"],\n    \"blockedTables\": [],\n    \"requireLimit\": true\n  },\n  \"semanticLayer\": {\n    \"enabled\": true,\n    \"inferRelationsWithoutForeignKeys\": true,\n    \"inferBusinessEntities\": true,\n    \"sensitiveKeywords\": [\"password\", \"secret\", \"token\", \"api_key\", \"ssn\", \"hash\"]\n  }\n}\n```\n\n---\n\n## 🏗️ Architecture\n\nFor a detailed view of the communication flow between the MCP client, the proxy, and PostgreSQL - including the full sequence diagram - see [ARCHITECT.md](ARCHITECT.md).\n\n---\n\n## 📄 License\n\nMIT © [Edelcio Molina](https://github.com/edelciomolina)\n\n","readmeFilename":"README.md"}