Skip to content

Paid plans add features and fund TablePro’s development. Optional paid plans See plans

TablePro
Download
TablePro

Elasticsearch client

Run Query DSL requests from a console, browse index documents in a grid and edit them by their IDs.

DownloadElasticsearch setup guide

At a glance

Query language
Query DSL
Driver
Downloads on first use
Connect with
Host and port, SSH tunnel, SSL/TLS
Default port
9200
Minimum version
7.x
TablePro on a Mac connected to Elasticsearch, with a search request and its hits as rows.

Connect

Enter the REST host and port, then choose an Auth Method: Username & Password, API Key or None. API keys use the encoded value from Elasticsearch, and each connection reaches one cluster.

New connections start with SSL Disabled, which is plain HTTP; every other mode uses HTTPS. Preferred and Required (skip verify) accept a self-signed certificate, and Verify CA and Verify Identity check it. Elasticsearch 8.x turns security and TLS on by default, so an 8.x cluster usually needs HTTPS and credentials.

Indices and the Query DSL console

Write a method, path and optional JSON body, such as GET /orders/_search. Search hits and array responses display as rows, other responses as formatted JSON, and the _sql endpoint is not available.

The sidebar lists indices as tables and hides names that begin with a dot. Columns come from the mapping: object fields flatten to dotted paths such as address.city, a nested field gets one JSON column for its array plus a column per leaf, and every document carries _id, _index and _score.

Column filters become term, range, wildcard, terms and exists queries, and the Raw SQL filter row takes Lucene syntax, such as name:Widget. Edits go out as REST calls by _id; change a nested array through its JSON column.

TablePro also connects to Typesense and Weaviate, the other search engines.

Mappings

Mappings are read-only. Truncate is not offered, because the nearest thing Elasticsearch has, _delete_by_query, runs asynchronously and reports conflicts per document; send it from the console. Deleting an index from the sidebar sends the DELETE request its confirmation shows.

This page covers what is specific to Elasticsearch. Safe Mode, the AI assistant, the MCP server and the rest of TablePro are on the feature pages.

Also

  • Move data

    Export reads a whole index with a point-in-time and search_after, so it is not capped at the result window, and writes CSV, JSON, SQL, XLSX, Markdown, HTML and XML.

  • Limits

    • OpenSearch is not supported.
    • Aliases and data streams are not listed in the sidebar. Address them by name in the console.

  • Can I page past the result window?

    Yes. Paging past Elasticsearch’s default window switches to search_after over a point-in-time. The switch happens at the default, so an index with a lowered max_result_window errors first; raise the setting back to the default.

  • Why does sorting by _id leave the rows in the same order?

    Elasticsearch cannot sort on _id, or on a text field with no .keyword subfield, so TablePro drops that column from the sort. Add a keyword subfield to the mapping, or sort on a keyword field.

Get TablePro

Everything on this page is free.

DownloadSee pricing