In the "Sources" menu, click "Databases".
Click the "plus" button to start adding a new database.
Now enter connection information for your Resurface database. Also make sure to enable the option to expose this database in SQL Lab.
Your database connection should now be available for use.
You can now explore tables & columns in the "public/http" schema, and run SQL queries against your Resurface database.