{"library":"psycopg","install":[{"cmd":"pip install psycopg","imports":["import psycopg\n\n# row_factory for dict rows — moved to connect() not cursor()\nwith psycopg.connect(\n    'postgresql://user:pass@localhost/mydb',\n    row_factory=psycopg.rows.dict_row\n) as conn:\n    with conn.cursor() as cur:\n        cur.execute('SELECT * FROM users WHERE id = %s', (user_id,))\n        row = cur.fetchone()\n        print(row['name'])","import psycopg\nimport asyncio\n\nasync def main():\n    async with await psycopg.AsyncConnection.connect(\n        'postgresql://user:pass@localhost/mydb',\n        row_factory=psycopg.rows.dict_row\n    ) as conn:\n        async with conn.cursor() as cur:\n            await cur.execute('SELECT * FROM users')\n            rows = await cur.fetchall()\n            for row in rows:\n                print(row['name'])\n\nasyncio.run(main())"]},{"cmd":"pip install psycopg[binary]","imports":[]},{"cmd":"pip install psycopg[pool]","imports":[]}]}