Hi, Also a contributor to skardi here.
Presto is mainly focus on analytic queries, but skardi was optimized for serving online traffics, that means you can use skardi as a web server(define the SQL and skardi can turn it into a http server),I think that's the main difference.