agnosticeng/agx: Query and explore local and remote data with Clickhouse

agx is a desktop application built with Tauri and SvelteKit that provides a modern interface for exploring and querying data using ClickHouse’s embedded database engine (chdb).

• Native desktop application performance with web technologies
• Interactive SQL query editor with syntax highlighting
• Schema browser for exploring data structure
• Results displayed in a tabular format
• Support for drag & drop file operations
• Cross-platform compatibility (macOS, Linux, Windows)

• Node.js (v16 or later)
• Rust toolchain
• System dependencies for Tauri

https://agx.app

1. Clone the repository:

git clone https://github.com/agnosticeng/agx
cd agx

2. Run with docker compose:

3. Access the application via http://localhost:8080

1. Clone the repository:

git clone https://github.com/agnosticeng/agx
cd agx

2. Download and setup chdb library:

./src-tauri/update_libchdb.sh

3. Install dependencies:

4. Run in development mode:

5. Build for production:

agx/
├── src/                 # Frontend source code (SvelteKit)
│   ├── lib/             # Shared components
│   └── routes/          # Application routes
├── src-tauri/           # Backend source code (Rust)
│   ├── src/             # Rust source files
│   └── Cargo.toml       # Rust dependencies
├── package.json         # Node.js dependencies
└── README.md

Install Agnostic ClickHouse UDFs with a single command:

curl -fsSL https://raw.githubusercontent.com/agnosticeng/agx/main/scripts/install_agnostic_udfs.sh | sh

• The frontend is built with SvelteKit, offering a reactive and efficient UI
• The backend uses Tauri with Rust, providing native performance and security
• Communication between frontend and backend happens through Tauri’s IPC bridge
• Data querying is handled by chdb, an embedded ClickHouse engine

Contributions are welcome! Please feel free to submit a Pull Request.

This project is licensed under the MIT License – see the LICENSE file for details.

The MIT License is one of the most popular open-source licenses because it:

• Is simple and permissive
• Allows commercial use
• Allows modification and distribution
• Allows private use
• Has minimal restrictions
• Is compatible with many other licenses

Keep your files stored safely and securely with the SanDisk 2TB Extreme Portable SSD. With over 69,505 ratings and an impressive 4.6 out of 5 stars, this product has been purchased over 8K+ times in the past month. At only $129.99, this Amazon’s Choice product is a must-have for secure file storage.

Help keep private content private with the included password protection featuring 256-bit AES hardware encryption. Order now for just $129.99 on Amazon!

Help Power Techcratic’s Future – Scan To Support

If Techcratic’s content and insights have helped you, consider giving back by supporting the platform with crypto. Every contribution makes a difference, whether it’s for high-quality content, server maintenance, or future updates. Techcratic is constantly evolving, and your support helps drive that progress.

As a solo operator who wears all the hats, creating content, managing the tech, and running the site, your support allows me to stay focused on delivering valuable resources. Your support keeps everything running smoothly and enables me to continue creating the content you love. I’m deeply grateful for your support, it truly means the world to me! Thank you!