H2 database console provides an awesome and very helpful web based interface to view any database. You can view the database by following URL

http://localhost:8080/applicationName/dbconsole

or following URL If you have set application context to ‘/’ by using grails.app.context = ‘/’ in Config.groovy.

http://localhost:8080/dbconsole

By default URI is /dbconsole but if you want you can change it. Just add following code in Config.groovy:

grails.dbconsole.urlRoot = 'myconsole'

and now your URL becomes

http://localhost:8080/applicationName/myconsole

or

http://localhost:8080/myconsole

H2 database console by default available in development environment only. If you want you can disable it for development environment also. Use the following settings

environments {
    development {
        ...
	grails.dbconsole.enabled = false
    }
    production {
        ...        
    }
}

And you can enable it for other environments as well like:

environments {
    development {
        ...
    }
    production {
        ...
        grails.dbconsole.enabled = true
    }
}

Hope this helps 🙂 .