I am running the full NEM node client on my machine. Is there a way to directly access the SQL database of NEM in order to make some analyses on the NEM blockchain?
Of course, there is the possiblity to access the database through the NEM api but overall it does need more time than directly accessing the SQL db.
It's an h2 db or Hibernate database. You could use the spring framework or hibernate jar to issue sql against it in java if you wanted.