query

MCP tool from Pg Redact MCP by sam-david

Execute a SQL query with automatic PII redaction. Write queries (INSERT, UPDATE, DELETE) are blocked in read-only mode (default) and allowed when configured with readonly: false.

How to use it

query is exposed by the Pg Redact MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the query tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

FULL PG REDACT MCP LISTING

Other tools in Pg Redact MCP (13)

column

string

configure_masking

Override masking rules at runtime (in-memory, not persisted).

describe_schema

List tables and columns with their types and PII detection status.

explain_query

Show the PostgreSQL execution plan for a query.

list_masking_rules

Show all active PII classifications and masking rules.