io.github.timescale/pg-aiguide
Comprehensive PostgreSQL documentation and best practices, including ecosystem tools
io.github.timescale/pg-aiguide · Repository · version 0.5.1 · 1.8k stars · listed from registry
Install
The sweep installs into a clean prefix, but this is the command a user would run:
npx @tigerdata/pg-aiguide
Needs credentials: OPENAI_API_KEY, PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE. The probe used placeholder values, so an amber needs credentials result below means the server asked for the real ones, not that it is broken. Maintainers: how to go green.
Results by platform
Linux
needs credentials2026-08-16 · probed over npm1 recorded run, oldest first.
handshake failed: MCP error -32000: Connection closed
--- stderr (tail) ---
starting server...
Running database migrations...
Database migration failed: RangeError [ERR_SOCKET_BAD_PORT]: Port should be >= 0 and < 65536. Received type number (NaN).
at lookupAndConnect (node:net:1331:5)
at Socket.connect (node:net:1286:5)
at Connection.connect (/tmp/does-it-install/dii-npm-vhTE8j/node_modules/pg/lib/connection.js:45:17)
at Client._connect (/tmp/does-it-install/dii-npm-vhTE8j/node_modules/pg/lib/client.js:181:11)
at /tmp/does-it-install/dii-npm-vhTE8j/node_modules/pg/lib/client.js:239:12
at new Promise (<anonymous>)
at Client.connect (/tmp/does-it-install/dii-npm-vhTE8j/node_modules/pg/lib/client.js:238:12)
at Object.load (file:///tmp/does-it-install/dii-npm-vhTE8j/node_modules/@tigerdata/mcp-boilerplate/dist/migrate.js:14:30)
at loadMigrationsIntoSet (/tmp/does-it-install/dii-npm-vhTE8j/node_modules/migrate/lib/load-migrations.js:68:9)
at exports.load (/tmp/does-it-install/dii-npm-vhTE8j/node_modules/migrate/index.js:53:3) {
code: 'ERR_SOCKET_BAD_PORT'
}
macOS
needs credentials2026-08-16 · probed over npm1 recorded run, oldest first.
handshake failed: MCP error -32000: Connection closed
--- stderr (tail) ---
starting server...
Running database migrations...
Database migration failed: RangeError [ERR_SOCKET_BAD_PORT]: Port should be >= 0 and < 65536. Received type number (NaN).
at lookupAndConnect (node:net:1331:5)
at Socket.connect (node:net:1286:5)
at Connection.connect (/private/var/folders/df/djsxfhc17x95674wsm_g8s980000gn/T/does-it-install/dii-npm-SfXLPo/node_modules/pg/lib/connection.js:45:17)
at Client._connect (/private/var/folders/df/djsxfhc17x95674wsm_g8s980000gn/T/does-it-install/dii-npm-SfXLPo/node_modules/pg/lib/client.js:181:11)
at /private/var/folders/df/djsxfhc17x95674wsm_g8s980000gn/T/does-it-install/dii-npm-SfXLPo/node_modules/pg/lib/client.js:239:12
at new Promise (<anonymous>)
at Client.connect (/private/var/folders/df/djsxfhc17x95674wsm_g8s980000gn/T/does-it-install/dii-npm-SfXLPo/node_modules/pg/lib/client.js:238:12)
at Object.load (file:///private/var/folders/df/djsxfhc17x95674wsm_g8s980000gn/T/does-it-install/dii-npm-SfXLPo/node_modules/@tigerdata/mcp-boilerplate/dist/migrate.js:14:30)
at loadMigrationsIntoSet (/private/var/folders/df/djsxfhc17x95674wsm_g8s980000gn/T/does-it-install/dii-npm-SfXLPo/node_modules/migrate/lib/load-migrations.js:68:9)
at exports.load (/private/var/folders/df/djsxfhc17x95674wsm_g8s980000gn/T/does-it-install/dii-npm-SfXLPo/node_modules/migrate/index.js:53:3) {
code: 'ERR_SOCKET_BAD_PORT'
}
Windows
needs credentials2026-08-16 · probed over npm1 recorded run, oldest first.
handshake failed: MCP error -32000: Connection closed
--- stderr (tail) ---
starting server...
Running database migrations...
Database migration failed: RangeError [ERR_SOCKET_BAD_PORT]: Port should be >= 0 and < 65536. Received type number (NaN).
at lookupAndConnect (node:net:1331:5)
at Socket.connect (node:net:1286:5)
at Connection.connect (C:\Users\RUNNER~1\AppData\Local\Temp\does-it-install\dii-npm-oyj3cX\node_modules\pg\lib\connection.js:45:17)
at Client._connect (C:\Users\RUNNER~1\AppData\Local\Temp\does-it-install\dii-npm-oyj3cX\node_modules\pg\lib\client.js:181:11)
at C:\Users\RUNNER~1\AppData\Local\Temp\does-it-install\dii-npm-oyj3cX\node_modules\pg\lib\client.js:239:12
at new Promise (<anonymous>)
at Client.connect (C:\Users\RUNNER~1\AppData\Local\Temp\does-it-install\dii-npm-oyj3cX\node_modules\pg\lib\client.js:238:12)
at Object.load (file:///C:/Users/RUNNER%7E1/AppData/Local/Temp/does-it-install/dii-npm-oyj3cX/node_modules/@tigerdata/mcp-boilerplate/dist/migrate.js:14:30)
at loadMigrationsIntoSet (C:\Users\RUNNER~1\AppData\Local\Temp\does-it-install\dii-npm-oyj3cX\node_modules\migrate\lib\load-migrations.js:68:9)
at exports.load (C:\Users\RUNNER~1\AppData\Local\Temp\does-it-install\dii-npm-oyj3cX\node_modules\migrate\index.js:53:3) {
code: 'ERR_SOCKET_BAD_PORT'
}
Badge
Paste this into the project README to show the current result:
[](https://doesitinstall.com/s/io.github.timescale__pg-aiguide.html)