{"library":"neon","type":"library","category":null,"description":"Neon is a serverless PostgreSQL platform (acquired by Databricks May 2025 for ~$1B). Not a Python package — connect using standard PostgreSQL drivers (psycopg2, psycopg, asyncpg, SQLAlchemy). Two connection string types: pooled (-pooler in hostname, via PgBouncer) and direct. Pooled is now the default in Neon Console. Critical: always include sslmode=require. asyncpg with pooled connections requires statement_cache_size=0.","language":"python","status":"active","version":"platform","tags":["neon","postgresql","serverless","pgbouncer","asyncpg","psycopg2","python"],"install":[{"cmd":"pip install psycopg2-binary","imports":["import psycopg2\nimport os\n\n# Pooled connection (default from Neon Console)\n# hostname includes -pooler\nconn = psycopg2.connect(\n    os.environ['DATABASE_URL']  # must include sslmode=require\n)\n# DATABASE_URL format:\n# postgresql://user:pass@ep-xxx-pooler.region.aws.neon.tech/dbname?sslmode=require","import asyncpg\nimport os\n\nasync def get_pool():\n    # Neon pooler uses PgBouncer in transaction mode\n    # Must disable prepared statement cache\n    pool = await asyncpg.create_pool(\n        os.environ['DATABASE_URL'],\n        statement_cache_size=0  # required for Neon pooler\n    )\n    return pool","# Pooled — for app traffic (up to 10k concurrent connections)\nDATABASE_URL = 'postgresql://user:pass@ep-cool-rain-123456-pooler.us-east-2.aws.neon.tech/neondb?sslmode=require'\n\n# Direct — for migrations only (alembic, django migrate)\nDATABASE_URL_UNPOOLED = 'postgresql://user:pass@ep-cool-rain-123456.us-east-2.aws.neon.tech/neondb?sslmode=require'"]},{"cmd":"pip install psycopg","imports":[]},{"cmd":"pip install asyncpg","imports":[]}],"homepage":"https://neon.tech","github":"https://github.com/yoichi-hiromoto/neon","docs":null,"changelog":null,"pypi":"https://pypi.org/project/neon/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":67,"avg_install_s":1.7,"avg_import_s":0.05,"wheel_type":"wheel"},"url":"https://checklist.day/v1/registry/neon/compatibility"},"provenance":{"verified_status":"passing","verified_at":"Sat Jun 27","last_verified":"Sat Jun 27","next_check":"Mon Jul 27","install_tag":"verified"}}