PostgreSQL readonly (Archived)
Connect with read-only access to PostgreSQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
100K+
23
1 Tool
Version 4.43 or later needs to be installed to add the server automatically
Connect the MCP Toolkit gateway to Claude Desktop using:
Once connected, you can install this MCP server using:
Note: You should still configure the server and specify required secrets after installing it.
Restart Claude Desktop for the changes to take effect.
- Open Claude Settings.
- Select the Developer tab.
- Select the Edit Config button.
- Add
postgresto themcpServerssection:
{
"mcpServers": {
"postgres": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"POSTGRES_URL",
"mcp/postgres@sha256:b72c08f19e864b3e8beea8e90d048b9271924e704113345a29683f6d1e95a8f0",
"$POSTGRES_URL"
],
"env": {
"POSTGRES_URL": "postgresql://host.docker.internal:5432/mydb"
}
}
}
}Connect the MCP Toolkit gateway to Continue.dev using:
Once connected, you can install this MCP server using:
Note: You should still configure the server and specify required secrets after installing it.
- In your global .continue folder (~/.continue on Mac/Linux, %USERPROFILE%.continue on Windows), create a a folder called mcpServers.
- Create a new file named postgres.yaml in the mcpServers folder.
- Write the following contents to postgres.yaml and save.
name: Docker MCP PostgreSQL readonly (Archived)
version: 1.0.1
schema: v1
mcpServers:
- name: PostgreSQL readonly (Archived)
command: docker
args:
- run
- --rm
- -i
- -e
- POSTGRES_URL
- mcp/postgres@sha256:b72c08f19e864b3e8beea8e90d048b9271924e704113345a29683f6d1e95a8f0
- $POSTGRES_URL
env:
POSTGRES_URL: "postgresql://host.docker.internal:5432/mydb"Connect the MCP Toolkit gateway to Cursor using:
Once connected, you can install this MCP server using:
Note: You should still configure the server and specify required secrets after installing it.
- Open Cursor Settings.
- Select the MCP Tools tab.
- Select the New Custom MCP button.
- Add
postgresto themcpServerssection:
{
"mcpServers": {
"postgres": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"POSTGRES_URL",
"mcp/postgres@sha256:b72c08f19e864b3e8beea8e90d048b9271924e704113345a29683f6d1e95a8f0",
"$POSTGRES_URL"
],
"env": {
"POSTGRES_URL": "postgresql://host.docker.internal:5432/mydb"
}
}
}
}Define the MCP Toolkit gateway as a server in the MCP Visual Studio Code user settings. Learn more
"mcp": {
"servers": {
"MCP_DOCKER": {
"command": "docker",
"args": [
"mcp",
"gateway",
"run"
],
"type": "stdio"
}
}
}Once connected, you can install this MCP server using:
Note: You should still configure the server and specify required secrets after installing it.
Connect the MCP Toolkit gateway to Gordon using:
Once connected, you can install this MCP server using:
Note: You should still configure the server and specify required secrets after installing it.
Manual installation
You can install the MCP server using:
Installation for