I am searching for an openSource self hosted Business Intelligence Tool. As sonamor pointed out here, The project metabase.com ist actually very good suited BUT - it is build on JAVA/clojure and I can't develop on that.

I am searching for something that is build on PHP. It would be greate to be able to build SQL queiries, without the SQL knowledge.

Does anyone know such tool?

  • 1
    You can create SQL Questions using metabase's query creator. I really suggest you to install it, as it only takes 5 mins, and play around with it.
    – Sonamor
    Commented Aug 14, 2017 at 15:59
  • That's metabase.com and it looks ok (+1). Be aware that there are many which do roughly the same thing, so you should examine a few and decide which is best for your needs.
    – Mawg
    Commented Jan 25, 2018 at 8:03

2 Answers 2


I had been myself searching for this for a long time. Although the following did not suffice my use-case, probably, they might for you.




Kool Report should be most relevant to you use-case


You may want to look at open source BI product Helical Insight (www.helicalinsight.com). It does have a simple drag drop interface with options of embeddding, SSO, row level data security, exporting, email scheduling etc. Definitely worth trying

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.