{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","name":"io.github.gouranshul/pg-perf-mcp","description":"Read-only PostgreSQL performance diagnostics: slow queries, EXPLAIN, index advice, locks, functions","title":"PostgreSQL Performance (read-only)","repository":{"url":"https://github.com/gouranshul/pg-perf-mcp","source":"github"},"version":"0.1.0","websiteUrl":"https://github.com/gouranshul/pg-perf-mcp#readme","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"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2026-10-10T13:42:12.172523Z","publishedAt":"2026-10-10T13:42:12.172523Z","updatedAt":"2026-10-10T13:42:12.172523Z","isLatest":true}}}