// MCP TOOL REFERENCE

POSTGRESQL DATABASE MANAGEMENT SERVER TOOLS

18 tools from the PostgreSQL Database Management Server MCP Server, categorised by risk level.

View the PostgreSQL Database Management Server policy → Token cost: 5,614 tokens →

// ALL 18 POSTGRESQL DATABASE MANAGEMENT SERVER TOOLS

READ 2 tools

Read pg_analyze_database Analyze PostgreSQL database configuration and performance Read pg_monitor_database Get real-time monitoring information for a PostgreSQL database

WRITE 13 tools

Write pg_copy_between_databases Copy data between two databases Write pg_debug_database Debug common PostgreSQL issues Write pg_export_table_data Export table data to JSON or CSV format Write pg_import_table_data Import data from JSON or CSV file into a table Write pg_manage_comments Manage PostgreSQL object comments - get, set, remove comments on tables, columns, functions, and other data... Write pg_manage_constraints Manage PostgreSQL constraints - get, create foreign keys, drop foreign keys, create constraints, drop const... Write pg_manage_functions Manage PostgreSQL functions - get, create, or drop functions with a single tool. Examples: operation="get" ... Write pg_manage_indexes Manage PostgreSQL indexes - get, create, drop, reindex, and analyze usage with a single tool. Examples: ope... Write pg_manage_query Manage PostgreSQL query analysis and performance - operation="explain" for EXPLAIN plans, operation="get_sl... Write pg_manage_rls Manage PostgreSQL Row-Level Security - enable/disable RLS and manage policies. Examples: operation="enable"... Write pg_manage_schema Manage PostgreSQL schema - get schema info, create/alter tables, manage enums. Examples: operation="get_inf... Write pg_manage_triggers Manage PostgreSQL triggers - get, create, drop, and enable/disable triggers. Examples: operation="get" to l... Write pg_manage_users Manage PostgreSQL users and permissions - create, drop, alter users, grant/revoke permissions. Examples: op...

EXECUTE 3 tools

Execute pg_execute_mutation Execute data modification operations (INSERT/UPDATE/DELETE/UPSERT) - operation="insert/update/delete/upsert... Execute pg_execute_query Execute SELECT queries and data retrieval operations - operation="select/count/exists" with query and optio... Execute pg_execute_sql Execute arbitrary SQL statements - sql="ANY_VALID_SQL" with optional parameters and transaction support. Ex...

// FAQ

How many tools does the PostgreSQL Database Management Server MCP server have? +

The PostgreSQL Database Management Server MCP server exposes 18 tools across 3 categories: Read, Write, Execute.

How do I enforce policies on PostgreSQL Database Management Server tools? +

Route the PostgreSQL Database Management Server 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 PostgreSQL Database Management Server tools fall into? +

PostgreSQL Database Management Server tools are categorised as Read (2), Write (13), Execute (3). Each category has a recommended default policy.

Let agents act without letting them run wild.

Route your MCP servers through PolicyLayer and every tool call is checked against your policy before it runs — allow, deny, or require approval. Per-identity grants. Full audit log. Live in minutes.

SECURE YOUR MCP →

Free to start. No card required.

4,600+ MCP servers and 31,000+ tools scanned and risk-classified.