Repolode
Submit
agnosticeng

agnosticeng/agx

A desktop and web app for exploring and querying data with SQL, ClickHouse-backed, with optional LLM assistance.

Open-source alternative to:DBeaver

View on GitHubWebsite
Stars
261
Forks
17
Open issues
5
Last commit
7 months ago

What is it?

agx is a data exploration tool that lets you write and run SQL queries against data through a modern interface. It is built with Tauri, SvelteKit and Observable Plot, and can run as a native desktop application backed by ClickHouse, or as a web interface connected to a remote server instance.

The app includes an interactive SQL editor with syntax highlighting, a schema browser for inspecting table structure, and a tabular results view. Drag-and-drop file handling is supported, and the project lists macOS, Linux and Windows as supported platforms.

It offers an Ollama integration for using local models, and can be started locally with Docker Compose. An optional install script adds Agnostic ClickHouse UDFs for extra functions.

Key features

  • 01Interactive SQL editor with syntax highlighting
  • 02Schema browser for exploring table structure
  • 03Tabular query results view
  • 04Drag-and-drop file operations
  • 05Ollama integration for local LLM models
  • 06Runs on macOS, Linux and Windows

Use cases

  • Querying ClickHouse datasets without writing a custom front end
  • Exploring unfamiliar database schemas before writing queries
  • Running local LLM-assisted analysis with Ollama
  • Self-hosting a shared SQL analytics interface with Docker

Quick start

  1. 1

    Clone the repository

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

    Run with Docker Compose

    docker compose up
  3. 3

    Open the application in your browser at localhost port 8080

Things to know

  • The native desktop app is built with Tauri and requires a Rust toolchain and system dependencies to build from source.
  • Ollama integration with the live site requires running Ollama with a specific OLLAMA_ORIGINS setting.

Topics

#sql#clickhouse#data-exploration#svelte#tauri#desktop-app#ollama#data-visualization#ai#business-intelligence

FAQ

What is agx?
A desktop and web app for exploring and querying data with SQL, ClickHouse-backed, with optional LLM assistance. agx is a data exploration tool that lets you write and run SQL queries against data through a modern interface. It is built with Tauri, SvelteKit and Observable Plot, and can run as a native desktop application backed by ClickHouse, or as a web interface connected to a remote server instance.
Is agx free to use? What license does it have?
agx is open source under the MIT license. Check the license terms before using it in commercial products.
Is agx still maintained?
No commits for 6+ months. The last commit to agx was on Mar 10, 2026.
What can I use agx for?
Querying ClickHouse datasets without writing a custom front end Exploring unfamiliar database schemas before writing queries Running local LLM-assisted analysis with Ollama Self-hosting a shared SQL analytics interface with Docker
How do I install agx?
Clone the repository: git clone https://github.com/agnosticeng/agx && cd agx Run with Docker Compose: docker compose up Open the application in your browser at localhost port 8080
Where can I get agx?
The source code and installation instructions are on GitHub: https://github.com/agnosticeng/agx

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects