{"library":"mcp-postgres-server","title":"MCP PostgreSQL Server","description":"A Model Context Protocol (MCP) server that enables AI models, particularly Claude, to interact with PostgreSQL databases through standardized tools like query, execute, list_schemas, list_tables, and describe_table. Version 0.1.3 is the latest stable release, currently in early development with active updates. It supports both PostgreSQL-style ($1, $2) and MySQL-style (?) parameter placeholders for prepared statements, multi-schema operations, and TypeScript types. Unlike generic database MCP servers, it is purpose-built for PostgreSQL, offering secure connection handling via environment variables and automatic cleanup. It is designed for use with MCP-compatible hosts (e.g., Claude Desktop) and should not be confused with direct database client libraries.","language":"javascript","status":"active","last_verified":"Sat Apr 25","install":{"commands":["npm install mcp-postgres-server"],"cli":null},"imports":["import server from 'mcp-postgres-server'","import { Server } from 'mcp-postgres-server'"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"npx mcp-postgres-server\n\n# Then configure in your MCP client (e.g., Claude Desktop):\n# {\n#   \"mcpServers\": {\n#     \"postgres\": {\n#       \"type\": \"stdio\",\n#       \"command\": \"npx\",\n#       \"args\": [\"-y\", \"mcp-postgres-server\"],\n#       \"env\": {\n#         \"PG_HOST\": process.env.PG_HOST ?? 'localhost',\n#         \"PG_PORT\": process.env.PG_PORT ?? '5432',\n#         \"PG_USER\": process.env.PG_USER ?? 'postgres',\n#         \"PG_PASSWORD\": process.env.PG_PASSWORD ?? '',\n#         \"PG_DATABASE\": process.env.PG_DATABASE ?? 'mydb'\n#       }\n#     }\n#   }\n# }","lang":"typescript","description":"Runs the MCP PostgreSQL server via npx and shows the required environment variable configuration for MCP client integration.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}