// MCP TOOL REFERENCE

PGSQL TOOLS

9 tools from the Pgsql MCP Server, categorised by risk level.

// ALL 9 PGSQL TOOLS

READ 6 tools

Read run_dql_query Run a raw DQL SQL query, like SELECT, SHOW, DESCRIBE, EXPLAIN, etc. Read get_columns Get all columns in a table. Read get_foreign_keys Get foreign keys in a table. Read get_indexes Get all indexes in a table. Read get_schema_names Get all schema names. Read get_tables Get all tables in a schema.

DESTRUCTIVE 2 tools

Destructive run_ddl_query Run a raw DDL SQL query, like CREATE, ALTER, DROP, etc. Destructive run_dml_query Run a raw DML query, like INSERT, UPDATE, DELETE, etc.

EXECUTE 1 tools

Execute run_dcl_query Run a raw DCL SQL query, like GRANT, REVOKE, etc.

// FAQ

How many tools does the Pgsql MCP server have? +

The Pgsql MCP server exposes 9 tools across 3 categories: Read, Destructive, Execute.

How do I enforce policies on Pgsql tools? +

Route the Pgsql 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 Pgsql tools fall into? +

Pgsql tools are categorised as Read (6), Destructive (2), Execute (1). Each category has a recommended default policy.

Enforce policy on every Pgsql tool call.

Start from Pgsql, 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.