Generating WordPress pages from database

Is it possible to build WordPress-pages dynamically using a MySQL database and PHP?

I have now two sites: one with information about broadband connections and another one where one can search for the cheapest broadband by entering the name of the town. The result pages are created dynamically from the database.

I am wondering if WordPress allows the creation of pages dynamically from the database. In my database I have 400 names of cities and price information for all the cities.

I would like to have it so, that eg. https://www.broadband.com/city/newyork would be a dynamically created page that would use some template for the page. The page would display some basic text information about broadband is New York and price information in a table. All of this information would reside in the database, including the text.

How would I do this with WordPress?