Quary is an open-source business intelligence tool designed specifically for engineers. With Quary, you can effortlessly connect to your database, write SQL queries, create insightful charts, and maintain your work through version control. Join a thriving community and enhance your engineering projects with data-driven insights.
Quary: Open-source Business Intelligence for Engineers
Quary empowers engineers with a robust business intelligence solution designed to simplify data management, analysis, and reporting. With Quary, users can seamlessly connect to their databases, craft SQL queries to transform and organize data, and collaborate efficiently through version control. Whether you are creating insightful charts, comprehensive dashboards, or detailed reports, Quary is your go-to tool for data intelligence.
Key Features
- Database Connections: Easily connect to various databases and manage your data effectively.
- SQL Querying: Write SQL queries to structure, document, and organize your data effortlessly.
- Data Visualization (In Development): Create dynamic charts and reports to visualize your data insights.
- Collaborative Development: Test and refine your queries as you collaborate with your team in an iterative manner.
- Deployment: Deploy well-organized, documented models directly back into your database for easy access.
Supported Databases
Quary provides support for a variety of databases, including:
- Amazon Redshift
- Google BigQuery
- PostgreSQL
- Snowflake
- Supabase
- DuckDB
- SQLite
Asset Management
In Quary, users can define and manage several asset types with code:
- Sources: Specify external data sources like database tables, flat files, or APIs.
- Models: Transform raw data into analysis-ready datasets, breaking complex queries into manageable components.
- Charts: Create visual data representations directly using SQL.
- Dashboards (WIP): Aggregate multiple charts into a cohesive view for streamlined data analysis.
- Reports (WIP): Generate detailed reports to convey insights and findings with stakeholders.
Join the Community
Become part of the Quary community on Slack to share ideas, seek help, and discuss innovative data solutions. Quary aims to enhance the user experience; if you encounter any issues, feel free to create an issue on GitHub, and we'll assist you promptly.
Discover More
Explore our other project, SQRUFF, a high-speed SQL linter developed for maximum efficiency.
Quary is the ideal solution for engineers seeking to leverage business intelligence tools to enhance data-driven decision-making.