DAP initdb error: missing dependency asyncpg

george_markaria

When I try to run the following command:

dap initdb --namespace canvas --table accounts

I receive the error: missing dependency: `asyncpg`; you may need to run `pip install pysqlsync`

although pysqlsync is installed already. (pysqlsync 0.8.3)

Any advice on what steps need to be taken to fix this?

Running Python 3.14.0 and Dap 2.0.1

george_markaria

I'm going to answer my own question here in case it helps others. If you get the error like I did in the original post stating:

missing dependency: `asyncpg`; you may need to run `pip install pysqlsync`

 

Do not run what they recommend as "run pip install pysqlsync". Instead you need to run the what is missing asyncpg so run the command:

pip install asyncpg

 

That did it for me. Similar if you are installing MySQL (which is what I went with instead). You can find all the packages here: https://pypi.org/