PostgreSQL MCP server with consolidated tools for database management, queries, data changes and security.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add postgresql -- node /path/to/postgresql-mcp-server/build/index.js~/.codex/config.toml
[mcp_servers.postgresql]
command = "node"
args = ["/path/to/postgresql-mcp-server/build/index.js"]
# codex mcp add postgresql -- node /path/to/postgresql-mcp-server/build/index.js~/.cursor/mcp.json
{
"mcpServers": {
"postgresql": {
"command": "node",
"args": [
"/path/to/postgresql-mcp-server/build/index.js"
]
}
}
}.vscode/mcp.json
{
"servers": {
"postgresql": {
"type": "stdio",
"command": "node",
"args": [
"/path/to/postgresql-mcp-server/build/index.js"
]
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"postgresql": {
"command": "node",
"args": [
"/path/to/postgresql-mcp-server/build/index.js"
]
}
}
}claude_desktop_config.json
{
"mcpServers": {
"postgresql": {
"command": "node",
"args": [
"/path/to/postgresql-mcp-server/build/index.js"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"postgresql": {
"command": "node",
"args": [
"/path/to/postgresql-mcp-server/build/index.js"
]
}
}
}