Are there any plans to add meltano to caprover

Not currently, no, but I'd welcome an issue in https://gitlab.com/meltano/meltano/-/issues to start exploring that with the community!