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

[sgergely]

Hello @george_markaria ,

If you miss installing an extra feature, the library will not be able to synchronize data with a database, and you may get an error message similar to the following:

ERROR - missing dependency: asyncpg;

In this case you may need to run:Copy

pip install pysqlsync[postgresql]

[george_markaria]

When I try to run that, I receive the following:

C:\>pip install pysqlsync[postgresql]
Requirement already satisfied: pysqlsync[postgresql] in c:\users\5003796338\appdata\local\programs\python\python314\lib\site-packages (0.8.3)
Requirement already satisfied: json_strong_typing>=0.3.9 in c:\users\5003796338\appdata\local\programs\python\python314\lib\site-packages (from pysqlsync[postgresql]) (0.4.0)
Requirement already satisfied: truststore>=0.10 in c:\users\5003796338\appdata\local\programs\python\python314\lib\site-packages (from pysqlsync[postgresql]) (0.10.4)
WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'ReadTimeoutError("HTTPSConnectionPool(host='pypi.org', port=443): Read timed out. (read timeout=15)")': /simple/asyncpg/
Collecting asyncpg>=0.30 (from pysqlsync[postgresql])
  Using cached asyncpg-0.30.0.tar.gz (957 kB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... done
Requirement already satisfied: jsonschema>=4.24 in c:\users\5003796338\appdata\local\programs\python\python314\lib\site-packages (from json_strong_typing>=0.3.9->pysqlsync[postgresql]) (4.25.1)
Requirement already satisfied: attrs>=22.2.0 in c:\users\5003796338\appdata\local\programs\python\python314\lib\site-packages (from jsonschema>=4.24->json_strong_typing>=0.3.9->pysqlsync[postgresql]) (25.4.0)
Requirement already satisfied: jsonschema-specifications>=2023.03.6 in c:\users\5003796338\appdata\local\programs\python\python314\lib\site-packages (from jsonschema>=4.24->json_strong_typing>=0.3.9->pysqlsync[postgresql]) (2025.9.1)
Requirement already satisfied: referencing>=0.28.4 in c:\users\5003796338\appdata\local\programs\python\python314\lib\site-packages (from jsonschema>=4.24->json_strong_typing>=0.3.9->pysqlsync[postgresql]) (0.37.0)
Requirement already satisfied: rpds-py>=0.7.1 in c:\users\5003796338\appdata\local\programs\python\python314\lib\site-packages (from jsonschema>=4.24->json_strong_typing>=0.3.9->pysqlsync[postgresql]) (0.27.1)
Building wheels for collected packages: asyncpg
  Building wheel for asyncpg (pyproject.toml) ... error
  error: subprocess-exited-with-error

  × Building wheel for asyncpg (pyproject.toml) did not run successfully.

The error seems to be occurring in on this line, but I don't see a related directory.

C:\Users\<USER>\AppData\Local\Temp\pip-build-env-xsp7gntg\overlay\Lib\site-packages\setuptools\config\_apply_pyprojecttoml.py:82: SetuptoolsDeprecationWarning: `project.license` as a TOML table is deprecated

Any advice to move forward?

[george_markaria · Accepted solution]

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/