analyze_db_health

Run comprehensive database health checks: cache hit rates, connection usage, index health (invalid/unused/duplicate), vacuum status, sequence limits, unvalidated constraints. Returns issues with severity levels.

Server Postgres teja-sudo/postgres-mcp-server
Category Read
Risk class Low
Parameters 00 required

What analyze_db_health does on Postgres

AI agents call analyze_db_health to retrieve information from Postgres without modifying anything — typically the context-gathering step in research, monitoring, and reporting workflows, before the agent takes action elsewhere.

Why analyze_db_health needs a policy

analyze_db_health is a monitoring and diagnostic tool that queries database metadata and system statistics to assess health. It retrieves information about performance metrics, index status, and constraint validation—all read-only operations with no side effects. While useful for identifying problems, the tool itself cannot modify or delete data, execute arbitrary code, or commit financial transactions.

From the tool's definition Tool performs 'comprehensive database health checks' including monitoring 'cache hit rates, connection usage, index health, vacuum status, sequence limits, unvalidated constraints' and 'returns issues with severity levels'.

Questions about analyze_db_health

What does the analyze_db_health tool do? +

Run comprehensive database health checks: cache hit rates, connection usage, index health (invalid/unused/duplicate), vacuum status, sequence limits, unvalidated constraints. Returns issues with severity levels. It is categorised as a Read tool in the Postgres MCP Server, which means it retrieves data without modifying state.

How do I enforce a policy on analyze_db_health? +

Register the Postgres MCP server in PolicyLayer and add a rule for analyze_db_health: allow, deny, rate-limit, or require approval. Point your MCP client at the PolicyLayer proxy URL and the rule is enforced on every call, before it reaches Postgres. Nothing to install.

What risk level is analyze_db_health? +

analyze_db_health is a Read tool with low risk. Read-only tools are generally safe to allow by default.

Can I rate-limit analyze_db_health? +

Yes. Add a rate_limit block to the analyze_db_health rule in your PolicyLayer policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block analyze_db_health completely? +

Set action: deny in the PolicyLayer policy for analyze_db_health. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides analyze_db_health? +

analyze_db_health is provided by the Postgres MCP server (teja-sudo/postgres-mcp-server). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.

// THE FULL RECORD

analyze_db_health is one line of Postgres's registry record.

The record carries the whole server: verified identity, auth posture, risk grade, every tool classified, recommended policy — re-checked continuously.

Teams ship this data inside their own products. See what a licence covers →

// GET IN TOUCH

Have a question or want to learn more? Send us a message.

Message sent.

We'll get back to you soon.