{"report":{"v":1,"package":"mcp-postgres-server","version":"0.3.1","ranAt":"2026-11-16T11:38:35.782Z","install":{"ok":true,"integrity":"sha512-0FFBZlA/xc8A/JIQVfMD+jFZovmk6amYovuF+YfBEwZRpooc7Q4pDi3QRSMCPWYdUGWnAEGBhKGKBUzMAyK+FQ==","deps":116,"scripts":["cpu-features","ssh2"],"bins":["mcp-postgres"],"license":"MIT","engines":"node >=20","repository":"git+https://github.com/antonorlov/mcp-postgres-server.git","bin":"mcp-postgres"},"start":{"ok":true,"ms":132,"serverName":"postgres-server","serverVersion":"0.3.1","protocol":"2025-06-18","stderr":"[postgres-server] v0.3.1 running on stdio in read-only mode (set PG_ALLOW_WRITE=true to enable writes)\n"},"tools":[{"name":"query","description":"Run one read-only SQL statement against the connected PostgreSQL database and get rows back as JSON. Send exactly one statement per call (SELECT, WITH, EXPLAIN, or SHOW). It runs inside an engine-enforced read-only transaction, so any write is refused by the database. Use this tool for all data reading, aggregation, and query planning. Returns {rows, rowCount, returnedRows, truncated}, plus hint when truncated is true. Prefer $1, $2 placeholders with the params array over interpolating values. Results are capped at ~32768 bytes; truncated:true means rows were dropped - add LIMIT/WHERE or select fewer columns.","params":["sql","params"]},{"name":"execute","description":"Run a data-modifying SQL statement (INSERT/UPDATE/DELETE or DDL). Currently DISABLED: the server is read-only, so this returns an error and changes nothing. To enable writes, the operator must start the server with PG_ALLOW_WRITE=true.","params":["sql","params"]},{"name":"list_schemas","description":"List every schema in the connected database. Start here when exploring an unfamiliar database, then call list_tables for the schema you care about. Returns {schemas: [name, ...]}.","params":[]},{"name":"list_tables","description":"List all tables in a schema (default: 'public'). Use this before querying tables you have not seen yet, then call describe_table for column details. Returns {tables: [name, ...]}.","params":["schema"]},{"name":"describe_table","description":"Show the structure of one table: column names, data types, nullability, defaults, and primary-key membership. Call this before writing non-trivial queries against a table. Returns {columns: [{column, type, nullable, default, is_primary_key}, ...]}.","params":["table","schema"]}],"toolsHash":"bd025f8412f64369e1bb1b35b33f838b46951bb891dc92c668b5ff83069eb952","wrote":[],"callsAt":"2026-11-16T11:38:41.460Z","calls":[{"tool":"list_schemas","ok":false,"ms":4,"bytes":0,"error":"tool reported an error: {\"message\":\"no database configured: set DATABASE_URL or PG_HOST/PG_USER/PG_PASSWORD/PG_DATABASE (or set PG_ENABLE_RUNTIME_CONNECT=true and use connect_db)\"}"},{"tool":"list_tables","ok":false,"ms":1,"bytes":0,"error":"tool reported an error: {\"message\":\"no database configured: set DATABASE_URL or PG_HOST/PG_USER/PG_PASSWORD/PG_DATABASE (or set PG_ENABLE_RUNTIME_CONNECT=true and use connect_db)\"}"}],"host":{"commit":"eaaffffaf52255d1b77dc4aacffdfaf353f0c12c","run":"https://github.com/itsHaddad/bragproof/actions/runs/43857070216"},"network":{"names":["registry.npmjs.org"],"conns":[],"callNames":[],"callConns":[]}},"summary":{"outcome":"started","needs":[],"contacts":[],"flags":[],"tools":5,"wrote":0,"callsTried":2,"callsAnswered":0,"callContacts":[]},"history":[{"package":"mcp-postgres-server","version":"0.3.1","ranAt":"2026-11-16T11:38:35.782Z","outcome":"started","tools":5,"contacts":0,"flags":0,"serious":0,"toolsHash":"bd025f8412f64369e1bb1b35b33f838b46951bb891dc92c668b5ff83069eb952"}],"page":"https://bragproof.smaverk.com/r/mcp-postgres-server"}