{"id":23320,"library":"awslabs-postgres-mcp-server","title":"AWS Labs PostgreSQL MCP Server","description":"An AWS Labs Model Context Protocol (MCP) server for PostgreSQL. It provides a lightweight MCP interface to interact with PostgreSQL databases, enabling AI agents to query schemas, execute read-only queries, and retrieve metadata. Current version is 1.1.1 with a fast release cadence. Requires Python >=3.10.","status":"active","version":"1.1.1","language":"python","source_language":"en","source_url":"https://github.com/awslabs/postgres-mcp-server","tags":["aws","postgresql","mcp","ai-agent","database"],"install":[{"cmd":"pip install awslabs-postgres-mcp-server","lang":"bash","label":"Install from PyPI"}],"dependencies":[{"reason":"Core MCP protocol library","package":"mcp","optional":false},{"reason":"PostgreSQL adapter","package":"psycopg2-binary","optional":false}],"imports":[{"wrong":"from awslabs_postgres_mcp_server import PostgresMCPServer","symbol":"PostgresMCPServer","correct":"from awslabs.postgres_mcp_server import PostgresMCPServer"}],"quickstart":{"code":"import os\nfrom awslabs_postgres_mcp_server import PostgresMCPServer\n\n# Connection parameters (use env vars for security)\ndatabase_url = os.environ.get('DATABASE_URL', 'postgresql://user:pass@localhost:5432/mydb')\n\n# Initialize and run the MCP server\nserver = PostgresMCPServer(database_url=database_url, read_only=True)\nserver.run()","lang":"python","description":"Creates a read-only MCP server that exposes PostgreSQL schema and query capabilities."},"warnings":[{"fix":"Use `import awslabs_postgres_mcp_server` (underscores).","message":"The package name on PyPI uses hyphens (awslabs-postgres-mcp-server), but the Python module uses underscores (awslabs_postgres_mcp_server). Many users incorrectly import using hyphens.","severity":"gotcha","affected_versions":"all"},{"fix":"Update instantiation: `server = PostgresMCPServer(database_url=..., port=8080)`.","message":"Version 1.0.0 introduced a breaking change: the `run()` method no longer accepts a `port` argument; use the constructor parameter instead.","severity":"breaking","affected_versions":">=1.0.0"},{"fix":"Use `read_only=True` instead of `allow_write=False`.","message":"The parameter `allow_write` is deprecated as of v1.1.0; use `read_only` instead (inverted logic).","severity":"deprecated","affected_versions":">=1.1.0"}],"env_vars":null,"search_vec":"'1.1.1':44 '3.10':52 'agent':29,58 'ai':28,57 'ai-ag':56 'aw':1,7,53 'cadenc':49 'context':10 'current':41 'databas':26,59 'enabl':27 'execut':33 'fast':47 'interact':23 'interfac':21 'lab':2,8 'lightweight':19 'mcp':4,12,20,55 'metadata':40 'model':9 'postgresql':3,15,25,54 'protocol':11 'provid':17 'python':51 'queri':31,37 'read':35 'read-on':34 'releas':48 'requir':50 'retriev':39 'schema':32 'server':5,13 'version':42","created_at":"2026-05-01T08:07:08.548494+00:00","updated_at":"2026-05-01T08:07:08.548494+00:00","problems":{"verify_error":"Traceback (most recent call last):\n  File \"<string>\", line 1, in <module>\nImportError: cannot import name 'PostgresMCPServer' from 'awslabs.postgres_mcp_server' (/tmp/tmpzbk0n29u/venv/lib/python3.12/site-packages/awslabs/postgres_mcp_server/__init__.py)"},"ecosystem":"pypi","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":"1.1.6","cli_name":"postgres-mcp-server","cli_version":"sh: 1: postgres-mcp-server: not found","type":"library","homepage":"https://awslabs.github.io/mcp/","github":"https://github.com/awslabs/mcp","docs":"https://awslabs.github.io/mcp/servers/postgres-mcp-server/","changelog":"https://github.com/awslabs/mcp/blob/main/src/postgres-mcp-server/CHANGELOG.md","pypi":"https://pypi.org/project/awslabs-postgres-mcp-server/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["aws","database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":"import_fail","verified_at":"2026-07-03","last_verified":"2026-07-03","next_check":"2026-07-10","install_tag":null}}