Not sure if this is where you are looking for, but I gues you want to see the actual database? If so, then: When running the application, go to the "Console" tab. In that tab you see an "advanced" option, click on it and this will give you the option to start the build-in database viewer.
If you run the build-in database viewer you can run SQL query's.
Instead of using 'Execute statement', you can use 'Execute query' which is able to convert the results into mendix objects (which you can use to store them into the Mendix database).
See also documentation regarding the Database connector options in the appstore: https://appstore.home.mendix.com/link/app/2888/Mendix/Database-Connector
select name, number from stock
. This query has two columns of type String and Integer respectively. In order to use the Execute query action, you have to add an entity in the domain model that has the same attributes as the columns in the query.
You cannot perform direct INSERT commands into the Mendix database. You will somehow need to extract the data from your default database and convert them into Mendix objects, then commit the Mendix objects to the database.
In addition, you should check out the Database replication module in the appstore which is also capable to map data from external databases into Mendix
https://appstore.home.mendix.com/link/app/160/Mendix/Database-replication