Joinery

Privacy-first local data analytics powered by DuckDB. Run SQL queries on your files instantly in your browser or desktop app with an intuitive interface.

Try the web version

✨ Features

• 🦆 DuckDB-Powered Analytics: Full-featured SQL engine running in WebAssembly (web) or native Rust client (desktop).
• 🔒 Privacy-First Architecture: All data processing happens locally on your device. Zero cloud uploads.
• 📁 Multi-Format Support: Import and query CSV, Excel, JSON, Parquet, and more.
• 🎨 Modern SQL Editor: Monaco-based editor with syntax highlighting, IntelliSense, and auto-completion.
• 📑 Tabbed & Concurrent Workflow: Open multiple tabs and run multiple queries per tab. Desktop edition supports true concurrent query execution.
• ⚡ Fast Query Execution: Leverages DuckDB's columnar engine and Apache Arrow for performance.
• 📊 Rich Results Interface: Paginated, sortable, and filterable result tables with save and export options.
• 🔄 Parameterized Saved Queries: Save and reuse queries with {{variable}} placeholders for repeatable workflows.
• 🗄️ Multi-Database Management: Create, import, export, and switch between multiple databases.
• 💾 Persistent Storage: Auto-saves databases to browser storage (web) or local filesystem (desktop).
• 🚀 Quick Actions: Options to quickly copy database schemas, export table data, rename tables, change table schemas, and more.
• 🌙 Dark Mode: Polished light and dark themes.

🎯 Why Joinery?

SQL excels at data transformations with transparent, modifiable code. For tasks like pivoting, unpivoting, complex filtering, and sophisticated aggregations, SQL, especially DuckDB, provides built-in functions that are faster to write, easier to modify, and more reproducible than clicking through menus. When you ask AI for help with a spreadsheet task, you get step-by-step instructions to click through dialogs. When you ask for a SQL query, you get code you can instantly modify and rerun.

Modern AI has made SQL accessible to everyone. Copy your database schema from Joinery, describe what you need in plain English to LLMs like Gemini, Claude, or ChatGPT, and get working queries back. SQL's readable syntax makes validation straightforward. You can see exactly what's happening to your data. LLMs can understand what data they're dealing with from the schema and sample data, making the process smoother.

Build reusable workflows. Save queries with {{parameters}} for processes you run repeatedly. Need to run the same analysis on new data each week? Use the runtime parameters to update the query and execute. Chain multiple queries together for complex workflows that run end-to-end with one click.

Everything runs locally on your device. Use it in your browser with no installation, or download the desktop app for native performance. Your data never leaves your machine. DuckDB delivers impressive performance for analytical queries, and Joinery is completely free and open-source.

🚀 Quick Start

🌐 Web Version

Run Joinery in your browser:

# Clone the repository
git clone https://github.com/joinery-labs/joinery.git
cd joinery

# Install dependencies
npm install

# Start development server
npm run dev

Open http://localhost:5173 in your browser.

Build for production:

npm run build

💻 Desktop App (Tauri)

Get the native desktop experience with better performance.

Prerequisites: Ensure you have Rust and platform-specific dependencies installed. See the Tauri Prerequisites Guide.

# Install dependencies
npm install

# Run in development mode
npm run tauri dev

# Build distributable application
npm run tauri build

The built application will be in src-tauri/target/release/.

📁 Project Structure

joinery/
├── src/
│   ├── css/
│   │   ├── base/               # Theme variables, typography, utilities
│   │   ├── components/         # Reusable UI components (buttons, modals, etc.)
│   │   ├── features/           # Feature-specific styling
│   │   └── layout/             # Layout structures (toolbar, masonry, etc.)
│   ├── js/
│   │   ├── core/               # Database engine, event bus, backends
│   │   ├── editor/             # Monaco editor integration
│   │   ├── features/           # Main application features
│   │   │   ├── export-import/
│   │   │   ├── file-upload/
│   │   │   ├── query-editor/
│   │   │   ├── results/
│   │   │   └── table-manager/
│   │   ├── platform/           # Web vs. Tauri platform abstraction
│   │   │   ├── backends/
│   │   ├── ui/                 # UI components
│   │   └── utils/              # Helper functions and utilities
│   └── index.html
├── src-tauri/                  # Desktop application
│   ├── src/                    # Rust application code
│   ├── capabilities/           # Tauri capabilities configuration
│   └── tauri.conf.json         # Tauri configuration
├── README.md
├── CONTRIBUTING.md
├── LICENSE
├── package.json
└── vite.config.js

🤝 Contributing

We welcome contributions! Whether you're fixing bugs, adding features, or improving documentation, your help makes Joinery better.

Before contributing:

• Read our Contributing Guide.
• Check existing Issues.
• For major changes, please open an issue or a discussion for prior review.

🗺️ Roadmap

The following major features are planned. Minor improvements and bug fixes will continue on an ongoing basis.

• Multi-window support: Pop out tabs into separate windows for flexible layouts.
• Declarative charting: Create visualizations through simple, declarative configuration.

🙏 Acknowledgments

• DuckDB WASM and DuckDB Rust for SQL database.
• Bootstrap for UI components and styling.
• Tauri for desktop framework.
• Monaco Editor for code editor.
• Apache Arrow for columnar data format.
• SheetJS for Excel file processing.
• Sql-formatter for SQL formatting.
• Day.js for date manipulation.
• JSZip for ZIP file handling.
• Inter Font for UI typography.

🆘 Support

• 🐛 Bug Reports: GitHub Issues
• 💡 Feature Requests: GitHub Discussions