I've written a sql to elasticsearch mapping tool I feel I should of released. Eleasticsearch is in desperate need of many tools we take for granted in sql land, like a command line client you can easily punch in queries on the fly because trying to write multi line json into the commandline curl is death so I'm forced to install kibana.