Mcpg MCP server

by devopam·io.github.devopam/mcpg·v0.8.2

No reviews yet

Production-grade PostgreSQL MCP server — 254 tools for query, tuning & ops, read-only by default.

A85/100grade A

Write a review Install

What users say

No reviews yet

Be the first

Safety scan

A85/100

full report

Adoption

Growing

10 stars

Reviews

Write one

Nobody has reviewed Mcpg yet.

If you have run it, two minutes of your experience saves the next person an afternoon.

Mcpg tools (100, 1 write)

write = sends, deletes, buys or posts

Read from the package source without running it. The installed server may list more.

_register_advisors
_register_introspection
_register_vector_tuning
analyze_distance_metric
analyze_hnsw_recall
analyze_rerank_ndcg
analyze_rerank_score_distribution
analyze_reranker_lift
analyze_session_cost
analyze_topk_stability
analyze_vector_search_efficiency
audit_sequences
audit_settings
check_pitr_readiness
cluster_vectors
compare_schemas
cross_table_similarity
describe_self
describe_table
describe_tool
detect_vector_outliers
enable_session_intent
export_query
export_table
find_blocking_chains
find_sensitive_columns
find_unused_objects
generate_diesel_schema
generate_drizzle_schema
generate_ecto_schemas
generate_ent_schemas
generate_fk_cascade_graph
generate_graph_projection
generate_jooq_config
generate_prisma_schema
generate_schema_diagram
generate_schema_docs
generate_sqlalchemy_models
generate_sqlc_schema
generate_test_data
generate_test_row_for
get_compact_schema
get_metrics_exposition
get_server_info
get_wal_archive_status
import_csv
import_json
import_vectors
lint_naming_conventions
list_available_extensions
list_composite_types
list_constraints
list_domains
list_enums
list_extensions
list_foreign_data_wrappers
list_foreign_keys
list_foreign_servers
list_foreign_tables
list_functions
list_generated_columns
list_grants
list_indexes
list_locks
list_partitions
list_policies
list_publications
list_roles
list_schemas
list_sequences
list_session_intents
list_subscriptions
List logical-replication subscriptions; requires superuser to see any rows.
list_tables
list_triggers
list_user_mappings
list_views
migrate_vector_to_halfvec
monitor_embedding_drift
optimize_query
prepare_migration
read_migration_history
read_pg_buffercache_relations
read_pg_buffercache_summary
read_pg_stat_io
read_pg_wal_records
read_pg_wal_stats
recommend_headline_tools
recommend_hnsw_ef_search
recommend_ivfflat_probes
recommend_postgres_conf
recommend_rerank_strategy
retrieve_with_context
run_advisorswrite action
summarize_table
test_rls_for_role
tune_vector_index
validate_migration
vector_recall_at_k
walk_blocking_chains
why_is_this_slow

Public scan report

scanner v0.1.9 · 2026-09-20 · same rubric, same numbers if you re-run it

1 medium

Code scan113 source files scanned20/25
–Live reliabilityno gateway calls yet and no remote to proben/a
–Tool poisoningtools not inspected (local package is not executed); not countedn/a
Auth qualitylocal package, no credentials required12/15
Maintenancelast push 1 days ago15/15
Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10

Findings (1)

mediumsubprocess with shell=Trueexec.shell-true

mcpg-0.8.2/src/mcpg/shell.py: …_exec(binary, *argv)`` only — never ``shell=True``. Argv is a list, not a shell string, …

Overall 85/100. Components that don't apply are left out of the denominator. Any critical finding is an F.Rubric Appeal a finding JSON

Install directly

claude mcp add mcpg -- uvx mcpg

Add to Cursor

Mcpg: common questions

Is Mcpg MCP server safe?: Yes, by our scan: it is graded A (85/100). Read the Mcpg safety report
How do I install Mcpg?: It runs on your machine. Copy the Claude Code, Claude Desktop or Cursor config from the install section.
Does Mcpg need an API key?: Not as far as the registry entry and our scan can tell: no credentials are declared or required.
Is Mcpg maintained?: The last commit was 2 days ago (2026-09-19). The latest release is v0.8.2.