Skip to main content
Glama
japentaca

MCP PostgreSQL Read-Only Server

by japentaca

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
PORTNoPort for HTTP server (optional)
NODE_ENVNoRuntime environment (e.g., production)
MCP_PG_CONNSTRYesPostgreSQL connection string (e.g., postgresql://user:password@localhost:5432/database)

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools

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/japentaca/mcp-postgres-readonly'

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