PostgreSQL MCP Server
by HenkDz
Verified
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| PGHOST | No | PostgreSQL server host | |
| PGPORT | No | PostgreSQL server port | |
| PGUSER | No | PostgreSQL username | |
| PGDATABASE | No | PostgreSQL database name | |
| PGPASSWORD | No | PostgreSQL password | |
| DATABASE_URL | No | PostgreSQL connection string in the format postgresql://user:password@localhost:5432/dbname |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |