{"name":"io.github.musaddiq-dev/postgresql-mcp-server","slug":"musaddiq-dev-postgresql-mcp-server","title":"PostgreSQL MCP Server","description":"Python MCP server for PostgreSQL database inspection and querying","url":"https://mcp.market/server/musaddiq-dev-postgresql-mcp-server","rating":null,"grade":"B","score":72,"certified":false,"status":"active","category":"data","tags":["data"],"presence":{"score":16,"stars":1,"forks":0,"downloads_week":26,"last_push_at":"2026-05-23T06:24:05.000Z","license":"MIT"},"uptime":null,"claimed":false,"transport":"pypi","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/musaddiq-dev/postgresql-mcp-server","website":null,"version":"0.1.2","remotes":[],"packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mdev-postgresql-mcp-server","version":"0.1.2","runtimeHint":"uvx","transport":{"type":"stdio"},"environmentVariables":[{"description":"PostgreSQL host","isRequired":true,"default":"localhost","name":"POSTGRES_HOST"},{"description":"PostgreSQL port","isRequired":true,"default":"5432","name":"POSTGRES_PORT"},{"description":"PostgreSQL username","isRequired":true,"name":"POSTGRES_USER"},{"description":"PostgreSQL password","isSecret":true,"name":"POSTGRES_PASSWORD"},{"description":"PostgreSQL database name","isRequired":true,"name":"POSTGRES_DB"},{"description":"Maximum rows returned by read queries","default":"1000","name":"POSTGRES_READ_QUERY_LIMIT"}]}],"tools":[{"name":"postgresql_analyze_indexes","description":"Returns all indexes, their columns, and sizes for the specified table.","write_action":false,"price_micros":0,"input_schema":null},{"name":"postgresql_describe_table","description":"Queries information_schema.columns to return column details for a table.","write_action":false,"price_micros":0,"input_schema":null},{"name":"postgresql_execute_read_query","description":"Executes read-only SQL queries (SELECT, etc). Safe to auto-approve.","write_action":true,"price_micros":0,"input_schema":null},{"name":"postgresql_execute_write_query","description":"Executes data modification queries (INSERT, UPDATE, DELETE, DROP). Requires manual approval.","write_action":true,"price_micros":0,"input_schema":null},{"name":"postgresql_explain_query","description":"Prepends EXPLAIN to the query to return the execution plan without running it.","write_action":false,"price_micros":0,"input_schema":null},{"name":"postgresql_get_database_summary","description":"Returns a comprehensive summary of the database.","write_action":false,"price_micros":0,"input_schema":null},{"name":"postgresql_get_relationships","description":"Queries information_schema to find Foreign Keys pointing TO and FROM this table.","write_action":false,"price_micros":0,"input_schema":null},{"name":"postgresql_list_tables","description":"Returns a list of all table names in the public schema.","write_action":false,"price_micros":0,"input_schema":null},{"name":"postgresql_preview_table","description":"Returns the first 10 rows of a table (LIMIT 10).","write_action":false,"price_micros":0,"input_schema":null},{"name":"postgresql_search_sql_definitions","description":"Searches information_schema.routines or pg_proc for code containing the search_term.","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":72,"grade":"B","scanned_at":"2026-09-27T17:07:28.797Z","report":{"scannerVersion":"0.1.9","scannedAt":"2026-09-27T17:07:28.778Z","components":{"code":{"score":25,"max":25,"notes":["4 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":8,"max":15,"notes":["last push 127 days ago"]},"identity":{"score":8,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[{"registryType":"pypi","identifier":"mdev-postgresql-mcp-server","version":"0.1.2","found":true,"weeklyDownloads":26,"license":"MIT","dependencyCount":7,"publishedAt":"2026-05-23T06:24:27.480122Z"}],"repo":{"found":true,"owner":"musaddiq-dev","repo":"postgresql-mcp-server","archived":false,"pushedAt":"2026-05-23T06:24:05Z","stars":1,"forks":0,"openIssues":0,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/137469745?v=4","ownerCreatedAt":"2023-06-23T03:25:12Z","license":"MIT"},"icon":{"url":"https://avatars.githubusercontent.com/u/137469745?v=4&s=128","source":"github"},"presence":{"stars":1,"forks":0,"downloadsWeek":26,"license":"MIT","lastPushAt":"2026-05-23T06:24:05.000Z","score":16}}}},"grade_history":[],"reviews":[]}