{"name":"io.github.marcelo-ochoa/postgres","slug":"marcelo-ochoa-postgres","title":null,"description":"MCP server for interacting with PostgreSQL databases","url":"https://mcp.market/server/marcelo-ochoa-postgres","rating":null,"grade":"B","score":78,"certified":false,"status":"active","category":"data","tags":["data"],"presence":{"score":22,"stars":2,"forks":0,"downloads_week":30,"last_push_at":"2026-08-21T17:58:48.000Z","license":"NOASSERTION"},"uptime":null,"claimed":false,"transport":"npm","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/marcelo-ochoa/servers","website":null,"version":"1.0.8","remotes":[],"packages":[{"registryType":"npm","identifier":"@marcelo-ochoa/server-postgres","version":"1.0.8","transport":{"type":"stdio"},"packageArguments":[{"description":"PostgreSQL connection string","type":"positional","valueHint":"connectionString"}],"environmentVariables":[{"description":"PostgreSQL user","format":"string","name":"POSTGRES_USER"},{"description":"PostgreSQL password","format":"string","isSecret":true,"name":"POSTGRES_PASSWORD"}]}],"tools":[{"name":"pg-awr","description":"Generate a PostgreSQL performance report similar to Oracle AWR. Includes database statistics, top queries (requires pg_stat_statements extension), table/index statistics, connection info, and optimization recommendations.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg-connect","description":"Provides an interface to connect to a specified PostgreSQL database. If a database connection is already active, the tool will close the existing connection before establishing a new one. This tool accepts three required parameters: \\tconnectionString: The PostgreSQL connection string without embedded credentials (e.g., postgresql://host:port/dbname or host:port/dbname). To enable encryption (SSL)","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg-explain","description":"Generate and display the execution plan for a given SQL query using PostgreSQL's EXPLAIN command. This tool helps you understand how PostgreSQL will execute your query, including information about table scans, joins, indexes used, and estimated costs. Args: \\tsql: The SQL query to explain. The `model` argument should specify only the name and version of the LLM (Large Language Model) you are using","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg-query","description":"This tool executes SQL queries in a READ ONLY session connected to a PostgreSQL database. If no active connection exists, it uses MCP server registration argument and environment variables PG_USER and PG_PASSWORD. You should: \\tExecute the provided SQL query. \\tReturn the results in Toon format. Args: \\tsql: The SQL query to execute. The `model` argument should specify only the name and version of","write_action":true,"price_micros":0,"input_schema":null},{"name":"pg-stats","description":"Get comprehensive statistics for a specific PostgreSQL table. This tool retrieves detailed information including row counts, table size, index information, column statistics, and other metadata that can help optimize queries and understand data distribution. Args: \\tname: The name of the table to get statistics for. The `model` argument should specify only the name and version of the LLM (Large La","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":78,"grade":"B","scanned_at":"2026-09-28T06:07:00.844Z","report":{"scannerVersion":"0.1.10","scannedAt":"2026-09-28T06:07:00.826Z","components":{"code":{"score":25,"max":25,"notes":["12 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":6,"max":15,"notes":["static API keys via environment variables"]},"maintenance":{"score":12,"max":15,"notes":["last push 38 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":"@marcelo-ochoa/server-postgres","version":"1.0.8","found":true,"license":"MIT","hasInstallScripts":false,"dependencyCount":3,"publishedAt":"2026-03-11T18:05:19.151Z","repositoryUrl":"git+https://github.com/marcelo-ochoa/servers.git","weeklyDownloads":30}],"repo":{"found":true,"owner":"marcelo-ochoa","repo":"servers","archived":false,"pushedAt":"2026-08-21T17:58:48Z","stars":2,"forks":0,"openIssues":0,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/16995718?v=4","ownerCreatedAt":"2016-02-01T00:57:08Z","license":"NOASSERTION"},"icon":{"url":"https://avatars.githubusercontent.com/u/16995718?v=4&s=128","source":"github"},"presence":{"stars":2,"forks":0,"downloadsWeek":30,"license":"NOASSERTION","lastPushAt":"2026-08-21T17:58:48.000Z","score":22}}}},"grade_history":[],"reviews":[]}