Skip to main content
Glama
vladshykanov

mcp-postgres-guard

by vladshykanov

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MAX_ROWSNoRead result cap.200
DATABASE_URLYesRequired. PostgreSQL connection URL.
AUDIT_LOG_PATHNoJSONL audit file path.(stderr)
MASKED_COLUMNSNoColumns to mask, e.g., 'ssn' or 'customers.email'.(none)
WRITES_ENABLEDNoMaster switch for mutations.false
ALLOWED_SCHEMASNoSchemas visible at all.public
READABLE_TABLESNoReadable tables; empty means every table in the allowed schemas.(all)
WRITABLE_TABLESNoWritable tables; writes are opt-in.(none)
REQUIRE_APPROVALNoHuman confirmation per write.true
MAX_MUTATION_ROWSNoRefuse a mutation above this blast radius.100
MAX_CALLS_PER_MINUTENoBounds an agent stuck in a retry loop.60
STATEMENT_TIMEOUT_MSNoServer-enforced statement timeout in ms.10000

Capabilities

Features and capabilities supported by this server

CapabilityDetails
tools
{
  "listChanged": true
}

Tools

Functions exposed to the LLM to take actions

NameDescription
list_tablesA

Lists tables the agent is permitted to read, with row estimates. Start here — guessing table names wastes calls against the rate limit.

describe_tableA

Columns, types, nullability and defaults for one table. Masked columns are marked — they can be filtered on, but their values are never returned.

queryA

Executes a single SELECT inside a read-only transaction, capped at 200 rows. Use $1, $2 … placeholders with the params array — never string-concatenate values into the SQL.

executeA

Runs a single INSERT, UPDATE or DELETE. The change is first executed in a rolled-back transaction to measure exactly how many rows it affects, then that number is shown to a human for approval. UPDATE/DELETE without a WHERE clause is always refused.

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/vladshykanov/mcp-postgres-guard'

If you have feedback or need assistance with the MCP directory API, please join our Discord server