Would it be possible to have a API for another database with its own topics, posts, search and integrate that into Discourse so I can use Discourse as a front end and that as an backend?

No. Think about import your data.

Is it possible to import 500gb+? Or is there a size limit

Integrate an existing database to Discourse

Falco (Falco) July 17, 2023, 10:21pm 5

No, there is no size limit.

Topic		Replies	Views
Import CSV into Discourse Marketplace	1	1035	April 11, 2021
Import from self build board? Self-hosting	4	766	April 2, 2020
Need someone to help me import old forum members and topics! Marketplace	3	1544	January 25, 2016
[Paid] Migrate proprietary forums to Discourse Marketplace delivered	3	1473	April 16, 2020
Deeply integrating Discourse into website Development	6	12256	February 17, 2022