Use cases
SQL for Elasticsearch and OpenSearch, by use case
One page per job, each with the SQL, the DSL it becomes, and the way you would do it without FlatQL.
Elasticsearch GROUP BY in SQL, run as a composite aggregation
Elasticsearch GROUP BY in SQL with FlatQL. Keys become a composite aggregation the cluster runs, after_key paging is automatic, HAVING runs in the engine.
An Elasticsearch GUI built around SQL
Elasticsearch GUI for engineers: browse indices and mappings, query with SQL or Query DSL, chart and export results, share a cluster without sharing passwords.
Elasticsearch index level access for a team, without cluster users
Elasticsearch index level access in FlatQL. Grant read or write per index pattern per member, share a connection without sharing credentials, keep an audit log.
Elasticsearch query log with user, duration and the DSL that ran
An Elasticsearch query log kept by FlatQL. Each statement with user, connection, duration, rows and the Query DSL it sent, grouped by shape, plus usage by user.
Elasticsearch SQL join across indices
Elasticsearch SQL join, explained: why the cluster has no server-side join, how FlatQL joins two indices in plain SQL, the DSL each side gets, and the limits.
Elasticsearch SQL limitations, and what to do about each
Elasticsearch SQL limitations from the official docs: one table per FROM, limited sub-selects, no array fields, one nested field, and how FlatQL covers each.
Elasticsearch window functions with SQL
Elasticsearch window functions in plain SQL: ROW_NUMBER, RANK and LAG with QUALIFY over an index, what the cluster ran, and what you would build without them.
Export Elasticsearch to CSV, millions of rows at a time
Export Elasticsearch to CSV from a SQL statement: up to 5,000,000 rows streamed to disk, filters pushed to the cluster, columns you choose, plus TSV and JSON.
Import CSV to Elasticsearch without writing a script
Import CSV to Elasticsearch or OpenSearch from the browser. FlatQL reads CSV, Excel, JSON, NDJSON or a JSON API, previews the mapping, bulk-loads a new index.
OpenSearch GUI with full SQL
OpenSearch GUI for OpenSearch 1 and 2 and Amazon OpenSearch Service: full SQL with joins and windows, the OpenSearch SQL plugin one switch away, logs-* example.
Query Elasticsearch with SQL, joins and GROUP BY included
Query Elasticsearch with SQL in FlatQL. Filters, sorts and GROUP BY become Query DSL on the cluster; joins, CTEs and window functions run in an embedded engine.
AI Elasticsearch query assistant that knows your mappings
AI Elasticsearch query writing with Ask FlatQL. Describe the question, get SQL or Query DSL built from your live mappings and a sample document, then run it.
Start on Free. It stays free.
Connect a cluster and run a join in five minutes. No card, no expiry.