{"name":"io.github.ofershap/postgres","slug":"ofershap-postgres","title":null,"description":"PostgreSQL MCP — query databases, inspect schemas, explain queries.","url":"https://mcp.market/server/ofershap-postgres","rating":null,"grade":"A","score":88,"certified":false,"status":"active","category":"data","tags":["data"],"presence":{"score":17,"stars":0,"forks":0,"downloads_week":25,"last_push_at":"2026-08-12T09:10:15.000Z","license":"MIT"},"uptime":null,"claimed":false,"transport":"npm","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/ofershap/mcp-server-postgres","website":null,"version":"1.0.0","remotes":[],"packages":[{"registryType":"npm","identifier":"mcp-pg-server","version":"1.0.0","transport":{"type":"stdio"}}],"tools":[{"name":"explain","description":"Explain the execution plan for a SQL query (EXPLAIN FORMAT TEXT, optional ANALYZE).","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_schemas","description":"List non-system PostgreSQL schemas in the connected database.","write_action":false,"price_micros":0,"input_schema":null},{"name":"query","description":"Execute a SQL query against PostgreSQL. Returns results as a formatted table. Read-only by default.","write_action":true,"price_micros":0,"input_schema":null},{"name":"schema","description":"Get tables in a PostgreSQL schema with columns and approximate row counts.","write_action":false,"price_micros":0,"input_schema":null},{"name":"table_info","description":"Get detailed info about a single table: columns, types, constraints, and exact row count.","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":88,"grade":"A","scanned_at":"2026-09-23T17:16:33.126Z","report":{"scannerVersion":"0.1.9","scannedAt":"2026-09-23T17:16:33.151Z","components":{"code":{"score":25,"max":25,"notes":["2 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":12,"max":15,"notes":["local package, no credentials required"]},"maintenance":{"score":12,"max":15,"notes":["last push 42 days ago"]},"identity":{"score":8,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[{"registryType":"npm","identifier":"mcp-pg-server","version":"1.0.0","found":true,"license":"MIT","hasInstallScripts":false,"dependencyCount":3,"publishedAt":"2026-08-12T17:38:58.801Z","repositoryUrl":"git+https://github.com/ofershap/mcp-server-postgres.git","weeklyDownloads":25}],"repo":{"found":true,"owner":"ofershap","repo":"mcp-server-postgres","archived":false,"pushedAt":"2026-08-12T09:10:15Z","stars":0,"forks":0,"openIssues":0,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/2589702?v=4","ownerCreatedAt":"2012-10-18T13:50:43Z","license":"MIT"},"icon":{"url":"https://avatars.githubusercontent.com/u/2589702?v=4&s=128","source":"github"},"presence":{"stars":0,"forks":0,"downloadsWeek":25,"license":"MIT","lastPushAt":"2026-08-12T09:10:15.000Z","score":17}}}},"grade_history":[],"reviews":[]}