Running SQL databases offline

I'm running a Debian 10 based distro. As an experiment, I downloaded one of these Wikipedia-like sites which gives you a download size of several gigabytes. I was hoping to run it offline. I don't know if I ever had any experience with .sql, maybe 15+ years ago in high school. When unzipped, it has a bunch of folders, images is the largest folder, anyway I think the main one is the database.sql which is 3GB. How easy is it to navigate this database offline? Obviously when it runs online, there is a search function, etc. If running something like this is feasible on an offline desktop, what .sql programs need to be installed in order to do it?