MagicStack/asyncpg

View on GitHub

A fast PostgreSQL Database Client Library for Python/asyncio.

Stars: 8.1k
Forks: 468
Open beginner issues: 0
Indexed issues: 257

Dominant language: Python
License: Apache-2.0
Last GitHub push: Sep 19, 2026
Latest indexed: Sep 19, 2026
Contributing guide: No contributing guide
Code of conduct: No code of conduct
Beginner labels: No beginner labels indexed
PR merge metrics: No merged PRs in 30d

Beginner friendly Everything

Open All

257 issues indexed so far

SCRAM: _generate_salted_password reimplements PBKDF2 in Python; hashlib.pbkdf2_hmac is ~30x faster and bit-identical Open

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

MagicStack/asyncpg#1357 · Opened Sep 10, 2026
Connection.close(timeout=) waits forever on a pending cancel when the server never acknowledges it Open

Difficulty 4/5 3-5 days Newbie friendliness 68/100

MagicStack/asyncpg#1356 · Opened Sep 4, 2026
Question: current maintenance status and release cadence Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

MagicStack/asyncpg#1355 · 3 reactions · Opened Sep 1, 2026
Connection.copy_records_to_table hanging when generator passed to records parameter raises exception with long error message Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

MagicStack/asyncpg#1354 · Opened Sep 1, 2026
Connect call failed error doesn't distinguish port mismatch from "server not running" Open

Difficulty 3/5 1-2 days Newbie friendliness 72/100

MagicStack/asyncpg#1342 · Opened Aug 6, 2026
TypeError in asyncpg.connect() for specific parameters when values are not str enough Open

Difficulty 3/5 1-2 days Newbie friendliness 56/100

MagicStack/asyncpg#1340 · 1 comment · Opened Jul 29, 2026
setup.py relies on deprecated pkg_resources Open

Difficulty 2/5 1-3 hours Newbie friendliness 28/100

MagicStack/asyncpg#1337 · Opened Jul 15, 2026
Regression in v0.31.0: with `statement_cache_size=0`, type introspection reuses the unnamed statement name `""` and clobbers a user statement on the server-side cursor path Open

Difficulty 4/5 3-5 days Newbie friendliness 55/100

MagicStack/asyncpg#1335 · 3 reactions · Opened Jul 14, 2026
v0.31.0: Undefined symbol "call_once" on FreeBSD 15 Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#1334 · 2 comments · Opened Jul 11, 2026
Python 3.15 nogil fails with segmentation error Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

MagicStack/asyncpg#1330 · 1 comment · Opened Jun 23, 2026
`Record.get()` with invalid positional argument count segfaults Open

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

MagicStack/asyncpg#1328 · Opened Jun 22, 2026
Regression in copy records performance between 0.30.0 and 0.31.0 Open

Difficulty 3/5 1-2 days Newbie friendliness 48/100

MagicStack/asyncpg#1327 · 1 reaction · Opened Jun 8, 2026
Connection teardown is unbounded on network fault: the query-cancel path (connect_utils._cancel) ignores all timeouts, hanging close(timeout=...) indefinitely Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

MagicStack/asyncpg#1326 · 1 reaction · Opened May 31, 2026
[Feature Request] Support transport encryption using GSSAPI Open

Difficulty 5/5 Over a week Newbie friendliness 38/100

MagicStack/asyncpg#1322 · Opened May 15, 2026
[Feature Request]Adding compatibility support for KingbaseES Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

MagicStack/asyncpg#1318 · Opened Apr 27, 2026
TLSUpgradeProto.data_received hides PostgreSQL ErrorResponse behind generic 'rejected SSL upgrade' ConnectionError Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

MagicStack/asyncpg#1317 · Opened Apr 10, 2026
suggestion Open

Difficulty 2/5 1-3 hours Newbie friendliness 55/100

MagicStack/asyncpg#1316 · Opened Apr 7, 2026
Cursor cannot be used with externally-managed transaction Open

Difficulty 3/5 1-2 days Newbie friendliness 42/100

MagicStack/asyncpg#1311 · Opened Mar 10, 2026
ConnectionError from _cancel() during CancelledError not caught, crashes callers Open

Difficulty 4/5 3-5 days Newbie friendliness 55/100

MagicStack/asyncpg#1310 · 1 comment · Opened Mar 9, 2026
asyncio CancelledError and TimeoutError when reconnecting to host in faillover mode Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

MagicStack/asyncpg#1309 · Opened Mar 3, 2026
bug: Possible connection pool deadlock Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#1307 · Opened Feb 18, 2026
`sslmode=prefere` surface misleading "no encryption" error when using a wrong password Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#1306 · Opened Feb 13, 2026
Test failure in test_pool_handles_transaction_exit_in_asyncgen_2 with Python 3.15.0a5, PYTHONASYNCIODEBUG=1 Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#1300 · Opened Jan 22, 2026
Query Wait Timout Error from Pgbouncer Not Propogating to Client Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

MagicStack/asyncpg#1299 · 2 reactions · Opened Jan 16, 2026
Please add named parameters Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

MagicStack/asyncpg#1298 · Opened Jan 13, 2026
SELECT within COPY statement does not have parameters substituted. Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

MagicStack/asyncpg#1295 · Opened Dec 19, 2025
copy_records_to_table depends on prepared statments even with cache=0 Open

Difficulty 4/5 3-5 days Newbie friendliness 30/100

MagicStack/asyncpg#1294 · Opened Dec 12, 2025
Temporary tables still visible after releasing connection to pool Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

MagicStack/asyncpg#1293 · Opened Dec 8, 2025
Segmentation fault on 0.31.0 when inside a Temporal activity Open

MagicStack/asyncpg#1292 · 17 comments · 1 reaction · 1 assignee · Opened Dec 2, 2025
Connect with passwordless DSN does not work Open

Difficulty 3/5 1-2 days Newbie friendliness 42/100

MagicStack/asyncpg#1286 · Opened Nov 13, 2025
Jsonb return as string sometimes '[]' Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

MagicStack/asyncpg#1284 · Opened Nov 6, 2025
Prepared Statement connection is active and wait for ClientRead. Open

Difficulty 5/5 Over a week Newbie friendliness 30/100

MagicStack/asyncpg#1276 · 5 comments · Opened Sep 29, 2025
Avoiding introspection queries for built-in array types Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

MagicStack/asyncpg#1272 · 1 reaction · Opened Sep 4, 2025
Pool created with min_size loses inactive connections and never re-acquires them Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

MagicStack/asyncpg#1268 · 4 reactions · Opened Aug 8, 2025
Cannot create type codec for composite type with certain field types. Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#1267 · Opened Aug 3, 2025
CancelledError not correctly handled in bind_execute_many() (was: unusual asyncio-related deadlock seen with gather() where one or more tasks are failing) Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

MagicStack/asyncpg#1265 · 5 comments · 3 reactions · Opened Jul 11, 2025
copy_from_query drops headers if any postgis NOTICE/LOCATION messages produced Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

MagicStack/asyncpg#1264 · Opened Jul 10, 2025
add listener callback not getting executed in asyncio pytest framework Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#1262 · Opened Jun 10, 2025
"AttributeError: 'NoneType' object has no attribute 'decode'" when executing empty script Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

MagicStack/asyncpg#1259 · 1 comment · Opened May 13, 2025
.pgpass file support handles backslash escapes incorrectly; should de-escape values Open

Difficulty 3/5 1-2 days Newbie friendliness 42/100

MagicStack/asyncpg#1249 · 2 comments · Opened Apr 3, 2025
Potential starvation with connection pool Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#1247 · Opened Mar 18, 2025
Intermittent no pg_hba.conf entry for host Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

MagicStack/asyncpg#1241 · 3 comments · Opened Mar 6, 2025
conn.execute return value Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

MagicStack/asyncpg#1238 · 1 comment · Opened Feb 28, 2025
Python 3.13.2: TestConnectParams.test_connect_params fails with ValueError: Invalid IPv6 URL Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

MagicStack/asyncpg#1236 · 2 comments · 1 reaction · Opened Feb 19, 2025
error in pytest sqlalchemy.exc.InterfaceError Open

Difficulty 3/5 1-2 days Newbie friendliness 25/100

MagicStack/asyncpg#1220 · 1 comment · Opened Jan 21, 2025
Application Flow Stuck Unless Connection is Explicitly Closed Open

Difficulty 3/5 1-2 days Newbie friendliness 25/100

MagicStack/asyncpg#1216 · Opened Jan 8, 2025
`get_settings()` can get out of sync after a transaction with an error is rolled back Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

MagicStack/asyncpg#1215 · Opened Dec 21, 2024
Feature request: A connection property to retreive host name used in specific connection Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#1213 · Opened Dec 3, 2024
Invalid OID Handling in SQLAlchemy with asyncpg and autoload_with Causes DataError Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

MagicStack/asyncpg#1212 · 3 comments · Opened Dec 2, 2024
unexpected connection_lost() call when cancelling a direct_tls connection with an active request can lead to a connection leak Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#1211 · 6 reactions · Opened Nov 15, 2024

MagicStack/asyncpg

Get new issues in your inbox