38 tools from the Postgres Scout MCP Server, categorised by risk level.
View the Postgres Scout policy →analyzeForeignKeys Analyze foreign key health and performance analyzeLocks Analyze current locks and blocking queries analyzeTableBloat Detect table and index bloat for VACUUM planning analyzeTimeSeries Advanced time-series analysis with window functions and anomaly detection analyzeTypeConsistency Analyze if text columns contain consistent data types checkConstraintViolations Check for rows that would violate a constraint before adding it describeTable Get comprehensive table information including columns, constraints, and indexes detectAnomalies Detect anomalies in query performance, connections, and data patterns detectSeasonality Detect seasonal patterns in time-series data explainQuery Analyze query performance using EXPLAIN (ANALYZE disabled) 2/5 exploreRelationships Follow foreign key relationships to explore related records findDuplicates Find duplicate rows based on column combinations findMissingValues Find NULL values or missing data in columns findOrphans Find orphaned records with invalid foreign key references findRecent Find rows within a time window getCurrentActivity Get current active queries and connections getDatabaseStats Get comprehensive database statistics including size, cache hit ratio, and connection info getHealthScore Calculate overall database health score with component breakdown getHottestTables Identify tables with highest activity during a sample period getIndexUsage Analyze index usage and identify unused indexes getLiveMetrics Collect real-time database metrics over a time period with configurable intervals getSlowQueries Analyze slow queries from pg_stat_statements extension getTableMetrics Get comprehensive metrics for a specific table including I/O, scans, and maintenance stats listDatabases List all databases the user has access to listSchemas List all schemas in the current database listTables List all tables in a schema with size and statistics optimizeQuery Analyze a specific query and provide optimization recommendations (estimated plan only — ANALYZE unavailable) 2/5 suggestIndexes Analyze query patterns and table scans to recommend missing indexes suggestPartitioning Analyze large tables and recommend partitioning strategies suggestVacuum Analyze and recommend VACUUM operations based on dead tuples and bloat exportTable Export table data to various formats (CSV, JSON, SQL) 2/5 generateInsertStatements Generate INSERT statements for data migration 2/5 previewUpdate Preview which rows would be affected by an UPDATE without modifying data 2/5 safeInsert Execute INSERT with safety guards: dry-run mode, maxRows limit, parameterized values, row batching, ON CONFLICT support 2/5 safeUpdate Execute UPDATE with safety guards: dry-run mode, maxRows limit, empty WHERE protection 2/5 The Postgres Scout MCP server exposes 38 tools across 4 categories: Read, Write, Destructive, Execute.
Use Intercept, the open-source MCP proxy. Write YAML rules for each tool — rate limits, argument validation, or deny rules — then run Intercept in front of the Postgres Scout server.
Postgres Scout tools are categorised as Read (30), Write (5), Destructive (2), Execute (1). Each category has a recommended default policy.
Open source. One binary. Zero dependencies.
npx -y @policylayer/intercept