{"name":"io.github.sparta2025/postgres-mcp","slug":"sparta2025-postgres-mcp","title":null,"description":"PostgreSQL MCP server with 15 tools (SQL, EXPLAIN, health, indexes) plus a Gradio UI with LLM chat.","url":"https://mcp.market/server/sparta2025-postgres-mcp","rating":null,"grade":"B","score":78,"certified":false,"status":"active","category":"data","tags":["data","ai"],"presence":{"score":19,"stars":0,"forks":0,"downloads_week":72,"last_push_at":"2026-08-21T16:40:09.000Z","license":"NOASSERTION"},"uptime":null,"claimed":false,"transport":"pypi","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/sparta2025/postgres-mcp","website":null,"version":"0.4.2","remotes":[],"packages":[{"registryType":"pypi","identifier":"postgres-mcp-pro","version":"0.4.2","transport":{"type":"stdio"},"environmentVariables":[{"description":"PostgreSQL connection URL, e.g. postgresql://user:pass@localhost:5432/dbname","isRequired":true,"format":"string","isSecret":true,"name":"DATABASE_URL"}]}],"tools":[{"name":"_humanize_param_type","description":"Превращает Python-аннотацию в человекочитаемое описание для UI.","write_action":false,"price_micros":0,"input_schema":null},{"name":"analyze_db_health","description":"Database health overview.","write_action":false,"price_micros":0,"input_schema":null},{"name":"analyze_index_performance","description":"Analyze index usage and find unused/duplicate indexes.","write_action":false,"price_micros":0,"input_schema":null},{"name":"execute_sql","description":"Execute a SQL query.","write_action":true,"price_micros":0,"input_schema":null},{"name":"explain_query","description":"Get query execution plan.","write_action":false,"price_micros":0,"input_schema":null},{"name":"format_sql_query","description":"Format/beautify a SQL query for readability.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_active_queries","description":"List currently running queries and their duration.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_database_info","description":"Get general database information: version, size, extensions, server settings.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_database_locks","description":"Show current database locks and blocking queries.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_object_details","description":"Get columns of a table or view.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_table_sizes","description":"Show table sizes including indexes and total.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_top_queries","description":"Top queries by resource usage (requires pg_stat_statements extension).","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_objects","description":"List tables/views/sequences in a schema.","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_schemas","description":"List all schemas in the database.","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_tools","description":"List all available MCP tools of this server with their descriptions.","write_action":false,"price_micros":0,"input_schema":null},{"name":"manage_encryption_key","description":"Manage the Data Encryption Certificate (Fernet key) for stored secrets.","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":78,"grade":"B","scanned_at":"2026-11-01T22:09:45.664Z","report":{"scannerVersion":"0.1.10","scannedAt":"2026-11-01T22:09:45.625Z","components":{"code":{"score":25,"max":25,"notes":["64 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 72 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":"postgres-mcp-pro","version":"0.4.2","found":true,"weeklyDownloads":72,"license":"MIT","dependencyCount":15,"publishedAt":"2026-08-21T16:22:48.786225Z"}],"repo":{"found":true,"owner":"sparta2025","repo":"postgres-mcp","archived":false,"pushedAt":"2026-08-21T16:40:09Z","stars":0,"forks":0,"openIssues":0,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/127828825?v=4","ownerCreatedAt":"2023-03-14T07:08:12Z","license":"NOASSERTION"},"icon":{"url":"https://avatars.githubusercontent.com/u/127828825?v=4&s=128","source":"registry","width":128,"height":128},"presence":{"stars":0,"forks":0,"downloadsWeek":72,"license":"NOASSERTION","lastPushAt":"2026-08-21T16:40:09.000Z","score":19}}}},"grade_history":[],"reviews":[]}