PostgreSQL Full Access MCP Server

by syahiidkamil
Verified

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
PG_MAX_CONNECTIONSNoMaximum PostgreSQL connections. Important to stay within your database's connection limits.20
MONITOR_INTERVAL_MSNoHow often to check for stuck transactions. Usually doesn't need adjustment.5000
TRANSACTION_TIMEOUT_MSNoTransaction timeout in milliseconds. Increase this if your transactions need more time. Transactions exceeding this time will be automatically rolled back for safety.15000
PG_STATEMENT_TIMEOUT_MSNoSQL query execution timeout in ms. Limits how long any single SQL statement can run. Important safety feature to prevent runaway queries.30000
ENABLE_TRANSACTION_MONITORNoEnable/disable transaction monitor ("true" or "false"). Monitors and automatically rolls back abandoned transactions. Rarely needs to be disabled.true
MAX_CONCURRENT_TRANSACTIONSNoMaximum concurrent transactions. Lower this number for more conservative operation. Higher values allow more simultaneous write operations.10

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools

ID: j01i1h42dq