CLI for SQL Server Database. With auto-completion and syntax highlighting.
Project description
mssql-cli
We’re excited to introduce mssql-cli, a new and interactive command line query tool for SQL Server. This open source tool works cross-platform and proud to be a part of the dbcli.org community.
Features
Auto-completion
Syntax highlighting
Query history
Configuration file support
Multi-line queries
Get mssql-cli
Install Instructions |
|---|
Direct downloads
Direct downloads for both latest stable and preview bits can be found at Direct download.
Installation via apt, yum
Please refer to Get mssql-cli for detailed install instructions per platform.
Installation via pip
$ pip install mssql-cliPlease refer to Install via pip for detailed install instructions via pip on each platform
Usage
Please refer to the usage guide for details on options and example usage. If you are having any issues using mssql-cli, please see the troubleshooting guide.
For general help content, pass in the -h parameter:
$ mssql-cli --helpThe mssql-cli tool includes a telemetry feature. Please refer to the telemetry guide for more information.
Configuration
Customization and persistence of settings can be achieved with a config file, whose path can be passed as the --mssqlclirc <file> command line argument. Otherwise it is read from the default path ~/.config/mssqlcli/config on macOS and Linux, and %LOCALAPPDATA%\dbcli\mssqlcli\config on Windows. See the config file itself for a description of all available options.
Contributing
If you would like to contribute to the project, please refer to the development guide.
Reporting issues and feedback
If you encounter any bugs with the tool please file an issue in the Issues section of our GitHub repo.
Code of Conduct
This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.
License
mssql-cli is licensed under the BSD-3 license.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
Built Distributions
File details
Details for the file mssql_cli-0.17.0-py2.py3-none-win_amd64.whl.
File metadata
- Download URL: mssql_cli-0.17.0-py2.py3-none-win_amd64.whl
- Upload date:
- Size: 45.1 MB
- Tags: Python 2, Python 3, Windows x86-64
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/2.0.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.2.0 requests-toolbelt/0.9.1 tqdm/4.36.1 CPython/3.7.4
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | cce8ac8c7f4291f34e098425087be4070404aabc905f19a0cdd6e1784b33243b |
|
| MD5 | ac79b1912fb17eabab6a6ef1e7d756b7 |
|
| BLAKE2b-256 | e9d5941d29416f5dfbdd76e7261570ce4df6c0ac8ff2dd4afcadf119e2409163 |
File details
Details for the file mssql_cli-0.17.0-py2.py3-none-win32.whl.
File metadata
- Download URL: mssql_cli-0.17.0-py2.py3-none-win32.whl
- Upload date:
- Size: 42.2 MB
- Tags: Python 2, Python 3, Windows x86
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/2.0.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.2.0 requests-toolbelt/0.9.1 tqdm/4.36.1 CPython/3.7.4
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | d23515ba649e3200675bedf340d2da0aacfc019cfe60992c6d0d645a6a1abf8d |
|
| MD5 | 9d8a7beafd747b659a780512e7b0ea95 |
|
| BLAKE2b-256 | 9b694af4cd5a6eb5ce40ea2bf3a91750cf468e29d31c5129f71a5843bd40528a |
File details
Details for the file mssql_cli-0.17.0-py2.py3-none-manylinux1_x86_64.whl.
File metadata
- Download URL: mssql_cli-0.17.0-py2.py3-none-manylinux1_x86_64.whl
- Upload date:
- Size: 43.4 MB
- Tags: Python 2, Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/2.0.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.2.0 requests-toolbelt/0.9.1 tqdm/4.36.1 CPython/3.7.4
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | e02b8060822daa758ea48b9988b6d4465b8b5c975d43f51f4255c876d8697c5f |
|
| MD5 | e0d8192e02e849a87150921ad9668b92 |
|
| BLAKE2b-256 | a6708557decbbf636c707f0c08a98e3f27340b79077e0b61cc2ede5cc57fdc05 |
File details
Details for the file mssql_cli-0.17.0-py2.py3-none-macosx_10_11_intel.whl.
File metadata
- Download URL: mssql_cli-0.17.0-py2.py3-none-macosx_10_11_intel.whl
- Upload date:
- Size: 42.4 MB
- Tags: Python 2, Python 3, macOS 10.11+ intel
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/2.0.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.2.0 requests-toolbelt/0.9.1 tqdm/4.36.1 CPython/3.7.4
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 7e7ee24751eb4f210531abb996d227e60f22edf2ba9a5e951c6375abc86255a2 |
|
| MD5 | 407ec87b14e6da144b59539e20f3f57b |
|
| BLAKE2b-256 | 75fb25384952ae22f617430cec4b2cda4682a55f5720c3d3de8816dc6974bef9 |
