Skip to main content
Glama
abhinv98

PostgreSQL MCP Server

by abhinv98

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
sslModeNoSSL connection mode. Options: disable (no SSL), prefer (use SSL if available), require (force SSL).prefer
timeoutNoQuery timeout in seconds. Queries exceeding this duration are automatically terminated. Range: 1-300.30
readOnlyNoWhen enabled, only SELECT and EXPLAIN queries are permitted. Prevents all data modifications.true
allowedSchemasNoList of database schemas AI agents can access. Queries are restricted to these schemas only.["public"]
maxQueryResultsNoMaximum number of rows returned by a single query. Range: 1-10,000.1000
connectionStringYesPostgreSQL connection URL in the format postgresql://username:password@host:port/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/abhinv98/postgre-mcp'

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