| Name | cqlsh JSON |
| Version |
6.2.1
JSON |
| download |
| home_page | None |
| Summary | cqlsh is a Python-based command-line client for running CQL commands on a cassandra cluster. |
| upload_time | 2025-08-13 18:48:59 |
| maintainer | None |
| docs_url | None |
| author | Brad Schoening |
| requires_python | >=3.9 |
| license | None |
| keywords |
cql
cassandra
cqlsh
|
| VCS |
 |
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
[](https://badge.fury.io/py/cqlsh)
[](https://pepy.tech/project/cqlsh)
[](https://opensource.org/licenses/Apache-2.0)
# `cqlsh`
`cqlsh` is a Python-based command-line client for running `CQL` commands on a `cassandra` cluster.
Normally it's packaged as part of the full Apache Cassandra™ installation. This repo repackages it into a standalone Python package for lighter-weight installs.
### Installing:
Install and update using [`pip`](https://pip.pypa.io/en/stable/quickstart/):
```
$ pip install -U cqlsh
```
### Running:
```
$ cqlsh --help
```
### Documentation:
Documentation is available as part of the official [Apache Cassandra™ documentation](https://cassandra.apache.org/doc/latest/cassandra/managing/tools/cqlsh.html).
### Contributing:
Because this is a repackaging of `cqlsh` from the official [Cassandra repo](https://gitbox.apache.org/repos/asf/cassandra.git), **only issues / PRs related to PyPI packaging should be opened against this repo**. If you would like to contribute to `cqlsh` itself, [find out more information here](https://github.com/apache/cassandra/blob/trunk/CONTRIBUTING.md).
Steps to sanity check that the packaging works as expected:
1. Install `cqlsh` locally (probably in a `virtualenv`):
```
$ pip install -e . # run from within the cqlsh directory
```
or build and install it
```
$ python -m build
$ python -m pip install dist/*.whl
```
2. Start a local copy of Cassandra:
```
$ docker pull cassandra
$ docker run -it --rm -p 9042:9042 cassandra
```
3. Verify `cqlsh` successfully connects to the server:
```
$ cqlsh
Connected to Test Cluster at 127.0.0.1:9042
[cqlsh 6.1.0 | Cassandra 4.1.0 | CQL spec 3.4.5 | Native protocol v5]
Use HELP for help.
cqlsh>
```
This PyPI package is maintained by [Jeff Widman](https://github.com/jeffwidman) and [Brad Schoening](https://github.com/bschoening). Previous maintainers: [Spiro](https://github.com/spiside) and [Andrew Mussey](https://github.com/amussey).
### Changelog:
Unfortunately the Cassandra project does not always increment the `cqlsh` version number, so for every
release we need to document not only the `cqlsh` version but also the `cassandra` version in which it
shipped.
#### 6.2.1 (August 6, 2025)
This packages `cqlsh` `6.2.0` from [Cassandra 5.0.5](https://github.com/apache/cassandra/blob/cassandra-5.0.5/pylib/cqlshlib):
* Avoid CQLSH throwing an exception loading .cqlshrc on non-supported platforms (CASSANDRA-20478)
* Fix text containing "/*" being interpreted as multiline comment in cqlsh (CASSANDRA-17667)
* Fix autocompletion for role names/user names (CASSANDRA-20175)
#### 6.2.0 (September 16, 2024)
This packages `cqlsh` `6.2.0` from [Cassandra 5.0.0](https://github.com/apache/cassandra/blob/cassandra-5.0.0/pylib/cqlshlib):
* Add HISTORY command for CQLSH (CASSANDRA-15046)
* Add CQLSH command SHOW REPLICAS (CASSANDRA-17577)
* Cassandra 5.0 has refactored all cqlsh logic to be in cqlshlib, with the new cqlshmain.py replacing behavior formerly in bin/cqlsh.py
* Replace 'wcwidth.py' with pypi module (CASSANDRA-17287)
#### 6.1.3 (Feburary 23, 2023)
This packages `cqlsh` `6.1.0` from [Cassandra 4.1.4](https://github.com/apache/cassandra/blob/cassandra-4.1.4/bin/cqlsh.py):
* CQLSH emits a warning when the server version doesn't match (CASSANDRA-18745)
* Fix CQLSH online help topic link (CASSANDRA-17534)
#### 6.1.2 (March 24, 2023)
This packages `cqlsh` `6.1.0` from [Cassandra 4.1.1](https://github.com/apache/cassandra/blob/cassandra-4.1.1/bin/cqlsh.py):
* Now supports Python 3.11.
* Although this is pulled from a Cassandra `4.x` release, it is protocol compatible with Cassandra `3.x` clusters, with the exception of `DESCRIBE` keywords which require a 4.x cluster.
#### 6.1.1 (skipped due to a versioning issue)
#### 6.1.0 (Jan 4, 2023)
This packages `cqlsh` `6.1.0` from [Cassandra 4.1](https://github.com/apache/cassandra/blob/cassandra-4.1.0/bin/cqlsh.py):
* Requires Python 3.6+.
* Although this is pulled from a Cassandra `4.x` release, it is protocol compatible with Cassandra `3.x` clusters, with the exception of `DESCRIBE` keywords which require a 4.x cluster.
#### 6.0.1 (Jan 18, 2022)
The actual source code is identical to the `cqlsh` `6.0.0` release, except it's now packaged as
a module. This allows it to be used as a library, not just an executable script. It also provides
better Windows support. Details in https://github.com/jeffwidman/cqlsh/pull/7 by @bschoening.
Note: This release was yanked from PyPI because it [broke Python 2 compatibility](https://github.com/jeffwidman/cqlsh/issues/11).
#### 6.0.0 (Aug 3, 2021)
This packages `cqlsh` `6.0.0` from [Cassandra 4.0](https://github.com/apache/cassandra/blob/cassandra-4.0.0/bin/cqlsh.py):
* Requires Python 3.6+ or 2.7 (although support for Python 2 is deprecated).
* Although this is pulled from a Cassandra `4.x` release, it should generally work against Cassandra `3.x` clusters without needing to set any flags.
#### 6.0.0b4 (Mar 9, 2021)
This packages `cqlsh` `5.0.1` from [Cassandra 4.0-beta4](https://github.com/apache/cassandra/blob/cassandra-4.0-beta4/bin/cqlsh.py):
* Now supports Python 3.
* Although this is pulled from a Cassandra `4.x` release, it should generally work against Cassandra `3.x` clusters without needing to set any flags.
#### 5.0.5 (Mar 9, 2021)
This packages `cqlsh` `5.0.1` from [Cassandra 3.11.10](https://github.com/apache/cassandra/blob/cassandra-3.11.10/bin/cqlsh.py).
#### 5.0.4 (Mar 29, 2017)
This packages `cqlsh` `5.0.1` from [Cassandra 3.4.0](https://github.com/apache/cassandra/blob/cassandra-3.4/bin/cqlsh.py).
#### 5.0.3 (Mar 21, 2016)
This packages `cqlsh` `5.0.1` from [Cassandra 2.2.0](https://github.com/apache/cassandra/blob/cassandra-2.2.0/bin/cqlsh.py).
#### 4.1.1 (Feb 11, 2014)
This packages `cqlsh` `4.1.1` from [Cassandra 2.0.5](https://github.com/apache/cassandra/blob/cassandra-2.0.5/bin/cqlsh).
#### 4.1.0 (Dec 2, 2013)
This packages `cqlsh` `4.1.0` from [Cassandra 2.0.3](https://github.com/apache/cassandra/blob/cassandra-2.0.3/bin/cqlsh).
#### 4.0.1 (Oct 14, 2013)
This packages `cqlsh` `4.0.1` from [Cassandra 2.0.1](https://github.com/apache/cassandra/blob/cassandra-2.0.1/bin/cqlsh).
Raw data
{
"_id": null,
"home_page": null,
"name": "cqlsh",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.9",
"maintainer_email": null,
"keywords": "cql, cassandra, cqlsh",
"author": "Brad Schoening",
"author_email": "Jeff Widman <jeff@jeffwidman.com>",
"download_url": "https://files.pythonhosted.org/packages/a1/81/7550282e0ae08a1d095bf0f43a1852b4c267fbf71428630762ae45a36ea5/cqlsh-6.2.1.tar.gz",
"platform": null,
"description": "[](https://badge.fury.io/py/cqlsh)\n\n[](https://pepy.tech/project/cqlsh)\n[](https://opensource.org/licenses/Apache-2.0)\n\n# `cqlsh`\n\n`cqlsh` is a Python-based command-line client for running `CQL` commands on a `cassandra` cluster.\n\nNormally it's packaged as part of the full Apache Cassandra\u2122 installation. This repo repackages it into a standalone Python package for lighter-weight installs.\n\n### Installing:\n\nInstall and update using [`pip`](https://pip.pypa.io/en/stable/quickstart/):\n```\n$ pip install -U cqlsh\n```\n\n### Running:\n\n```\n$ cqlsh --help\n```\n\n### Documentation:\n\nDocumentation is available as part of the official [Apache Cassandra\u2122 documentation](https://cassandra.apache.org/doc/latest/cassandra/managing/tools/cqlsh.html).\n\n### Contributing:\n\nBecause this is a repackaging of `cqlsh` from the official [Cassandra repo](https://gitbox.apache.org/repos/asf/cassandra.git), **only issues / PRs related to PyPI packaging should be opened against this repo**. If you would like to contribute to `cqlsh` itself, [find out more information here](https://github.com/apache/cassandra/blob/trunk/CONTRIBUTING.md).\n\nSteps to sanity check that the packaging works as expected:\n\n1. Install `cqlsh` locally (probably in a `virtualenv`):\n```\n$ pip install -e . # run from within the cqlsh directory\n```\nor build and install it\n\n```\n$ python -m build\n$ python -m pip install dist/*.whl\n```\n2. Start a local copy of Cassandra:\n```\n$ docker pull cassandra\n$ docker run -it --rm -p 9042:9042 cassandra\n```\n3. Verify `cqlsh` successfully connects to the server:\n```\n$ cqlsh\n\nConnected to Test Cluster at 127.0.0.1:9042\n[cqlsh 6.1.0 | Cassandra 4.1.0 | CQL spec 3.4.5 | Native protocol v5]\nUse HELP for help.\ncqlsh>\n```\n\nThis PyPI package is maintained by [Jeff Widman](https://github.com/jeffwidman) and [Brad Schoening](https://github.com/bschoening). Previous maintainers: [Spiro](https://github.com/spiside) and [Andrew Mussey](https://github.com/amussey).\n\n\n### Changelog:\n\nUnfortunately the Cassandra project does not always increment the `cqlsh` version number, so for every\nrelease we need to document not only the `cqlsh` version but also the `cassandra` version in which it\nshipped.\n\n#### 6.2.1 (August 6, 2025)\n\nThis packages `cqlsh` `6.2.0` from [Cassandra 5.0.5](https://github.com/apache/cassandra/blob/cassandra-5.0.5/pylib/cqlshlib):\n * Avoid CQLSH throwing an exception loading .cqlshrc on non-supported platforms (CASSANDRA-20478)\n * Fix text containing \"/*\" being interpreted as multiline comment in cqlsh (CASSANDRA-17667)\n * Fix autocompletion for role names/user names (CASSANDRA-20175)\n\n#### 6.2.0 (September 16, 2024)\n\nThis packages `cqlsh` `6.2.0` from [Cassandra 5.0.0](https://github.com/apache/cassandra/blob/cassandra-5.0.0/pylib/cqlshlib):\n * Add HISTORY command for CQLSH (CASSANDRA-15046)\n * Add CQLSH command SHOW REPLICAS (CASSANDRA-17577)\n * Cassandra 5.0 has refactored all cqlsh logic to be in cqlshlib, with the new cqlshmain.py replacing behavior formerly in bin/cqlsh.py\n * Replace 'wcwidth.py' with pypi module (CASSANDRA-17287)\n\n#### 6.1.3 (Feburary 23, 2023)\n\nThis packages `cqlsh` `6.1.0` from [Cassandra 4.1.4](https://github.com/apache/cassandra/blob/cassandra-4.1.4/bin/cqlsh.py):\n * CQLSH emits a warning when the server version doesn't match (CASSANDRA-18745)\n * Fix CQLSH online help topic link (CASSANDRA-17534)\n\n#### 6.1.2 (March 24, 2023)\n\nThis packages `cqlsh` `6.1.0` from [Cassandra 4.1.1](https://github.com/apache/cassandra/blob/cassandra-4.1.1/bin/cqlsh.py):\n* Now supports Python 3.11.\n* Although this is pulled from a Cassandra `4.x` release, it is protocol compatible with Cassandra `3.x` clusters, with the exception of `DESCRIBE` keywords which require a 4.x cluster.\n\n#### 6.1.1 (skipped due to a versioning issue)\n\n#### 6.1.0 (Jan 4, 2023)\n\nThis packages `cqlsh` `6.1.0` from [Cassandra 4.1](https://github.com/apache/cassandra/blob/cassandra-4.1.0/bin/cqlsh.py):\n* Requires Python 3.6+.\n* Although this is pulled from a Cassandra `4.x` release, it is protocol compatible with Cassandra `3.x` clusters, with the exception of `DESCRIBE` keywords which require a 4.x cluster.\n\n#### 6.0.1 (Jan 18, 2022)\n\nThe actual source code is identical to the `cqlsh` `6.0.0` release, except it's now packaged as\na module. This allows it to be used as a library, not just an executable script. It also provides\nbetter Windows support. Details in https://github.com/jeffwidman/cqlsh/pull/7 by @bschoening.\n\nNote: This release was yanked from PyPI because it [broke Python 2 compatibility](https://github.com/jeffwidman/cqlsh/issues/11).\n\n#### 6.0.0 (Aug 3, 2021)\n\nThis packages `cqlsh` `6.0.0` from [Cassandra 4.0](https://github.com/apache/cassandra/blob/cassandra-4.0.0/bin/cqlsh.py):\n* Requires Python 3.6+ or 2.7 (although support for Python 2 is deprecated).\n* Although this is pulled from a Cassandra `4.x` release, it should generally work against Cassandra `3.x` clusters without needing to set any flags.\n\n\n#### 6.0.0b4 (Mar 9, 2021)\n\nThis packages `cqlsh` `5.0.1` from [Cassandra 4.0-beta4](https://github.com/apache/cassandra/blob/cassandra-4.0-beta4/bin/cqlsh.py):\n* Now supports Python 3.\n* Although this is pulled from a Cassandra `4.x` release, it should generally work against Cassandra `3.x` clusters without needing to set any flags.\n\n#### 5.0.5 (Mar 9, 2021)\n\nThis packages `cqlsh` `5.0.1` from [Cassandra 3.11.10](https://github.com/apache/cassandra/blob/cassandra-3.11.10/bin/cqlsh.py).\n\n#### 5.0.4 (Mar 29, 2017)\n\nThis packages `cqlsh` `5.0.1` from [Cassandra 3.4.0](https://github.com/apache/cassandra/blob/cassandra-3.4/bin/cqlsh.py).\n\n\n#### 5.0.3 (Mar 21, 2016)\n\nThis packages `cqlsh` `5.0.1` from [Cassandra 2.2.0](https://github.com/apache/cassandra/blob/cassandra-2.2.0/bin/cqlsh.py).\n\n\n#### 4.1.1 (Feb 11, 2014)\n\nThis packages `cqlsh` `4.1.1` from [Cassandra 2.0.5](https://github.com/apache/cassandra/blob/cassandra-2.0.5/bin/cqlsh).\n\n\n#### 4.1.0 (Dec 2, 2013)\n\nThis packages `cqlsh` `4.1.0` from [Cassandra 2.0.3](https://github.com/apache/cassandra/blob/cassandra-2.0.3/bin/cqlsh).\n\n\n#### 4.0.1 (Oct 14, 2013)\n\nThis packages `cqlsh` `4.0.1` from [Cassandra 2.0.1](https://github.com/apache/cassandra/blob/cassandra-2.0.1/bin/cqlsh).\n",
"bugtrack_url": null,
"license": null,
"summary": "cqlsh is a Python-based command-line client for running CQL commands on a cassandra cluster.",
"version": "6.2.1",
"project_urls": {
"Changelog": "https://github.com/jeffwidman/cqlsh#changelog",
"Documentation": "https://cassandra.apache.org/doc/latest/tools/cqlsh.html",
"Issues": "https://github.com/jeffwidman/cqlsh/issues"
},
"split_keywords": [
"cql",
" cassandra",
" cqlsh"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "c86422322909f6ed7bdf6fdf4f4b60b303a43b3b1d370213368c36f79cd0f9f2",
"md5": "9d2f1a156bd1f08bba95a2c8ee9b05b5",
"sha256": "c574b6e5e5fda2ed9db49e3907a5ffae1e2f999665daf84c843732f5ba7cde01"
},
"downloads": -1,
"filename": "cqlsh-6.2.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "9d2f1a156bd1f08bba95a2c8ee9b05b5",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.9",
"size": 105503,
"upload_time": "2025-08-13T18:48:59",
"upload_time_iso_8601": "2025-08-13T18:48:59.043596Z",
"url": "https://files.pythonhosted.org/packages/c8/64/22322909f6ed7bdf6fdf4f4b60b303a43b3b1d370213368c36f79cd0f9f2/cqlsh-6.2.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "a1817550282e0ae08a1d095bf0f43a1852b4c267fbf71428630762ae45a36ea5",
"md5": "df56e78abc76d11a59023e7502ae80fb",
"sha256": "1893b15105dadcdb7b0c1cd522490c1133a506ab13d610f839164e4c272ed3ca"
},
"downloads": -1,
"filename": "cqlsh-6.2.1.tar.gz",
"has_sig": false,
"md5_digest": "df56e78abc76d11a59023e7502ae80fb",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.9",
"size": 95939,
"upload_time": "2025-08-13T18:48:59",
"upload_time_iso_8601": "2025-08-13T18:48:59.908733Z",
"url": "https://files.pythonhosted.org/packages/a1/81/7550282e0ae08a1d095bf0f43a1852b4c267fbf71428630762ae45a36ea5/cqlsh-6.2.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-08-13 18:48:59",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "jeffwidman",
"github_project": "cqlsh#changelog",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "cqlsh"
}
