d4software/querytree repository overview

QueryTree is an ad-hoc reporting tool that works with any Microsoft SQL Server, PostgreSQL or MySQL database. It allows users to query databases, build reports and schedule those reports to email distribution lists, without needing to write any code.

Contribute github.com/D4Software/QueryTree⁠

⁠Features

QueryTree can connect to MySQL and PostgreSQL databases using SSH tunnels, secured with passwords or key files.

Supports customization of the logo image, system name and CSS used within the app.

Can use either Sqlite or Microsoft SQL Server database for it's own user and reports data storage.

Database and SSH passwords are stored in its database in encryped form, using AES encryption. Users may provide their own key file, or let the system generate one on first run. Keys can be shared between mutliple web servers in a load balancing scenario.