{"name":"io.github.itunified-io/postgres","slug":"itunified-io-postgres","title":"PostgreSQL MCP Server","description":"PostgreSQL MCP Server — 27 tools for queries, schema, CRUD, DBA, HA & server management","url":"https://mcp.market/server/itunified-io-postgres","rating":null,"grade":"C","score":65,"certified":false,"status":"active","category":"data","tags":["data"],"presence":{"score":7,"stars":null,"forks":null,"downloads_week":25,"last_push_at":null,"license":"AGPL-3.0-only"},"uptime":null,"claimed":false,"transport":"npm","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/itunified-io/mcp-postgres","website":null,"version":"2026.4.10","remotes":[],"packages":[{"registryType":"npm","identifier":"@itunified.io/mcp-postgres","version":"2026.4.10-1","runtimeHint":"npx","transport":{"type":"stdio"},"environmentVariables":[{"description":"PostgreSQL connection string (e.g. postgresql://user:pass@host:5432/db)","name":"POSTGRES_CONNECTION_STRING"}]}],"tools":[{"name":"pg_connect","description":"Connect to a PostgreSQL server profile. If multiple profiles are configured, specify which one. Otherwise connects to the default profile.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_connection_status","description":"Check connection pool health for the active profile or a specific named profile.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_constraint_list","description":"List constraints (primary key, foreign key, unique, check) for a table.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_database_size","description":"Show size of all databases.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_delete","description":"Delete rows matching a WHERE clause. Requires confirm: true.","write_action":true,"price_micros":0,"input_schema":null},{"name":"pg_disconnect","description":"Disconnect from a PostgreSQL server profile. Omit profile to disconnect all.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_enum_list","description":"List all enum types and their values.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_extension_list","description":"List installed PostgreSQL extensions with versions.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_function_list","description":"List functions and procedures with their signatures.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_index_list","description":"List indexes for a table with type, columns, uniqueness, and size.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_insert","description":"Insert one or more rows into a table. Returns inserted rows.","write_action":true,"price_micros":0,"input_schema":null},{"name":"pg_list_connections","description":"List all configured connection profiles and their status. Each profile represents a PostgreSQL server instance (not a database within a server).","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_query","description":"Execute a parameterized SQL query. Returns rows as JSON. Use $1, $2, ... for parameters.","write_action":true,"price_micros":0,"input_schema":null},{"name":"pg_query_explain","description":"Run EXPLAIN on a query. mode=plan (default, safe) shows the plan without executing. mode=analyze executes the statement and shows actual timing — ALWAYS requires confirm: true because EXPLAIN ANALYZE executes the statement.","write_action":true,"price_micros":0,"input_schema":null},{"name":"pg_query_prepared","description":"[DEPRECATED] Manage named prepared statements: PREPARE, EXECUTE, DEALLOCATE. ⚠️ Prepared statements are session-local in PostgreSQL and unreliable with connection pools — each pool checkout may get a different backend. Use parameterized pg_query instead.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_reload_config","description":"Reload server configuration files (postgresql.conf). Requires confirm: true.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_schema_list","description":"List all schemas in the database.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_settings","description":"Show or search server configuration parameters.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_switch_database","description":"Deprecated — use pg_switch_profile instead. Switch the active connection profile.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_switch_profile","description":"Switch the active connection profile. All subsequent queries will use this profile unless overridden. Each profile targets a specific PostgreSQL server instance.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_table_describe","description":"Describe a table: columns, data types, defaults, nullability, and constraints.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_table_list","description":"List tables in the database. Optionally filter by schema name.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_table_sizes","description":"Show table sizes with index and toast breakdown, sorted by total size descending.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_update","description":"Update rows matching a WHERE clause. Requires confirm: true.","write_action":true,"price_micros":0,"input_schema":null},{"name":"pg_upsert","description":"Insert or update on conflict. Requires confirm: true.","write_action":true,"price_micros":0,"input_schema":null},{"name":"pg_uptime","description":"Show server uptime and start time.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_version","description":"Get PostgreSQL version string and numeric version.","write_action":false,"price_micros":0,"input_schema":null},{"name":"pg_view_list","description":"List views with their definitions. Optionally filter by schema.","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":65,"grade":"C","scanned_at":"2026-09-27T22:35:49.861Z","report":{"scannerVersion":"0.1.9","scannedAt":"2026-09-27T22:35:49.873Z","components":{"code":{"score":25,"max":25,"notes":["27 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":3,"max":15,"notes":["repository not readable: repo not found"]},"identity":{"score":2,"max":10,"notes":["no repository or website to verify"]}},"findings":[],"inputs":{"packages":[{"registryType":"npm","identifier":"@itunified.io/mcp-postgres","version":"2026.4.10-1","found":true,"license":"AGPL-3.0-only","hasInstallScripts":false,"dependencyCount":3,"publishedAt":"2026-04-10T06:40:05.785Z","repositoryUrl":"git+https://github.com/itunified-io/mcp-postgres.git","weeklyDownloads":25}],"repo":{"found":false,"owner":"itunified-io","repo":"mcp-postgres","error":"repo not found"},"icon":{"url":null,"source":"none"},"presence":{"stars":null,"forks":null,"downloadsWeek":25,"license":"AGPL-3.0-only","lastPushAt":null,"score":7}}}},"grade_history":[],"reviews":[]}