Please correct me if I'm mistake, but doesn't that require a separately prepared model in both Postgres and madlib?

You cannot simply request for an arbitrary prediction in a single & simple query.