{"library":"mcp-postgres","title":"MCP PostgreSQL Server","description":"MCP server providing PostgreSQL database operations—query, schema inspection, data manipulation—for MCP-compatible clients. Current stable version: 1.2.1, released January 2025. Security-focused: v1.2.0 fixed SQL injection in column names and SSL validation. Supports environment variables, DATABASE_URL, or config file; auto-configures SSL for AWS RDS. Releases are frequent (two in Jan 2025) with security patches and fixes. Key differentiator: MCP-native protocol integration vs generic database drivers.","language":"javascript","status":"active","last_verified":"Sat Apr 25","install":{"commands":["npm install mcp-postgres"],"cli":{"name":"mcp-postgres","version":null}},"imports":["import server from 'mcp-postgres'","import { PostgresServer } from 'mcp-postgres'","import type { Config } from 'mcp-postgres'"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"import { PostgresServer } from 'mcp-postgres';\nimport { Server } from '@modelcontextprotocol/sdk/server/index.js';\n// The package is typically run as a CLI tool.\n// To run programmatically:\nimport { StdioServerTransport } from '@modelcontextprotocol/sdk/server/stdio.js';\nconst server = new PostgresServer({\n  host: process.env.DB_HOST ?? 'localhost',\n  port: parseInt(process.env.DB_PORT ?? '5432'),\n  user: process.env.DB_USER ?? 'postgres',\n  password: process.env.DB_PASSWORD ?? '',\n  database: process.env.DB_NAME ?? 'postgres',\n  sslmode: process.env.DB_SSL_MODE ?? 'disable'\n});\nconst transport = new StdioServerTransport();\nawait server.connect(transport);\nconsole.error('MCP PostgreSQL Server running on stdio');","lang":"typescript","description":"Programmatic setup of MCP PostgreSQL server with environment variables, connecting via stdio transport.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}