Redash is a web console for interfacing with databases, building queries and reports, and visualizing results. Includes SQLite, MySQL, Postgres, and even JSON documents. Snippets can be saved. Caches results, can autoupdate. Can join across different databases. Dashboards can be shared via unique links. Of course, has an API.
Github repo: https://github.com/getredash/redash