{"name":"io.github.edelciomolina/postgres-mcp","slug":"edelciomolina-postgres-mcp","title":"Postgres MCP","description":"PostgreSQL MCP wrapper with .env credential mapping, tool selection, and safe read-only defaults.","url":"https://mcp.market/server/edelciomolina-postgres-mcp","rating":null,"grade":"B","score":82,"certified":false,"status":"active","category":"data","tags":["data"],"presence":{"score":24,"stars":5,"forks":0,"downloads_week":110,"last_push_at":"2026-06-13T22:40:08.000Z","license":"NOASSERTION"},"uptime":null,"claimed":false,"transport":"npm","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/edelciomolina/postgres-mcp","website":null,"version":"1.7.0","remotes":[],"packages":[{"registryType":"npm","identifier":"@edelciomolina/postgres-mcp","version":"1.7.0","transport":{"type":"stdio"},"environmentVariables":[{"description":"Name of the .env variable that holds the database host","format":"string","name":"MCP_KEY_HOST"},{"description":"Name of the .env variable that holds the database port","format":"string","name":"MCP_KEY_PORT"},{"description":"Name of the .env variable that holds the database name","format":"string","name":"MCP_KEY_NAME"},{"description":"Name of the .env variable that holds the database user","format":"string","name":"MCP_KEY_USER"},{"description":"Name of the .env variable that holds the database password","format":"string","name":"MCP_KEY_PASS"},{"description":"Name of the .env variable that holds the SSL mode (e.g. require)","format":"string","name":"MCP_KEY_SSLMODE"}]}],"tools":[{"name":"pg_analyze_database","description":"Analyze PostgreSQL database performance and configuration.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_debug_database","description":"Diagnose common PostgreSQL issues - connections, locks, performance, replication.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_execute_mutation","description":"Execute data modification operations - INSERT, UPDATE, DELETE, or UPSERT. NOT enabled by default; must be opted-in via tool= arg.","write_action":true,"price_micros":0,"input_schema":null},{"name":"pg_execute_query","description":"Execute SELECT queries and data retrieval operations - operation=\"select/count/exists\" with query and optional parameters.","write_action":true,"price_micros":0,"input_schema":null},{"name":"pg_execute_sql","description":"Execute arbitrary SQL statements with optional transaction support. NOT enabled by default; must be opted-in via tool= arg.","write_action":true,"price_micros":0,"input_schema":null},{"name":"pg_get_setup_instructions","description":"Get platform-specific PostgreSQL setup and connection instructions.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_inspect_schema","description":"Inspect PostgreSQL schema - list tables and columns, view ENUM types. Read-only.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_manage_constraints","description":"Manage PostgreSQL constraints - get, create foreign keys, drop constraints.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_manage_functions","description":"Manage PostgreSQL functions - get, create, or drop functions.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_manage_indexes","description":"Manage PostgreSQL indexes - get, create, drop, reindex, and analyze usage.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_manage_query","description":"Manage PostgreSQL query analysis and performance - EXPLAIN plans, slow queries, statistics.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_manage_rls","description":"Manage PostgreSQL Row-Level Security - enable/disable RLS and manage policies.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_manage_schema","description":"Manage PostgreSQL schema - get schema info, create/alter tables, manage enums.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_manage_triggers","description":"Manage PostgreSQL triggers - get, create, drop, enable/disable.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_manage_users","description":"Manage PostgreSQL users and permissions - get permissions, create/drop/alter users, grant/revoke.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_monitor_database","description":"Get real-time monitoring information for a PostgreSQL database.","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":82,"grade":"B","scanned_at":"2026-09-27T05:30:31.970Z","report":{"scannerVersion":"0.1.9","scannedAt":"2026-09-27T05:30:31.983Z","components":{"code":{"score":25,"max":25,"notes":["3 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":8,"max":15,"notes":["last push 105 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":"@edelciomolina/postgres-mcp","version":"1.7.0","found":true,"license":"MIT","hasInstallScripts":false,"dependencyCount":3,"publishedAt":"2026-06-11T15:12:23.612Z","repositoryUrl":"git+https://github.com/edelciomolina/postgres-mcp.git","weeklyDownloads":110}],"repo":{"found":true,"owner":"edelciomolina","repo":"postgres-mcp","archived":false,"pushedAt":"2026-06-13T22:40:08Z","stars":5,"forks":0,"openIssues":0,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/4604923?v=4","ownerCreatedAt":"2013-06-03T21:04:41Z","license":"NOASSERTION"},"icon":{"url":"https://raw.githubusercontent.com/edelciomolina/postgres-mcp/main/icon.png","source":"registry","width":512,"height":512},"presence":{"stars":5,"forks":0,"downloadsWeek":110,"license":"NOASSERTION","lastPushAt":"2026-06-13T22:40:08.000Z","score":24}}}},"grade_history":[],"reviews":[]}