PostgreSQL MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| POSTGRES_HOST | Yes | PostgreSQL 主机地址 | |
| POSTGRES_PORT | No | PostgreSQL 端口 | 5432 |
| POSTGRES_USER | Yes | PostgreSQL 用户名 | |
| POSTGRES_PASSWORD | Yes | PostgreSQL 密码 | |
| POSTGRES_LOG_LEVEL | No | 日志级别 | INFO |
| POSTGRES_READ_ONLY | No | 是否开启只读模式 | false |
| POSTGRES_DEFAULT_SCHEMA | Yes | 默认 database 下的默认 schema | |
| POSTGRES_DATABASE_SCHEMAS | Yes | 每个 database 允许访问的 schema 映射，格式: database:schema1,schema2;database2:schema3,schema4 | |
| POSTGRES_DEFAULT_DATABASE | Yes | 启动后的默认 database | |
| POSTGRES_ALLOWED_DATABASES | Yes | 允许访问的 database，多个值用英文逗号分隔 | |
| POSTGRES_DATABASE_DEFAULT_SCHEMAS | No | 每个 database 的默认 schema 映射 |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
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 | |