Skip to main content

CLI for SQL Server Database. With auto-completion and syntax highlighting.

Project description

https://badge.fury.io/py/mssql-cli.svg https://img.shields.io/pypi/pyversions/mssql-cli.svg

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.

https://github.com/dbcli/mssql-cli/raw/master/screenshots/mssql-cli-autocomplete.gif

Features

  • Auto-completion

  • Syntax highlighting

  • Query history

  • Configuration file support

  • Multi-line queries

Get mssql-cli

Install Instructions

Windows (x64)

Windows (x86)

macOS 10.12+

Ubuntu 17.04

Ubuntu 16.04

Ubuntu 14.04

Debian 8.7+

Debian 9

CentOS 7

Red Hat Enterprise Linux 7

OpenSUSE 42.2+

Fedora 25

Fedora 26

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-cli

Please 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 --help

The 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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

mssql_cli-0.17.2-py2.py3-none-win32.whl (42.3 MB view details)

Uploaded Python 2 Python 3 Windows x86

mssql_cli-0.17.2-py2.py3-none-manylinux1_x86_64.whl (43.4 MB view details)

Uploaded Python 2 Python 3

mssql_cli-0.17.2-py2.py3-none-macosx_10_11_intel.whl (42.4 MB view details)

Uploaded Python 2 Python 3 macOS 10.11+ intel

File details

Details for the file mssql_cli-0.17.2-py2.py3-none-win32.whl.

File metadata

  • Download URL: mssql_cli-0.17.2-py2.py3-none-win32.whl
  • Upload date:
  • Size: 42.3 MB
  • Tags: Python 2, Python 3, Windows x86
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.0.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.6.0 requests-toolbelt/0.9.1 tqdm/4.39.0 CPython/3.7.4

File hashes

Hashes for mssql_cli-0.17.2-py2.py3-none-win32.whl
Algorithm Hash digest
SHA256 00d27e7af05fd35d302a0f829773342619d907899c7446d957eb4807dd1d1d9d
MD5 f0a919258a222e5baa43790310440584
BLAKE2b-256 42818920029aa023226dac2f7efb130f2e891ea289dc18302fb217658a8b2d8e

See more details on using hashes here.

File details

Details for the file mssql_cli-0.17.2-py2.py3-none-manylinux1_x86_64.whl.

File metadata

  • Download URL: mssql_cli-0.17.2-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/3.0.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.6.0 requests-toolbelt/0.9.1 tqdm/4.39.0 CPython/3.7.4

File hashes

Hashes for mssql_cli-0.17.2-py2.py3-none-manylinux1_x86_64.whl
Algorithm Hash digest
SHA256 0c054e6c98cc1f25ecc3d60beaf710a1fc7e470924e8761098ef47086c7b2b78
MD5 bcb72ccc2c00c5c7f935117c7c7d1f9e
BLAKE2b-256 f481b1b585a792c58ba434233d901753059633ff49d0343dfcf1fc149899d197

See more details on using hashes here.

File details

Details for the file mssql_cli-0.17.2-py2.py3-none-macosx_10_11_intel.whl.

File metadata

  • Download URL: mssql_cli-0.17.2-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/3.0.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.6.0 requests-toolbelt/0.9.1 tqdm/4.39.0 CPython/3.7.4

File hashes

Hashes for mssql_cli-0.17.2-py2.py3-none-macosx_10_11_intel.whl
Algorithm Hash digest
SHA256 c82c34d05bf6b412cee47e187773ef974a379ce28c6dbf594e0a13f1dfc9aad8
MD5 28b7fdc13e73eb9288f7cba33025a727
BLAKE2b-256 1d0aa55987730c727e3e8a605b9e6b43487acf9ff70914c4a0bf54f7261c685a

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page