PostgreSQL MCP Server
A community-driven MCP server that binds the Model Context Protocol to a secure PostgreSQL sandbox. It features Code Mode using V8 isolates for token savings, 278 specialized tools, OAuth 2.1 authentication, connection pooling, and support for extensions like pgvector and PostGIS.
Package and access
Local package with source-attributed installation metadata. Koskamo does not execute packages during review.
What you can do with it
- Execute complex multi-step database operations with reduced token overhead
- Authenticate database access via OAuth 2.1 with granular permissions
- Support AI agents with deterministic error handling for SQL exceptions
- Manage PostgreSQL databases using 278 token-optimized tools
Source and maintenance
- Maintenance checked
Packages and installation
Source-provided package data. Koskamo has not executed or live-probed this package.
docker.io/writenotenow/postgres-mcp:v1.0.2
{
"transport": "stdio",
"identifier": "docker.io/writenotenow/postgres-mcp:v1.0.2",
"registryType": "oci"
}Tools
Reported by the attributed source; not independently observed by Koskamo.
Connect from your client
Each snippet configures the same source-provided package; replace placeholders before use.
Cursor
{
"mcpServers": {
"postgresql-mcp-server": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"docker.io/writenotenow/postgres-mcp:v1.0.2"
]
}
}
}Cline
{
"mcpServers": {
"postgresql-mcp-server": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"docker.io/writenotenow/postgres-mcp:v1.0.2"
]
}
}
}VS Code
{
"servers": {
"postgresql-mcp-server": {
"type": "stdio",
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"docker.io/writenotenow/postgres-mcp:v1.0.2"
]
}
}
}Claude Desktop
{
"mcpServers": {
"postgresql-mcp-server": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"docker.io/writenotenow/postgres-mcp:v1.0.2"
]
}
}
}Let your agent find its tools
Find servers like PostgreSQL MCP Server from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.