Anybody tried connecting an in-house database to this type of service? seems like it should be relatively straightforward.

Idea is to have a mailchimp database that our website users can subscribe to, and also collect addresses from customers at point of sale. Then have a nightly process to synchronise them.

They publish an API for XML-RPC, PHP and JSON.