Is there a way to get a record count for each table in a connection;

Is there a way to get a record count for each table in a connection;

Without writing x queries. Trying to determine how much data volume I have so I can select the right  integration product