A 20 MB DBX Client That Fully Handles Easysearch and Elasticsearch

Why written

Existing Elasticsearch tools are either large (hundreds of MB, slow startup) or lack native Easysearch support, forcing users to switch to Kibana or curl for simple queries.

Installation

The Windows installer is a standard Nullsoft package. Selecting a directory and proceeding through the wizard installs the client in under 60 MB of disk space.

Creating an Easysearch connection

In the client click New Connection . In the left‑hand category list choose Document/Cache/Search , then select Easysearch . Fill the fields:

Host + Port : Easysearch node address, default 9200.

Username/Password : Use the admin account when security is enabled.

URL parameters : e.g. sslmode=prefer for HTTPS without extra configuration.

Alternatively paste a full URL such as https://user:password@host:port to auto‑populate the fields.

Index view after connection

Successful connection lists all Easysearch indices in the left pane. Clicking an index opens a table view where each document is a row and each field a column. Field types (keyword, text, double, date) appear beneath column headers. A JSON view button shows the raw document structure.

Query method 1: SQL

The built‑in SQL editor uses Easysearch’s SQL plugin. Example queries:

select * from bank_transactions as bt;

select * from bank_transactions as bt where 客户姓名 = '韩泽';

Results are displayed in the same table component with pagination, column sorting, and export options.

Query method 2: native DSL

For complex bool logic or multiple clauses, write Elasticsearch DSL directly. Example request body:

POST /bank_transactions/_search
{
  "query": {
    "match": {
      "客户姓名": "杨军"
    }
  }
}

The table rendering and field metadata are shared with the SQL view, so switching between SQL and DSL does not affect the user experience.

Query method 3: visual filter

The graphical Filter panel lets users add conditions without writing code. Example conditions: 交易地点 (keyword) = 北京 交易对手姓名 (keyword) wildcard = 李

Filters are combined with AND logic; clicking Apply Filter translates the UI selections into DSL behind the scenes.

Summary

For routine Easysearch/Elasticsearch tasks—data lookup, index verification, and issue diagnosis—the client provides a three‑layer solution:

Connection layer : graphical configuration with support for authentication, SSL, and one‑click URL import.

Query layer : SQL, DSL, and visual filter coexist, allowing users to choose the most suitable method.

Display layer : combined table and JSON views with visible field types.

Package size (~20 MB) and fast startup eliminate the need for heavyweight tools. Download URL: https://dbxio.com/cn