Self-Hosted WhatsApp API Integration

I need a fully self-hosted deployment of the WhatsApp Business API that talks directly to our existing database. The key outcomes are:

• Automatic WhatsApp messages fire the moment predefined events are written to our tables.
• Customer and order details stay in sync in both directions, so any update made inside a WhatsApp chat is reflected in the database and vice-versa.

I will provide database credentials, schema documentation, and the message templates once you are ready to connect. The stack you choose is up to you—Docker, node, Python, or another language is fine as long as the final solution installs on our own server and we retain complete control of the data and access tokens.

Deliverables
1. Production-ready WhatsApp Business API deployed on our server.
2. Secure bridge service that:
• Listens for insert / update events and pushes the right message template.
• Maps chat replies to the correct customer or order record.
3. Clear environment variables or config file so we can change endpoints, tokens, and template IDs without touching code.
4. Setup script or step-by-step guide that lets us rebuild the entire stack from scratch.

Acceptance criteria
– All chosen events reliably trigger the correct message in a test run of at least 100 records.
– Sync latency between WhatsApp and the database is under one minute in both directions.
– No data leaves our server other than messages sent through the WhatsApp API.
– Full source code and documentation are handed over.

Once those boxes are ticked, the project is complete and we move the system to live traffic.