The Database Module embeds a free SQL database engine into Ignition called H2. The database module is the easiest and fastest way to get started using SQL databases in Ignition.
Yes, it saves it on the same computer server that Ignition is installed. The DefaultH2 database that is automatically created for you is located in the Ignition folder here: Ignition/data/db/userdbs/default