{"name":"io.github.devopam/mcpg","slug":"devopam-mcpg","title":null,"description":"Production-grade PostgreSQL MCP server — 254 tools for query, tuning & ops, read-only by default.","url":"https://mcp.market/server/devopam-mcpg","rating":null,"grade":"A","score":85,"certified":false,"status":"active","category":"other","tags":[],"presence":{"score":28,"stars":10,"forks":1,"downloads_week":null,"last_push_at":"2026-09-19T11:51:29.000Z","license":"MIT"},"uptime":null,"claimed":false,"transport":"pypi","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/devopam/MCPg","website":"https://devopam.github.io/MCPg/","version":"0.8.2","remotes":[],"packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcpg","version":"0.8.2","runtimeHint":"uvx","transport":{"type":"stdio"}}],"tools":[{"name":"_register_advisors","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"_register_introspection","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"_register_vector_tuning","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"analyze_distance_metric","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"analyze_hnsw_recall","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"analyze_rerank_ndcg","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"analyze_rerank_score_distribution","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"analyze_reranker_lift","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"analyze_session_cost","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"analyze_topk_stability","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"analyze_vector_search_efficiency","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"audit_sequences","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"audit_settings","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"check_pitr_readiness","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"cluster_vectors","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"compare_schemas","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"cross_table_similarity","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"describe_self","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"describe_table","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"describe_tool","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"detect_vector_outliers","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"enable_session_intent","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"export_query","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"export_table","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"find_blocking_chains","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"find_sensitive_columns","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"find_unused_objects","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"generate_diesel_schema","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"generate_drizzle_schema","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"generate_ecto_schemas","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"generate_ent_schemas","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"generate_fk_cascade_graph","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"generate_graph_projection","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"generate_jooq_config","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"generate_prisma_schema","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"generate_schema_diagram","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"generate_schema_docs","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"generate_sqlalchemy_models","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"generate_sqlc_schema","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"generate_test_data","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"generate_test_row_for","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_compact_schema","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_metrics_exposition","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_server_info","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_wal_archive_status","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"import_csv","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"import_json","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"import_vectors","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"lint_naming_conventions","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_available_extensions","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_composite_types","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_constraints","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_domains","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_enums","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_extensions","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_foreign_data_wrappers","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_foreign_keys","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_foreign_servers","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_foreign_tables","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_functions","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_generated_columns","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_grants","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_indexes","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_locks","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_partitions","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_policies","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_publications","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_roles","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_schemas","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_sequences","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_session_intents","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_subscriptions","description":"List logical-replication subscriptions; requires superuser to see any rows.","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_tables","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_triggers","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_user_mappings","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_views","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"migrate_vector_to_halfvec","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"monitor_embedding_drift","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"optimize_query","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"prepare_migration","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"read_migration_history","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"read_pg_buffercache_relations","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"read_pg_buffercache_summary","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"read_pg_stat_io","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"read_pg_wal_records","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"read_pg_wal_stats","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"recommend_headline_tools","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"recommend_hnsw_ef_search","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"recommend_ivfflat_probes","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"recommend_postgres_conf","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"recommend_rerank_strategy","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"retrieve_with_context","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"run_advisors","description":"","write_action":true,"price_micros":0,"input_schema":null},{"name":"summarize_table","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"test_rls_for_role","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"tune_vector_index","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"validate_migration","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"vector_recall_at_k","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"walk_blocking_chains","description":"","write_action":false,"price_micros":0,"input_schema":null},{"name":"why_is_this_slow","description":"","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":85,"grade":"A","scanned_at":"2026-09-20T11:40:42.900Z","report":{"scannerVersion":"0.1.9","scannedAt":"2026-09-20T11:40:42.867Z","components":{"code":{"score":20,"max":25,"notes":["113 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":15,"max":15,"notes":["last push 1 days ago"]},"identity":{"score":8,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[{"id":"exec.shell-true","severity":"medium","component":"code","title":"subprocess with shell=True","evidence":"mcpg-0.8.2/src/mcpg/shell.py: …_exec(binary, *argv)`` only — never ``shell=True``. Argv is a list, not a shell string, …"}],"inputs":{"packages":[{"registryType":"pypi","identifier":"mcpg","version":"0.8.2","found":true,"license":"MIT","dependencyCount":16,"publishedAt":"2026-09-04T16:59:41.184664Z","repositoryUrl":"https://github.com/devopam/MCPg"}],"repo":{"found":true,"owner":"devopam","repo":"MCPg","archived":false,"pushedAt":"2026-09-19T11:51:29Z","stars":10,"forks":1,"openIssues":1,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/5661555?v=4","ownerCreatedAt":"2013-10-11T05:16:42Z","license":"MIT"},"icon":{"url":"https://avatars.githubusercontent.com/u/5661555?v=4&s=128","source":"github"},"presence":{"stars":10,"forks":1,"downloadsWeek":null,"license":"MIT","lastPushAt":"2026-09-19T11:51:29.000Z","score":28}}}},"grade_history":[],"reviews":[]}