// MCP TOOL REFERENCE

POSTGRES MCP LEGACY TOOLS

60 tools from the Postgres Mcp Legacy MCP Server, categorised by risk level.

// ALL 60 POSTGRES MCP LEGACY TOOLS

READ 44 tools

Read performance_baseline Establish performance baselines for critical queries Read analyze_db_health Analyzes database health. Here are the available health checks:\n Read backup_logical Generate logical backup plan with validation Read backup_physical Analyze physical backup readiness and configuration Read capacity_planning Analyze database growth and project future capacity needs Read connection_pool_optimize Analyze connection pool and provide optimization recommendations Read explain_query Explains the execution plan for a SQL query, showing how the database will execute it and provides detailed... Read fuzzy_match Find fuzzy matches using Levenshtein distance (requires fuzzystrmatch extension) Read geo_distance Calculate distance between geometries (requires PostGIS extension) Read geo_intersection Find geometric intersections (requires PostGIS) Read geo_within Point-in-polygon and geometric containment queries (requires PostGIS) Read get_object_details Show detailed information about a database object Read get_top_queries get_top_queries Read hybrid_search Hybrid search combining full-text and vector similarity (requires pgvector) Read json_diff Compare two JSON structures and return differences Read json_security_scan Scan JSON data for potential security issues Read json_validate_path Validate JSONPath expression with security checks Read jsonb_index_suggest Suggest indexes for JSONB columns based on usage patterns Read jsonb_stats Analyze JSON structure and generate statistics Read list_objects List objects in a schema Read list_schemas List all schemas in the database Read monitor_real_time Monitor real-time database performance metrics Read partition_strategy_suggest Suggest partitioning strategy for large tables Read query_plan_compare Compare execution plans of two queries with cost analysis Read regex_extract_all Extract all pattern matches with capture groups using regex Read replication_monitor Monitor replication status and lag Read resource_usage_analyze Analyze database resource usage patterns (CPU/Memory/IO) Read slow_query_analyzer Analyze slow queries with optimization suggestions (requires pg_stat_statements) Read stats_correlation Calculate correlation between two numeric columns (Pearson or Spearman) Read stats_descriptive Calculate descriptive statistics (mean, median, mode, std dev) for numeric columns Read stats_distribution Analyze data distribution with histogram and distribution fitting Read stats_hypothesis Perform hypothesis testing (t-test, z-test) Read stats_percentiles Calculate percentiles and detect outliers using IQR method Read stats_regression Calculate linear regression analysis with coefficients and R-squared Read stats_sampling Generate statistical samples from tables (random, systematic, stratified) Read stats_time_series Analyze time series data with aggregation and trend analysis Read text_search_advanced Advanced full-text search with ranking Read text_sentiment Basic sentiment analysis using keyword matching Read text_similarity Find similar text using trigram similarity (requires pg_trgm extension) Read vacuum_strategy_recommend Analyze vacuum needs and recommend vacuum strategy Read vector_search Semantic search with ranking and distance threshold (requires pgvector) Read vector_similarity Find similar vectors using cosine, L2, or inner product distance (requires pgvector) Read json_select Extract JSON data with multiple output formats Read restore_validate Validate database readiness for restore operations

WRITE 5 tools

Write alert_threshold_set Analyze metrics against alert thresholds Write geo_buffer Create buffer zones around geometries (requires PostGIS) Write json_insert Insert or update JSONB data with validation Write json_merge Merge JSON objects with conflict resolution strategies Write json_update Update JSON value by path, optionally creating path if missing

EXECUTE 10 tools

Execute geo_transform Transform geometries between coordinate systems (requires PostGIS) Execute vector_performance Vector query optimization and performance benchmarking (requires pgvector) Execute geo_cluster Spatial clustering using distance-based grouping (requires PostGIS) Execute geo_index_optimize Optimize spatial indexes (GIST/BRIN/SP-GIST) for performance (requires PostGIS) Execute json_normalize Normalize Python-style JSON to valid JSON format Execute json_query Complex JSON filtering and aggregation using JSONPath Execute vector_cluster K-means clustering for vector data (requires implementation) Execute vector_embed Generate embeddings for text data (requires pgvector extension and API integration) Execute vector_index_optimize Optimize vector indexes (HNSW/IVFFlat) for performance (requires pgvector) Execute backup_schedule_optimize Optimize backup schedule based on database characteristics

OTHER 1 tools

Other vector_dimension_reduce Dimensionality reduction for vector data (requires implementation)

// FAQ

How many tools does the Postgres Mcp Legacy MCP server have? +

The Postgres Mcp Legacy MCP server exposes 60 tools across 4 categories: Read, Write, Execute, Other.

How do I enforce policies on Postgres Mcp Legacy tools? +

Route the Postgres Mcp Legacy server through the PolicyLayer gateway. Define allow, deny, or approval rules per tool in the dashboard; they are enforced on every call before it reaches the server.

What risk categories do Postgres Mcp Legacy tools fall into? +

Postgres Mcp Legacy tools are categorised as Read (44), Write (5), Execute (10), Other (1). Each category has a recommended default policy.

Enforce policy on every Postgres Mcp Legacy tool call.

Start from Postgres Mcp Legacy, add the rest of your stack, and see everything your agents can call. Then put policy on all of it.

CHECK YOUR STACK →

Free to start. No card required.

43,000+ MCP servers and 220,000+ tools scanned and risk-classified.