Is there a way to get a list of all the databases/annotation projects as well as where the databases are saved on the disk?


I have been having trouble getting a full list of all the annotation projects/databases that have been created, as well as the directories in which they are stored. Any guidance would be very appreciated.

Thanks, and stay safe and healthy!


Hi! There's typically only ever one database – if you're using the built-in configuration, that's either SQLite (default, stored as a file on disk) or MySQL or PostgreSQL. By default, SQLite writes to a file prodigy.db in your Prodigy home directory (.prodigy in your user home, unless you change it). But you can also customise the location and file name.

If you mean the datasets in the database, you can use the prodigy stats command with -l set to list all datasets present in the database. It will also show you the location of your Prodigy home directory that contains the database file. To export datasets as JSONL, you can run db-out.

If you want, you can also interact with the database programmatically – see here for details:

1 Like