FastPostgresMCP

MIT License
184

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
LOG_LEVELNoServer logging level: debug, info, warn, errorinfo
DB_ALIASESYesComma-separated list of unique DB aliasesmain,reporting
ENABLE_AUTHNoEnable API Key auth (primarily for network transports)false
MCP_API_KEYNoAPI key for authentication when ENABLE_AUTH is true
DEFAULT_DB_ALIASYesDefault alias if 'dbAlias' is omitted in tool callsmain

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
query_tool

Safely execute a read-only SQL query and retrieve results

execute_tool

Safely execute a data-modifying SQL statement

schema_tool

Retrieve detailed schema information for a specific table

transaction_tool

Execute multiple SQL statements as a single atomic transaction

ID: cu9jnv9gk1