https://github.com/pretzelai/pretzelai Skip to content 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 }} pretzelai / pretzelai Public * Notifications * Fork 6 * Star 262 * Open-source, browser-local data exploration using DuckDB-Wasm and PRQL pretzelai.github.io License Apache-2.0 license 262 stars 6 forks Branches Tags Activity Star Notifications * Code * Issues 7 * Pull requests 1 * Actions * Projects 0 * Security * Insights Additional navigation options * Code * Issues * Pull requests * Actions * Projects * Security * Insights pretzelai/pretzelai 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 20 Commits cloud cloud public public src src .gitignore .gitignore .prettierrc .prettierrc LICENSE LICENSE README.md README.md components.json components.json craco.config.js craco.config.js package-lock.json package-lock.json package.json package.json tailwind.config.js tailwind.config.js tsconfig.json tsconfig.json View all files Repository files navigation * README * Apache-2.0 license Pretzel License GitHub Stars Live deployed build: https://pretzelai.github.io Pretzel is an open-source, offline browser-based tool for fast and intuitive data exploration and visualization. It can handle large data files, runs locally in your browser, and requires no backend setup. Pretzel makes it easy to manipulate data via visual chained data transform blocks. It's also reactive - chaging an tranform block in the chain automatically updates all transform blocks and charts that follow. demo.gif Features * Blazing-fast performance with WebAssembly-based DuckDB and PRQL * Intuitive data exploration with a visual, top-down pipeline of data transformations and visualizations * AI-powered transformation block to help with fast data manipulation * Privacy-first design: run Pretzel AI locally or host it yourself for full control over your data * Upcoming features: Local LLM support, API calls, in-browser Python support with Pyodide, save and share workflows securely and canvas based table rendering Table of Contents * Demo video * Getting started + Website (Easiest) + Offline standalone app + Developers o Run locally o Host Pretzel * Optional Configuration * Implemented Transformation Blocks * Known Bugs * Contact Demo video Pretzel.mp4 Getting Started Website (Easiest) The easiest way to use Pretzel is to visit https:// pretzelai.github.io Offline standalone app Since Pretzel doesn't have a backend you can easily install it as a Chrome app and it will work even without internet (for those long flights!) 1. Visit https://pretzelai.github.io in Chrome 2. Click the install app icon pretzel_chrome_install 3. Now you can launch Pretzel as a standalone app. It will also work offline, it may error if you try to use some internet feature (like the AI Block), just close it and open it again to fix it pretzel_app_icon Developers Run locally To run Pretzel locally, follow these steps: 1. Clone the repository: git clone https://github.com/pretzelai/pretzelai.git 2. Install dependencies: cd pretzelai npm install 3. Start the development server: npm run start 4. Open your browser and navigate to http://localhost:3000 Host Pretzel To host Pretzel, follow these steps (it's just a static website!): 1. Build the app npm run build 2. Upload the contents of the build folder to your hosting. This is what you can find live at https://pretzelai.github.io Optional configuration * Bug report box: Update /src/lib/config.ts with your PostHog config to let users report bugs directly on the website * AI Endpoint: Deploy a cloud function to provide an AI endpoint for users without an OpenAI API key. Check the cloud folder for instructions. Implemented transformation blocks * Upload: accepts CSV / Excel (XLSX) files * Filter: string/number/date filtering including nested filters * Ask AI: connects to OpenAI to transform user command to SQL * Pivot: to create a pivot table (you can also go group-by using this - only use the Rows and Values fields) * Sort: sorts ascending or descending on multiple columns * Chart: supports line (including multi-line) charts, bar charts (grouped and stacked) and scatter plot * Create column: make a new column with basic math or use PRQL functions * Remove columns: easily add/remove columns with visual toggles * Table: add a table in the middle of your workflow to visualize data in a intermediate step * Download: export your transformed data in CSV Known Bugs * Dates are sometimes parsed incorrectly - existing GH issue here * Table panel is slow for large datasets. We're planning on moving to a canvas based table * [Rare] Charts axes can sometimes not be ordered correctly Please report any bugs you find in GitHub issues. Contact You can email us at founders [at] withpretzel [dot] com. We also read all the feedback and bugs you report at the top left of https://pretzelai.github.io About Open-source, browser-local data exploration using DuckDB-Wasm and PRQL pretzelai.github.io Topics open-source wasm duckdb prql Resources Readme License Apache-2.0 license Activity Stars 262 stars Watchers 1 watching Forks 6 forks Report repository Contributors 2 * @ramonverse ramonverse Ramon Garate * @prasoon2211 prasoon2211 Prasoon Shukla Languages * TypeScript 92.3% * JavaScript 5.5% * CSS 1.1% * HTML 1.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.