A Model Context Protocol server for PostgreSQL databases with SSL support
Wellknown found it in public sources; nobody has proven control of it yet. Claiming takes one click if the repository is under your GitHub account, or a small file on your domain otherwise. Verified owners get the badge, 15-minute checks, status alerts, edits that outrank crawled data, and a ranking boost.
Agents can do it too: POST https://wellknown.network/api/v1/claims with {"agent":"postgres-mcp-server","method":"well_known_file"} — machine-readable steps at claim.json, guide at /docs/claim.
Everything here was measured by our prober or read from a registry. Nothing is self-reported.
Attributed to the source that supplied each field. Treated as claims, not facts.
# PostgreSQL MCP Server A Model Context Protocol (MCP) server for PostgreSQL databases. This server provides read-only access to PostgreSQL databases through the MCP protocol, allowing AI assistants to query database schemas and execute SELECT queries safely. ## Features - **Schema Exploration**: Browse database tables and their column information - **Read-only Queries**: Execute SELECT queries safely with transaction isolation - **SSL Support**: Handles SSL connections with proper fallback options - **Connection Pooling**: Efficient database connection management - **Security**: Only allows SELECT queries to prevent data modification ## Installation Install with pip: ```bash pip install postgres-mcp-server ``` Or run directly with uvx (recommended): ```bash uvx postgres-mcp-server "postgresql://username:password@hostname:port/database" ``` ## MCP Client Configuration To use this server with MCP clients, configure it in your MCP settings: ### Claude Desktop Add to your `claude_desktop_config.json`: ```json { "mcpServers": { "postgres": { "command": "uvx", "args": [ "postgres-mcp-server", "postgresql://username:password@localhost:5432/database" ] } } } ``` **Configuration file locations:** - **macOS**: `~/Library/Application Support/Claude/claude_desktop_config.json` - **Windows**: `%APPDATA%\Claude\claude_desktop_config.json` ### Environment Variables For security, avoid hardcoding credentials: ```json { "mcpServers": { "postgres": { "command": "uvx", "args": [ "postgres-mcp-server", "postgresql://${POSTGRES_USER}:${POSTGRES_PASSWORD}@${POSTGRES_HOST}:${POSTGRES_PORT}/${POSTGRES_DB}" ], "env": { "POSTGRES_HOST": "localhost", "POSTGRES_PORT": "5432", "POSTGRES_DB": "database", "POSTGRES_USER": "username", "POSTGRES_PASSWORD": "password" } } } } ``` ### SSL Configuration Examples #### Development (SSL disabl…
Mapped onto the structured taxonomy from declared text and observed tool names. Confidence shown for derived entries.
Every source is kept verbatim. Field changes are logged as events.