{"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\":[]}}","token":"eyJhbGciOiJSUzI1NiIsImtpZCI6IjM4ODI2YjE3LTZhMzAtNWY5Yi1iMTY5LThiZWI4MjAyZjcyMyIsInR5cCI6IkpXVCIsIng1dCI6InlrTmFZNHFNX3RhNGsyVGdaT0NFWUxrY1lsQSJ9.eyJhY3RvciI6Iml0c0hhZGRhZCIsImFjdG9yX2lkIjoiMTE0NzMyNjEiLCJhdWQiOiJicmFncHJvb2YtcmVwb3J0OjM2NjFlNDc2NWJjZDY5NWZlOTA0OWJkNGNlMjVkZTRhYzZhNDc3Njg5NWZkYmQzOWQ5ODkzOTIyZDc5YzEzY2EiLCJiYXNlX3JlZiI6IiIsImNoZWNrX3J1bl9pZCI6IjEzMzI2Mzk5NTM5OCIsImV2ZW50X25hbWUiOiJzY2hlZHVsZSIsImV4cCI6MTc5NDgyOTQyNiwiaGVhZF9yZWYiOiIiLCJpYXQiOjE3OTQ4MjkxMjYsImlzcyI6Imh0dHBzOi8vdG9rZW4uYWN0aW9ucy5naXRodWJ1c2VyY29udGVudC5jb20iLCJqb2Jfd29ya2Zsb3dfcmVmIjoiaXRzSGFkZGFkL2JyYWdwcm9vZi8uZ2l0aHViL3dvcmtmbG93cy9yZXBvcnQueW1sQHJlZnMvaGVhZHMvbWFpbiIsImpvYl93b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIiwianRpIjoiMjQzMGIyZDktMGNmZS00M2IyLTg2ODgtNDE0YjRkM2ExMTQxIiwibmJmIjoxNzk0ODI4ODI2LCJyZWYiOiJyZWZzL2hlYWRzL21haW4iLCJyZWZfcHJvdGVjdGVkIjoiZmFsc2UiLCJyZWZfdHlwZSI6ImJyYW5jaCIsInJlcG9zaXRvcnkiOiJpdHNIYWRkYWQvYnJhZ3Byb29mIiwicmVwb3NpdG9yeV9pZCI6IjE0NTQ2MjExODMiLCJyZXBvc2l0b3J5X293bmVyIjoiaXRzSGFkZGFkIiwicmVwb3NpdG9yeV9vd25lcl9pZCI6IjExNDczMjYxIiwicmVwb3NpdG9yeV92aXNpYmlsaXR5IjoicHVibGljIiwicnVuX2F0dGVtcHQiOiIxIiwicnVuX2lkIjoiNDM4NTcwNzAyMTYiLCJydW5fbnVtYmVyIjoiMjQiLCJydW5uZXJfZW52aXJvbm1lbnQiOiJnaXRodWItaG9zdGVkIiwic2hhIjoiZWFhZmZmZmFmNTIyNTVkMWI3N2RjNGFhY2ZmZGZhZjM1M2YwYzEyYyIsInN1YiI6InJlcG86aXRzSGFkZGFkQDExNDczMjYxL2JyYWdwcm9vZkAxNDU0NjIxMTgzOnJlZjpyZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvdyI6InJlcG9ydCIsIndvcmtmbG93X3JlZiI6Iml0c0hhZGRhZC9icmFncHJvb2YvLmdpdGh1Yi93b3JrZmxvd3MvcmVwb3J0LnltbEByZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIn0.epfnGhmW9Q8RirfvA9Nin-jRX_YX2O2fJhNpYTxSJXle8l1c0TbZVmcbTL0RtLCjgiDBBvNJfMpbTAMDh3AkCmRJPJ34_IH2VgZfejJTSX8G0EkR7oGBpGVT1lbd-wnO04RMbDLypO1RRyvSi0vs0xV5_Zow3d9-KpqtxwWDuYp8KlfCc3gdQWr6Am4yLhTrh3R0BRNQ5tU41VIdBGFWHt3siW35vGNofveHVAZGuv1bIvVNDhWH07sH54eZXyoQpKuicEd7Lsqtg4PJqHmXL3R4M_W97ONYntYgkwoYn1XGxWo7jv6fMoWl47PmQQalWx4Zcd7m0uaOMJ06fcn7Ww"}