Connect DBeaver to Elasticsearch. Yes, Really.

1. Analyst writes requirements in a Jira ticket
2. Developer translates requirements into Elasticsearch JSON DSL
3. Developer runs query, exports results to CSV
4. Analyst opens CSV in Excel
5. Analyst realizes they need a different grouping
6. Go back to step 1

Average turnaround: 2-3 days per query.

JDBC URL:     jdbc:elastic://localhost:9200
Driver class: app.softnetwork.elastic.jdbc.ElasticDriver

SELECT
  customer_segment,
  COUNT(*) as order_count,
  SUM(amount) as total_revenue,
  AVG(amount) as avg_order_value
FROM orders
WHERE status = 'completed'
  AND created_at >= '2025-01-01'
GROUP BY customer_segment
ORDER BY total_revenue DESC;

jdbc:elastic://host:port?param=value&param2=value2

# Basic auth
jdbc:elastic://es-prod:9200?user=admin&password=secret
# API key
jdbc:elastic://es-prod:9200?apiKey=mykey123
# Bearer token + SSL
jdbc:elastic://es-prod:9200?ssl=true&bearerToken=my-token
# Custom timeouts
jdbc:elastic://es-prod:9200?connectionTimeout=10s&socketTimeout=120s

CREATE TABLE products (
  id KEYWORD NOT NULL,
  name VARCHAR,
  price DOUBLE DEFAULT 0.0,
  PRIMARY KEY (id)
);
ALTER TABLE products ADD COLUMN IF NOT EXISTS stock INT;
DESCRIBE TABLE products;
SHOW TABLES LIKE 'product%';
SHOW CREATE TABLE products;

INSERT INTO products (id, name, price)
VALUES ('p1', 'Laptop', 999.99);
UPDATE products SET price = 899.99 WHERE id = 'p1';
DELETE FROM products WHERE stock = 0;
COPY INTO products FROM '/data/catalog.jsonl';

SELECT name, price
FROM products
WHERE price > 100
ORDER BY price DESC
LIMIT 50;

SELECT category, COUNT(*) as product_count, AVG(price) as avg_price
FROM products
GROUP BY category
HAVING COUNT(*) > 5;

-- Automatic refresh (requires ES license)
CREATE MATERIALIZED VIEW orders_with_customers_mv
REFRESH EVERY 8 SECONDS
WITH (delay = '1s', user_latency = '1s')
AS
SELECT o.id, o.amount, c.name AS customer_name
FROM orders AS o
JOIN customers AS c ON o.customer_id = c.id;

-- Without ES license: schedule this yourself (cron, Airflow, etc.)
REFRESH MATERIALIZED VIEW orders_with_customers_mv;
SELECT * FROM orders_with_customers_mv
WHERE customer_name = 'Alice';

<!-- Maven -->
<dependency>
  <groupId>app.softnetwork.elastic</groupId>
  <artifactId>softclient4es8-jdbc-driver</artifactId>
  <version>0.3.0</version>
</dependency>

// Gradle
implementation 'app.softnetwork.elastic:softclient4es8-jdbc-driver:0.3.0'

// sbt
resolvers += "Softnetwork" at "https://softnetwork.jfrog.io/artifactory/releases/"
libraryDependencies += "app.softnetwork.elastic" % "softclient4es8-jdbc-driver" % "0.3.0"

import java.sql.*;
// Connection (driver auto-registers via SPI)
Connection conn = DriverManager.getConnection(
    "jdbc:elastic://localhost:9200"
);
// Query
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(
    "SELECT name, price FROM products WHERE price > 100 ORDER BY price DESC"
);
while (rs.next()) {
    System.out.println(rs.getString("name") + " - $" + rs.getDouble("price"));
}
// DML
int count = stmt.executeUpdate(
    "INSERT INTO products (id, name, price) VALUES ('p42', 'Widget', 19.99)"
);
System.out.println("Inserted: " + count);
// PreparedStatement
PreparedStatement pstmt = conn.prepareStatement(
    "SELECT * FROM products WHERE category = ? AND price > ?"
);
pstmt.setString(1, "Electronics");
pstmt.setDouble(2, 50.0);
ResultSet rs2 = pstmt.executeQuery();
// Cleanup
rs.close();
stmt.close();
conn.close();

DriverManager.getConnection("jdbc:elastic://localhost:9200").use { conn ->
    conn.createStatement().use { stmt ->
        val rs = stmt.executeQuery("SELECT name, price FROM products ORDER BY price DESC LIMIT 10")
        while (rs.next()) {
            println("${rs.getString("name")} — $${rs.getDouble("price")}")
        }
    }
}

┌──────────────┐     JDBC       ┌──────────────────────┐     REST API     ┌───────────────┐
│   DBeaver    │ ────────────── │  SoftClient4ES       │ ──────────────── │ Elasticsearch │
│   Tableau    │   SQL over     │  JDBC Driver         │   Optimized DSL  │   6/7/8/9     │
│   DataGrip   │   JDBC         │  (fat JAR, no deps)  │                  │               │
│   Your App   │                │                      │                  │               │
└──────────────┘                └──────────────────────┘                  └───────────────┘