qax-os/elastichd

ElasticHD is a visual management dashboard for Elasticsearch, a database system commonly used to store and search large amounts of text data. Instead of interacting with Elasticsearch through command-line tools or writing raw queries by hand, ElasticHD gives you a web interface that runs in any browser, with no additional software required beyond the single downloaded executable. The dashboard covers the common day-to-day tasks for managing an Elasticsearch setup. You can view live data, run searches, inspect and manage indices (which are like tables in a traditional database), and edit type mappings that control how data fields are stored. The interface adjusts to any screen size, so it can be used on desktops, tablets, or phones. One of the more distinctive features is a SQL-to-DSL converter. Elasticsearch uses its own query language called DSL (Domain Specific Language) that looks quite different from standard SQL. ElasticHD lets you write familiar SQL statements, such as SELECT, WHERE, GROUP BY, ORDER BY, and aggregation functions like COUNT, AVG, MIN, and MAX, and it translates them automatically into the equivalent Elasticsearch DSL. It also supports Elasticsearch-specific query types like date histograms, range grouping, and top-hits that go beyond what standard SQL covers. Setting it up is straightforward: download the pre-compiled binary for your operating system, run it from the command line with a port number, and open the resulting address in a browser. A Docker image is also available for containerized environments. If your Elasticsearch server requires a username and password, you include those directly in the connection URL. The project is licensed under the MIT License. Compatible with all versions of Elasticsearch.