Reads schema information from a PostgreSQL database and runs read-only queries.
接入配置
选择客户端，复制配置，再按项目文档补齐环境变量。
claude mcp add postgresql-schema --env POSTGRESQL_URL='<POSTGRESQL_URL>' --env PG_URL='<PG_URL>' --env DATABASE_URL='<DATABASE_URL>' -- docker run -i --rm mcp/postgres postgresql://host.docker.internal:5432/mydb~/.codex/config.toml
[mcp_servers.postgresql-schema]
command = "docker"
args = ["run", "-i", "--rm", "mcp/postgres", "postgresql://host.docker.internal:5432/mydb"]
env = { POSTGRESQL_URL = "<POSTGRESQL_URL>", PG_URL = "<PG_URL>", DATABASE_URL = "<DATABASE_URL>" }
# codex mcp add postgresql-schema --env POSTGRESQL_URL='<POSTGRESQL_URL>' --env PG_URL='<PG_URL>' --env DATABASE_URL='<DATABASE_URL>' -- docker run -i --rm mcp/postgres postgresql://host.docker.internal:5432/mydb~/.cursor/mcp.json
{
"mcpServers": {
"postgresql-schema": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"mcp/postgres",
"postgresql://host.docker.internal:5432/mydb"
],
"env": {
"POSTGRESQL_URL": "<POSTGRESQL_URL>",
"PG_URL": "<PG_URL>",
"DATABASE_URL": "<DATABASE_URL>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"postgresql-schema": {
"type": "stdio",
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"mcp/postgres",
"postgresql://host.docker.internal:5432/mydb"
],
"env": {
"POSTGRESQL_URL": "<POSTGRESQL_URL>",
"PG_URL": "<PG_URL>",
"DATABASE_URL": "<DATABASE_URL>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"postgresql-schema": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"mcp/postgres",
"postgresql://host.docker.internal:5432/mydb"
],
"env": {
"POSTGRESQL_URL": "<POSTGRESQL_URL>",
"PG_URL": "<PG_URL>",
"DATABASE_URL": "<DATABASE_URL>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"postgresql-schema": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"mcp/postgres",
"postgresql://host.docker.internal:5432/mydb"
],
"env": {
"POSTGRESQL_URL": "<POSTGRESQL_URL>",
"PG_URL": "<PG_URL>",
"DATABASE_URL": "<DATABASE_URL>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"postgresql-schema": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"mcp/postgres",
"postgresql://host.docker.internal:5432/mydb"
],
"env": {
"POSTGRESQL_URL": "<POSTGRESQL_URL>",
"PG_URL": "<PG_URL>",
"DATABASE_URL": "<DATABASE_URL>"
}
}
}
}需要的环境变量
POSTGRESQL_URLPG_URLDATABASE_URL
把占位值换成你自己的密钥；不要把密钥提交到代码仓库。