I have had success using SQuirreL SQL Client http://www.squirrelsql.org. I used the Apache Embedded Derby driver and create an alias( SQuirrelL talk for db driver mapping) pointing to …/nxserver/data/derby/nuxeo/ data base in a standard download of Nuxeo.

The main table for document is the hierarchy table. To understand the database structure, see here. I didn't know that there was a SQL Client to parse the derby database.

Thanks,

Benjamin JALON