[ghh]

Other solutions in the `write sql and share the graphs with your team`-space:

- ChartIO

- 'WagonHQ, Modern SQL Editor' [1] (now aquired by Box)

- MetaBase [2,3]

- Redash [4]

MetaBase is the only one that I know of that is

- fully open source,

- mature (graphing options, permission model),

- still actively maintained, and

- both friendly to non-technical users and expert sql'ers alike

[1] https://news.ycombinator.com/item?id=9792464

[2] http://www.metabase.com [3] https://news.ycombinator.com/item?id=10425959

[4] https://redash.io

[arikfr]

Redash creator here.

Just to make sure someone doesn't get the wrong impressions from your comment: Redash is 99% open source (and I'm going to close this gap this month[1]), mature and actively maintained. The friendliness is subjective, but we're not trying to please everyone :-)

[1] Sometimes it's easier to prototype new things in the SaaS version, but everything reaches open source eventually. There is practically one feature that wasn't open sourced until now, and I'm going to add it to the open source version now.

[fredmonroe]

is the feature joining multiple data sources? i'm a fan of redash btw, people should check it out. i use it as a docker container for self hosting

[arikfr]

It is :-)

[rodionos]

Redash is more that just a SQL editor. It's a full-featured dashboarding system which works particularly well with relational data sources.

[petepete]

I'd add Blazer to your list too. Used it with great success and it meets your 4 criteria.

https://github.com/ankane/blazer

[j_s]

Thanks for the links! Here's a recent related discussion of another product:

Franchise – An Open-Source SQL Notebook | https://news.ycombinator.com/item?id=15303833 (Sep 2017, 63 comments)

https://github.com/hvf/franchise

Also mentioned there:

https://github.com/apache/incubator-superset

[thenaturalist]

In case you're interested in more tools in that area, I'm actively maintaining & updating a list of BI related tools: https://github.com/thenaturalist/awesome-business-intelligen...

[huy]

To add on to your list:

https://www.holistics.io (I work here).

[LogicX]

We use and like redash, because we can have it trigger zapier tasks when there are new results on a query. Makes cross-integration when testing new things great, and saves time in development being able to hack together a stop-gap solution this way.

[amigoingtodie]

Can you go into more detail on this?

[pmx]

As far as I know there is no way to use or download Wagon now that Box has acquired them

[netcraft]

This is true an also what gives me pause before trying any more tools like this.

[infinite8s]

Would people pay for a desktop tool like this? How important is sharing? I had built something a year ago (on top of PyQt) but shelved it for lack of interest.

[pmx]

I might if it wasn't tied to a cloud service. Sharing not that important for me unless it can be done without the need for getting a 3rd party involved.

[mrmondo]

Metabase it’s pretty nice, although it’s a bit slow and resource intensive.

[nrjames]

It also seems to have some serious bugs. For example, none of their SQL Parameters examples[1] work with a Postgres connection. I just downloaded it this morning to give it a try after reading this topic.

[1]http://www.metabase.com/docs/v0.21.1/users-guide/12-sql-para...