{"_id":"@apono-io/mcp-postgres","_rev":"9-a89fd56bafa37f02f276a6dafbfdd965","name":"@apono-io/mcp-postgres","dist-tags":{"latest":"0.2.0"},"versions":{"0.0.1":{"name":"@apono-io/mcp-postgres","version":"0.0.1","author":{"name":"Apono"},"license":"ISC","_id":"@apono-io/mcp-postgres@0.0.1","maintainers":[{"name":"dima.g_apono.io","email":"dima.g@apono.io"},{"name":"tidharm","email":"tidharm@gmail.com"}],"bin":{"apono-mcp-postgres":"dist/index.js"},"dist":{"shasum":"7526f256909ce4a63e94fe56c11adb50da86a5d9","tarball":"https://registry.npmjs.org/@apono-io/mcp-postgres/-/mcp-postgres-0.0.1.tgz","fileCount":18,"integrity":"sha512-/Y4Ifc1BOS/+AM4P5C1DYEDuw0/oJV2xNAYaZvEUiHX98M16WZgqIR8+DC1t5tYLBjkCxUK6TLlTj4vLwD0FjQ==","signatures":[{"sig":"MEUCIQCLdgUIxiUJHbyKZP+jpnDJsZ76U5Mmd+CjXiwNQB8mgQIgc2XYO8IKbCIdzd4lLPeUjfFRDvu+AVEBhZ8CExC5dE0=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":19660},"main":"dist/index.js","type":"module","types":"dist/index.d.ts","gitHead":"2d4456804a4620e8b9a1d5726bbee33024f9c709","scripts":{"test":"vitest run","build":"tsc","prepublishOnly":"npm run build"},"_npmUser":{"name":"dima.g_apono.io","email":"dima.g@apono.io"},"_npmVersion":"10.9.4","description":"Apono MCP server for PostgreSQL databases with JIT credential support","directories":{},"_nodeVersion":"22.21.1","dependencies":{"pg":"^8.13.0","zod":"^3.24.0","@modelcontextprotocol/sdk":"^1.12.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"vitest":"^3.0.0","@types/pg":"^8.11.0","typescript":"^5.7.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-postgres_0.0.1_1773755269977_0.02833253329274177","host":"s3://npm-registry-packages-npm-production"}},"0.0.2":{"name":"@apono-io/mcp-postgres","version":"0.0.2","author":{"name":"Apono"},"license":"ISC","_id":"@apono-io/mcp-postgres@0.0.2","maintainers":[{"name":"dima.g_apono.io","email":"dima.g@apono.io"},{"name":"tidharm","email":"tidharm@gmail.com"}],"bin":{"apono-mcp-postgres":"dist/index.js"},"dist":{"shasum":"d2b7367a3fffbf55caf90f99e7d02d4a572a0a4a","tarball":"https://registry.npmjs.org/@apono-io/mcp-postgres/-/mcp-postgres-0.0.2.tgz","fileCount":22,"integrity":"sha512-DBu98QSwaZytebLsGIv9ikxOOm9fuhvdlcj/jUN/6iB3gDqIPxS7YvFTU+WuOoova9Dt36YXMLBm+i3is2v26Q==","signatures":[{"sig":"MEYCIQDK2+baZvt/ayULfJKzF7ETx3ok0ZIzdmzyxReKI+uUIAIhANqpVXvFhcsY8RxF6ZmvjNuroZHEtYNos7PyQO3LZLSv","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":21784},"main":"dist/index.js","type":"module","types":"dist/index.d.ts","gitHead":"2d4456804a4620e8b9a1d5726bbee33024f9c709","scripts":{"test":"vitest run","build":"tsc","prepublishOnly":"npm run build"},"_npmUser":{"name":"dima.g_apono.io","email":"dima.g@apono.io"},"_npmVersion":"10.9.4","description":"Apono MCP server for PostgreSQL databases with JIT credential support","directories":{},"_nodeVersion":"22.21.1","dependencies":{"pg":"^8.13.0","zod":"^3.24.0","@modelcontextprotocol/sdk":"^1.12.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"vitest":"^3.0.0","@types/pg":"^8.11.0","typescript":"^5.7.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-postgres_0.0.2_1773756465679_0.9684753240608766","host":"s3://npm-registry-packages-npm-production"}},"0.0.3":{"name":"@apono-io/mcp-postgres","version":"0.0.3","author":{"name":"Apono"},"license":"ISC","_id":"@apono-io/mcp-postgres@0.0.3","maintainers":[{"name":"dima.g_apono.io","email":"dima.g@apono.io"},{"name":"tidharm","email":"tidharm@gmail.com"}],"bin":{"apono-mcp-postgres":"dist/index.js"},"dist":{"shasum":"dc878d0f9c722821272ed0a81f0e5837aa92ce10","tarball":"https://registry.npmjs.org/@apono-io/mcp-postgres/-/mcp-postgres-0.0.3.tgz","fileCount":22,"integrity":"sha512-SkCwwSaqXRf7x90ujFbmZjN7Nm4Ehxcmz1VotCORz8HzlrzNDo/jVy5GqGPPMKNZPmhaxXaOk39z9JVZsU2BDw==","signatures":[{"sig":"MEUCIQD4McaQ8MJew5eQCjSvTo+0oNToOkQTt6rp1fLZETCoXAIgQWm/oQMzA+KIY63Bi7r/6EL1kjfQCgx0/iLZjGYs6fA=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":21784},"main":"dist/index.js","type":"module","types":"dist/index.d.ts","gitHead":"2d4456804a4620e8b9a1d5726bbee33024f9c709","scripts":{"test":"vitest run","build":"tsc","prepublishOnly":"npm run build"},"_npmUser":{"name":"dima.g_apono.io","email":"dima.g@apono.io"},"_npmVersion":"10.9.4","description":"Apono MCP server for PostgreSQL databases with JIT credential support","directories":{},"_nodeVersion":"22.21.1","dependencies":{"pg":"^8.13.0","zod":"^3.24.0","@modelcontextprotocol/sdk":"^1.12.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"vitest":"^3.0.0","@types/pg":"^8.11.0","typescript":"^5.7.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-postgres_0.0.3_1773756885025_0.8901640726385773","host":"s3://npm-registry-packages-npm-production"}},"0.1.0":{"name":"@apono-io/mcp-postgres","version":"0.1.0","author":{"name":"Apono"},"license":"ISC","_id":"@apono-io/mcp-postgres@0.1.0","maintainers":[{"name":"dima.g_apono.io","email":"dima.g@apono.io"},{"name":"tidharm","email":"tidharm@gmail.com"}],"bin":{"apono-mcp-postgres":"dist/index.js"},"dist":{"shasum":"f6f9544465226a69451b0d273b8ae521dc60ed52","tarball":"https://registry.npmjs.org/@apono-io/mcp-postgres/-/mcp-postgres-0.1.0.tgz","fileCount":22,"integrity":"sha512-L5twgs2ffy4H744MzWVBPout33h9l/phuoMd+dyJIeo+GwAvi+fyWEyyLd9f5ttTsKwdHroSUce8R2QQsJOcfw==","signatures":[{"sig":"MEUCIQCSvsyGzf3rxzbADuDcYWqCAtXmPQDbp9ZkZA5bQB3t+AIgW5gKhEHElHG8lT3X97/BdGbv4vBXuptrFRGrq6/SO18=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":22038},"main":"dist/index.js","type":"module","types":"dist/index.d.ts","gitHead":"73299e6baf419379993e1bcb2e3b48d0b8d9c0b8","scripts":{"test":"vitest run","build":"tsc","prepublishOnly":"npm run build"},"_npmUser":{"name":"dima.g_apono.io","email":"dima.g@apono.io"},"_npmVersion":"10.9.4","description":"Apono MCP server for PostgreSQL databases with JIT credential support","directories":{},"_nodeVersion":"22.21.1","dependencies":{"pg":"^8.13.0","zod":"^3.24.0","@modelcontextprotocol/sdk":"^1.12.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"vitest":"^3.0.0","@types/pg":"^8.11.0","typescript":"^5.7.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-postgres_0.1.0_1773844007225_0.8863288055176586","host":"s3://npm-registry-packages-npm-production"}},"0.1.1":{"name":"@apono-io/mcp-postgres","version":"0.1.1","author":{"name":"Apono"},"license":"ISC","_id":"@apono-io/mcp-postgres@0.1.1","maintainers":[{"name":"dima.g_apono.io","email":"dima.g@apono.io"},{"name":"tidharm","email":"tidharm@gmail.com"}],"bin":{"apono-mcp-postgres":"dist/index.js"},"dist":{"shasum":"5e8afd6db6e59060258585821658852ddf5dbb6c","tarball":"https://registry.npmjs.org/@apono-io/mcp-postgres/-/mcp-postgres-0.1.1.tgz","fileCount":22,"integrity":"sha512-PosEeYxg0tyPdObryIwMJzTM1/hkycdbUF1/vS/GI/pnq3v1opVVV4YX/wEg7/fTAFtt8UzyqS34gj340FkfAg==","signatures":[{"sig":"MEQCIAql2QvFJ28GESuPDrODhM7/MM/vMVJLAM3dFinOAY33AiB1tksw2MPSo60hbBe1O3D9ksqRHcZQ+7ZsYflnYC4iqQ==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":22038},"main":"dist/index.js","type":"module","types":"dist/index.d.ts","gitHead":"e3021f8d1d7df0195e3a2cd333c67ca9df6fe640","scripts":{"test":"vitest run","build":"tsc","prepublishOnly":"npm run build"},"_npmUser":{"name":"dima.g_apono.io","email":"dima.g@apono.io"},"_npmVersion":"10.9.4","description":"Apono MCP server for PostgreSQL databases with JIT credential support","directories":{},"_nodeVersion":"22.22.1","dependencies":{"pg":"^8.13.0","zod":"^3.24.0","@modelcontextprotocol/sdk":"^1.12.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"vitest":"^3.0.0","@types/pg":"^8.11.0","typescript":"^5.7.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-postgres_0.1.1_1773845766190_0.8382346787582824","host":"s3://npm-registry-packages-npm-production"}},"0.2.0":{"name":"@apono-io/mcp-postgres","version":"0.2.0","author":{"name":"Apono"},"license":"ISC","_id":"@apono-io/mcp-postgres@0.2.0","maintainers":[{"name":"dima.g_apono.io","email":"dima.g@apono.io"},{"name":"ofir76","email":"ofir@apono.io"}],"bin":{"apono-mcp-postgres":"dist/index.js"},"dist":{"shasum":"0e082739cb87fe4dc5e2e1766a396fd2525d7bb7","tarball":"https://registry.npmjs.org/@apono-io/mcp-postgres/-/mcp-postgres-0.2.0.tgz","fileCount":26,"integrity":"sha512-lj5xAzFYBqOYiZGzz1Z2TYT27xb4xLR745KMNgmY3AAlhu5zmdYuLtT4Frszts7wmz+v6q7ppLR36ex79/qRWg==","signatures":[{"sig":"MEYCIQDbx6Jz2Y994j8mIVDUgzeNgHeSTqo93ElupKg7ukxbqgIhAOfYzFrWHhLnMkucCoFO6nBTwcADTndRz+cRtggVkj0z","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":29786},"main":"dist/index.js","type":"module","types":"dist/index.d.ts","gitHead":"af3dd688862876ab8f5a1299e912a8986bc2ab3f","scripts":{"test":"vitest run","build":"tsc","prepublishOnly":"npm run build"},"_npmUser":{"name":"dima.g_apono.io","email":"dima.g@apono.io"},"_npmVersion":"10.9.8","description":"Apono MCP server for PostgreSQL databases with JIT credential support","directories":{},"_nodeVersion":"22.23.1","dependencies":{"pg":"^8.13.0","zod":"^3.24.0","@modelcontextprotocol/sdk":"^1.12.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"vitest":"^3.0.0","@types/pg":"^8.11.0","typescript":"^5.7.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-postgres_0.2.0_1785143575161_0.36990944150199634","host":"s3://npm-registry-packages-npm-production"}}},"time":{"created":"2026-03-17T13:47:49.874Z","modified":"2026-07-27T10:34:23.807Z","0.0.1":"2026-03-17T13:47:50.127Z","0.0.2":"2026-03-17T14:07:45.831Z","0.0.3":"2026-03-17T14:14:45.212Z","0.1.0":"2026-03-18T14:26:47.378Z","0.1.1":"2026-03-18T14:56:06.345Z","0.2.0":"2026-07-27T09:12:55.298Z"},"author":{"name":"Apono"},"license":"ISC","description":"Apono MCP server for PostgreSQL databases with JIT credential support","maintainers":[{"email":"dima.g@apono.io","name":"dima.g_apono.io"},{"email":"ofir@apono.io","name":"ofir76"},{"email":"matan.bd@apono.io","name":"matanbd"}],"readme":"# @apono-io/mcp-postgres\n\nApono MCP server for PostgreSQL databases with JIT credential support.\n\n## Tools\n\n| Tool | Description |\n|------|------------|\n| `query` | Execute a read-only SQL SELECT query and return results |\n| `execute` | Execute a SQL statement that modifies data (INSERT, UPDATE, DELETE) |\n| `list_schemas` | List all schemas in the database |\n| `list_tables` | List all tables in a schema |\n| `describe_table` | Get column names, types, constraints, and indexes for a table |\n| `list_extensions` | List installed PostgreSQL extensions |\n| `get_table_indexes` | List indexes on a specific table |\n| `explain_query` | Get the execution plan for a SQL query |\n\nAll tools accept a `database` parameter to specify which database to operate on.\n\n## Environment Variables\n\n| Variable | Description |\n|----------|------------|\n| `POSTGRES_HOST` | PostgreSQL server hostname |\n| `POSTGRES_PORT` | PostgreSQL server port (default: 5432) |\n| `POSTGRES_USER` | Database username |\n| `POSTGRES_PASSWORD` | Database password |\n","readmeFilename":"README.md"}