Neo4j – Is there a cypher query syntax to list (show) all indexes in DB?

neo4j 3.1 now supports this as a built-in procedure that you can CALL from Cypher:

CALL db.indexes();

http://neo4j.com/docs/operations-manual/3.1/reference/procedures/