Viewing SQLite3 Database (XCODE)

The SQLite database will be created in your apps Documents folder, in the simulator's base directory.

Before Xcode 6, you can check in:

~/Library/Application Support/iPhone Simulator/4.2/Applications/GUID/Documents

There is also a Mac OS X application called SQLiteBrowser that you can use to browse the database your app created.

Update :

As of Xcode 6, the new iOS simulator's directory is located here :

~/Library/Developer/CoreSimulator

Ultimately, you can find your app's database under a location like this (Replace UIDs by yours) :~/Library/Developer/CoreSimulator/Devices/4D2D127A-7103-41B2-872B-2DB891B978A2/data/Containers/Data/Application/0323215C-2B91-47F7-BE81-EB24B4DA7339/Documents/MyApp.sqlite

Source: SO: Xcode 6 iPhone Simulator Application Support Location

If you want to view the database that you are created,

Open finder press Command+g "~/Library/Application Support/iPhone Simulator" then go.

Open 5.0 (as per your version of simulator)-> Application-> select the pgm folder

-> Documents

Then you can see the database

Xcode 9.1:

1. Open Terminal, type:

   cd ~ & find -name "YourModelName.sqlite"

2. You'll most likely be presented with such a path:

~/Library/Developer/CoreSimulator/Devices/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX/data/Containers/Data/Application/YYYYYYYY-YYYY-YYYY-YYYY-YYYYYYYYYYYY/Library/Application Support/

3. Open Finder, press Shift + Command + G, paste the path and press Go.
4. Use DB Browser for SQLite to view the .sqlite file.