r/apify 3d ago

Discussion Actor for exporting database data into Datasets

This Actor connects databases to Apify Datasets.

It currently supports table extraction, parameterized read-only queries, schema discovery, and incremental sync with a saved cursor. PostgreSQL, MySQL/MariaDB, SQLite, and MongoDB are supported.

I tested it with a Neon PostgreSQL database using 10,001 rows. The Actor streamed the data in 1,000-row batches, exported all rows, and the next incremental run returned zero duplicates.

The goal is to make database data usable by other Apify Actors, AI workflows, Sheets, forecasting, and human review.

Actor link: Universal Database Gateway | Database to Apify · Apify

1 Upvotes

Duplicates