PostgreSQL MCP Server for Claude Desktop
by User-Gold
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DB_HOST | No | PostgreSQL host | localhost |
| DB_NAME | Yes | Database name | |
| DB_PORT | No | PostgreSQL port | 5432 |
| DB_USER | Yes | Database user | |
| LOG_LEVEL | No | Logging level (DEBUG/INFO/WARNING) | INFO |
| PYTHONPATH | No | Path to the project root, used to ensure modules are importable | |
| DB_PASSWORD | Yes | Database password | |
| DB_MAX_CONNECTIONS | No | Max pool connections | 10 |
| DB_MIN_CONNECTIONS | No | Min pool connections | 1 |
| ALLOW_WRITE_OPERATIONS | No | Enable INSERT/UPDATE/DELETE | false |
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
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/User-Gold/Claude-Desktop-to-PostgreSQL'
If you have feedback or need assistance with the MCP directory API, please join our Discord server