Yes, you can use the Database Connector in the Mendix Appstore: https://appstore.home.mendix.com/link/app/2888/Mendix/Database-Connector
This connector enables you to run SQL queries on external databases. It will not create entities for you, this is something need to do yourself using a domain model.