Viewer-SFCGAL is a basic 3D viewer based on OpenSceneGraph.

A screencast available on the SFCGAL homepage: http://oslandia.github.io/SFCGAL/screencast.html shows how it can be used to make it interact with a PostGIS database.