# Elasticsearch SQL CLI usage

**URL:** <https://discuss.elastic.co/t/elasticsearch-sql-cli-usage/185180>\
**Category:** Elasticsearch\
**Tags:** elastic-stack-sql\
**Created:** [June 11, 2019, 12:00pm UTC](https://discuss.elastic.co/t/elasticsearch-sql-cli-usage/185180 "2019-06-11T12:00:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![birko](https://avatars.discourse-cdn.com/v4/letter/b/dbc845/32.png) [@birko](https://discuss.elastic.co/u/birko)\
**Post date:** [June 11, 2019, 12:00pm UTC](https://discuss.elastic.co/t/elasticsearch-sql-cli-usage/185180/1 "2019-06-11T12:00:45Z")

</div>

Is it possible to use standalone Elasticsearch SQL CLI in windows environment?  
We are running Elasticsearch 6.8 cluster on Debian servers, but SQL CLI would be nice to use in windows because of additional connection to existing reporting infranstructure.

Thanks

---

<div class="post-metadata">

**Author:** ![Andrei\_Stefan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrei_stefan/32/47533_2.png) [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)\
**Post date:** [June 13, 2019, 8:22am UTC](https://discuss.elastic.co/t/elasticsearch-sql-cli-usage/185180/2 "2019-06-13T08:22:07Z")

</div>

Hi @birko,  
The CLI should work in Windows environment. Have you tried using it and encountered issues?

---

<div class="post-metadata">

**Author:** ![birko](https://avatars.discourse-cdn.com/v4/letter/b/dbc845/32.png) [@birko](https://discuss.elastic.co/u/birko)\
**Post date:** [June 17, 2019, 7:58am UTC](https://discuss.elastic.co/t/elasticsearch-sql-cli-usage/185180/3 "2019-06-17T07:58:10Z")

</div>

Hello @Andrei_Stefan,  
I haven't tried it, because I didn't find standalone Elasticsearch SQL CLI for download. Should I download Elasticsearch windows distributiion and extract from it necessary libraries and executables for SQL CLI? If yes, is it available list of these necessary files?

Thanks

---

<div class="post-metadata">

**Author:** ![Andrei\_Stefan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrei_stefan/32/47533_2.png) [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)\
**Post date:** [June 17, 2019, 5:01pm UTC](https://discuss.elastic.co/t/elasticsearch-sql-cli-usage/185180/4 "2019-06-17T17:01:09Z")

</div>

@birko you should be able to download ES for Windows and extract elasticsearch-sql-cli-[ES\_VERSION].jar from `/bin` and then run something like `java -cp "elasticsearch-sql-cli-8.0.0-SNAPSHOT.jar" org.elasticsearch.xpack.sql.cli.Cli`.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 16, 2019, 1:58pm UTC](https://discuss.elastic.co/t/elasticsearch-sql-cli-usage/185180/6 "2019-07-16T13:58:03Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.