{"name":"io.github.gouranshul/pg-perf-mcp","slug":"gouranshul-pg-perf-mcp","title":"PostgreSQL Performance (read-only)","description":"Read-only PostgreSQL performance diagnostics: slow queries, EXPLAIN, index advice, locks, functions","url":"https://mcp.market/server/gouranshul-pg-perf-mcp","rating":null,"grade":"B","score":73,"certified":false,"status":"active","category":"other","tags":[],"presence":{"score":18,"stars":0,"forks":0,"downloads_week":null,"last_push_at":"2026-10-12T04:19:18.000Z","license":"MIT"},"uptime":null,"claimed":false,"transport":"oci","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/gouranshul/pg-perf-mcp","website":"https://github.com/gouranshul/pg-perf-mcp#readme","version":"0.1.0","remotes":[],"packages":[{"registryType":"oci","identifier":"ghcr.io/gouranshul/pg-perf-mcp:0.1.0","transport":{"type":"streamable-http","url":"http://localhost:8080/mcp","headers":[{"description":"The same API key as MCP_API_KEY, sent as a bearer token","isRequired":true,"value":"Bearer {api_key}","isSecret":true,"variables":{"api_key":{"description":"The value you set for MCP_API_KEY","isRequired":true,"isSecret":true}},"name":"Authorization"}]},"runtimeArguments":[{"description":"Publish the MCP endpoint on localhost only","value":"127.0.0.1:8080:8080","type":"named","name":"-p"}],"environmentVariables":[{"description":"JDBC URL of the database to diagnose. From inside the container, use host.docker.internal for a database on your machine, e.g. jdbc:postgresql://host.docker.internal:5432/mydb","isRequired":true,"name":"PGPERF_DB_URL"},{"description":"A read-only role with pg_read_all_stats and pg_monitor (see docker/init.sql)","isRequired":true,"default":"mcp_readonly","name":"PGPERF_DB_USER"},{"description":"Password of that role","isRequired":true,"isSecret":true,"name":"PGPERF_DB_PASSWORD"},{"description":"Bearer token clients must send, at least 16 characters (32+ random recommended)","isRequired":true,"isSecret":true,"name":"MCP_API_KEY"}]}],"tools":[],"scan":{"score":73,"grade":"B","scanned_at":"2026-10-13T01:13:08.594Z","report":{"scannerVersion":"0.1.10","scannedAt":"2026-10-13T01:13:08.526Z","components":{"code":{"score":-1,"max":25,"notes":["package could not be 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":6,"max":15,"notes":["static API keys via environment variables"]},"maintenance":{"score":15,"max":15,"notes":["last push 1 days ago"]},"identity":{"score":8,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[],"repo":{"found":true,"owner":"gouranshul","repo":"pg-perf-mcp","archived":false,"pushedAt":"2026-10-12T04:19:18Z","stars":0,"forks":0,"openIssues":1,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/17107863?v=4","ownerCreatedAt":"2016-02-07T10:45:21Z","license":"MIT"},"icon":{"url":"https://avatars.githubusercontent.com/u/17107863?v=4&s=128","source":"github"},"presence":{"stars":0,"forks":0,"downloadsWeek":null,"license":"MIT","lastPushAt":"2026-10-12T04:19:18.000Z","score":18}}}},"grade_history":[],"reviews":[]}