https://github.com/quarylabs/quary Skip to content Navigation Menu Toggle navigation Sign in * Product + Actions Automate any workflow + Packages Host and manage packages + Security Find and fix vulnerabilities + Codespaces Instant dev environments + Copilot Write better code with AI + Code review Manage code changes + Issues Plan and track work + Discussions Collaborate outside of code Explore + All features + Documentation + GitHub Skills + Blog * Solutions For + Enterprise + Teams + Startups + Education By Solution + CI/CD & Automation + DevOps + DevSecOps Resources + Learning Pathways + White papers, Ebooks, Webinars + Customer Stories + Partners * Open Source + GitHub Sponsors Fund open source developers + The ReadME Project GitHub community articles Repositories + Topics + Trending + Collections * Pricing Search or jump to... Search code, repositories, users, issues, pull requests... Search [ ] Clear Search syntax tips Provide feedback We read every piece of feedback, and take your input very seriously. [ ] [ ] Include my email address so I can be contacted Cancel Submit feedback Saved searches Use saved searches to filter your results more quickly Name [ ] Query [ ] To see all available qualifiers, see our documentation. Cancel Create saved search Sign in Sign up You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert {{ message }} quarylabs / quary Public * Notifications * Fork 11 * Star 830 * Open-source BI for engineers www.quary.dev License Apache-2.0 license 830 stars 11 forks Branches Tags Activity Star Notifications * Code * Issues 11 * Pull requests 7 * Discussions * Actions * Projects 0 * Security * Insights Additional navigation options * Code * Issues * Pull requests * Discussions * Actions * Projects * Security * Insights quarylabs/quary This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository. main BranchesTags Go to file Code Folders and files Name Name Last commit Last commit message date Latest commit History 175 Commits .github .github .hacking .hacking assets assets js/packages js/packages proto proto rust rust .clippy.toml .clippy.toml .gitattributes .gitattributes .gitignore .gitignore .markdownlint.yaml .markdownlint.yaml .nvmrc .nvmrc .prettierignore .prettierignore .rustfmt.toml .rustfmt.toml Cargo.lock Cargo.lock Cargo.toml Cargo.toml LICENSE LICENSE Makefile Makefile README.md README.md buf.gen.yaml buf.gen.yaml buf.work.yaml buf.work.yaml commitlint.config.js commitlint.config.js install.sh install.sh package.json package.json pnpm-lock.yaml pnpm-lock.yaml pnpm-workspace.yaml pnpm-workspace.yaml prettier.config.mjs prettier.config.mjs rust-toolchain.toml rust-toolchain.toml View all files Repository files navigation * README * Apache-2.0 license [6874747073] Quary Business Intelligence for Engineers Made by Quary Slack Community YC GitHub Repo stars With Quary, engineers can: * Connect to their Database * Write SQL queries to transform, organize, and document tables in a database * Create charts, dashboards and reports (in development) * Test, collaborate & refactor iteratively through version control * Deploy the organised, documented model back up to the database View the documentation. [?] Supported Databases Amazon Redshift Google BigQuery PostgreSQL Snowflake Supabase DuckDB SQLite quary_core_image [?] Asset Types in Quary Define and manage the following asset types as code: * Sources: Define the external data sources that feed into Quary, such as database tables, flat files, or APIs (with DuckDB). * Models: Transform raw data from sources into analysis-ready datasets using SQL, this lets engineers split complex queries into atomic components. * Charts: Create visual representations of your data using SQL. * Dashboards (WIP): Combine multiple charts into a single view, allowing engineers to monitor and analyze data in one place. * Reports (WIP): Create detailed reports to share insights and findings with your team or stakeholders. Getting Started Installation Quary is a VSCode Extension (Interface) & Rust-based CLI (Core) Extension The VSCode extension can be installed here. Note that it depends on the CLI being installed. CLI Homebrew installation brew install quarylabs/quary/quary Linux/Mac through curl Quary can be installed using curl on Linux/Mac using the following command: curl -fsSL https://raw.githubusercontent.com/quarylabs/quary/main/install.sh | bash Other installations Other builds are available in the releases page to download. Usage Once installed, a sample project can be created and run as follows: mkdir example # create an empty project folder cd example quary init # initialize DuckDB demo project with sample data quary compile # validate the project structure and model references without database quary build # build and execute the model views/seeds against target database quary test -s # run defined tests against target database Community Join our Slack channel, for help, ideas, and discussions. Support If you run into any problems using Quary, please let us know. We want Quary to be easy-to-use, so if you are getting confused, it is our fault, not yours. Create an issue and we'll be happy to help you out. Check out our other projects SQRUFF, a compact, high-speed SQL linter, engineered with Rust efficiency. About Open-source BI for engineers www.quary.dev Topics big-data analytics business-intelligence elt data-modeling Resources Readme License Apache-2.0 license Activity Custom properties Stars 830 stars Watchers 8 watching Forks 11 forks Report repository Releases 35 v0.1.0 Latest May 15, 2024 + 34 releases Packages 0 No packages published Contributors 5 * @benfdking * @louisjoecodes * @dependabot[bot] * @actions-user * @zsombor-flds Languages * Rust 49.8% * TypeScript 47.7% * CSS 1.5% * JavaScript 0.5% * Shell 0.3% * Makefile 0.1% * Other 0.1% Footer (c) 2024 GitHub, Inc. Footer navigation * Terms * Privacy * Security * Status * Docs * Contact * Manage cookies * Do not share my personal information You can't perform that action at this time.