CLI for SQL Server Database. With auto-completion and syntax highlighting.
.. image:: https://badge.fury.io/py/osql_cli.svg :target: https://pypi.python.org/pypi/osql_cli
.. image:: https://img.shields.io/pypi/pyversions/osql-cli.svg :target: https://github.com/dbcli/osql-cli
We’re excited to introduce osql-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.
.. image:: screenshots/osql-cli-autocomplete.gif :align: center
+--------------------------------------------+--------------------------------+-------------------------------+-------------------------------+
| Supported Platform | Downloads (stable) | Downloads (preview) | How to Install |
+============================================+================================+===============================+===============================+
| Windows (x64) | .whl windows (x64)_ | .whl windows (x64) (dev)_ | Install on windows_ |
+--------------------------------------------+--------------------------------+-------------------------------+-------------------------------+
| Windows (x86) | .whl windows (x86)_ | .whl windows (x86) (dev)_ | Install on windows_ |
+--------------------------------------------+--------------------------------+-------------------------------+-------------------------------+
| macOS 10.12+ | .whl_ | .whl (dev)_ | Install on macos_ |
+--------------------------------------------+--------------------------------+-------------------------------+-------------------------------+
| Ubuntu 17.04 | .deb_ | .deb (dev)_ | Install on ubuntu17_ |
+--------------------------------------------+--------------------------------+-------------------------------+-------------------------------+
| Ubuntu 16.04 | .deb_ | .deb (dev)_ | Install on ubuntu16_ |
+--------------------------------------------+--------------------------------+-------------------------------+-------------------------------+
| Ubuntu 14.04 | .deb_ | .deb (dev)_ | Install on ubuntu14_ |
+--------------------------------------------+--------------------------------+-------------------------------+-------------------------------+
| Debian 8.7+ | .deb_ | .deb (dev)_ | Install on debian8_ |
+--------------------------------------------+--------------------------------+-------------------------------+-------------------------------+
| Debian 9 | .deb_ | .deb (dev)_ | Install on debian9_ |
+--------------------------------------------+--------------------------------+-------------------------------+-------------------------------+
| CentOS 7 | .rpm_ | .rpm (dev)_ | Install on centos_ |
+--------------------------------------------+--------------------------------+-------------------------------+-------------------------------+
| Red Hat Enterprise Linux 7 | .rpm_ | .rpm (dev)_ | Install on rhel7_ |
+--------------------------------------------+--------------------------------+-------------------------------+-------------------------------+
| OpenSUSE 42.2+ | .rpm_ | .rpm (dev)_ | Install on opensuse42_ |
+--------------------------------------------+--------------------------------+-------------------------------+-------------------------------+
| Fedora 25 | .rpm_ | .rpm (dev)_ | Install on fedora25_ |
+--------------------------------------------+--------------------------------+-------------------------------+-------------------------------+
| Fedora 26 | .rpm_ | .rpm (dev)_ | Install on fedora26_ |
+--------------------------------------------+--------------------------------+-------------------------------+-------------------------------+
Please refer to Get osql-cli_ for detailed install instructions per platform.
.. code:: bash
$ pip install osql-cli
Please refer to Install via pip_ for detailed install instructions via pip on each platform
Please refer to the usage guide_ for details on options and example usage. If you are having any issues using osql-cli, please see the troubleshooting guide_.
For general help content, pass in the -h parameter:
.. code:: bash
$ osql-cli --help
The osql-cli tool includes a telemetry feature. Please refer to the telemetry guide_ for more information.
If you would like to contribute to the project, please refer to the development guide_.
If you encounter any bugs with the tool please file an issue in the
Issues_ section of our GitHub repo.
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.
osql-cli is licensed under the BSD-3 license_.
.. _osql-cli: https://github.com/dbcli/osql-cli .. _dbcli.org community: https://github.com/dbcli .. _troubleshooting guide: https://github.com/dbcli/osql-cli/blob/master/doc/troubleshooting_guide.md .. _development guide: https://github.com/dbcli/osql-cli/tree/master/doc/development_guide.md .. _usage guide: https://github.com/dbcli/osql-cli/tree/master/doc/usage_guide.md .. _telemetry guide: https://github.com/dbcli/osql-cli/tree/master/doc/telemetry_guide.md .. _Issues: https://github.com/dbcli/osql-cli/issues .. _Microsoft Open Source Code of Conduct: https://opensource.microsoft.com/codeofconduct/ .. _Code of Conduct FAQ: https://opensource.microsoft.com/codeofconduct/faq/ .. _BSD-3 license: https://github.com/dbcli/osql-cli/blob/master/LICENSE.txt
.. _Install via pip: https://github.com/dbcli/osql-cli/blob/master/doc/installation/pip.md
.. _Install on windows: https://github.com/dbcli/osql-cli/blob/master/doc/installation/windows.md#windows-installation .. _Install on macos: https://github.com/dbcli/osql-cli/blob/master/doc/installation/macos.md#macos-installation .. _Install on ubuntu14: https://github.com/dbcli/osql-cli/blob/master/doc/installation/linux.md#ubuntu-1404 .. _Install on ubuntu16: https://github.com/dbcli/osql-cli/blob/master/doc/installation/linux.md#ubuntu-1604 .. _Install on ubuntu17: https://github.com/dbcli/osql-cli/blob/master/doc/installation/linux.md#ubuntu-1704 .. _Install on debian8: https://github.com/dbcli/osql-cli/blob/master/doc/installation/linux.md#debian-8 .. _Install on debian9: https://github.com/dbcli/osql-cli/blob/master/doc/installation/linux.md#debian-9 .. _Install on centos: https://github.com/dbcli/osql-cli/blob/master/doc/installation/linux.md#centos-7 .. _Install on rhel7: https://github.com/dbcli/osql-cli/blob/master/doc/installation/linux.md#red-hat-enterprise-linux-rhel-7 .. _Install on opensuse42: https://github.com/dbcli/osql-cli/blob/master/doc/installation/linux.md#opensuse-422 .. _Install on fedora25: https://github.com/dbcli/osql-cli/blob/master/doc/installation/linux.md#fedora-25 .. _Install on fedora26: https://github.com/dbcli/osql-cli/blob/master/doc/installation/linux.md#fedora-26
.. _.whl windows (x64) (dev): https://osqlcli.blob.core.windows.net/daily/whl/osql-cli/osql_cli-dev-latest-py2.py3-none-win_amd64.whl .. _.whl windows (x86) (dev): https://osqlcli.blob.core.windows.net/daily/whl/osql-cli/osql_cli-dev-latest-py2.py3-none-win32.whl .. _.whl (dev): https://osqlcli.blob.core.windows.net/daily/whl/osql-cli/osql_cli-dev-latest-py2.py3-none-macosx_10_11_intel.whl
.. _.deb (dev): https://osqlcli.blob.core.windows.net/daily/deb/osql-cli-dev-latest.deb .. _.rpm (dev): https://osqlcli.blob.core.windows.net/daily/rpm/osql-cli-dev-latest.rpm
.. _.deb: https://packages.microsoft.com/ubuntu/14.04/prod/pool/main/m/osql-cli/osql-cli_0.10.0-1_all.deb .. _.rpm: https://packages.microsoft.com/rhel/7/prod/osql-cli-0.10.0-1.el7.x86_64.rpm
.. _.whl windows (x64): https://files.pythonhosted.org/packages/0d/7c/5e2bcbed3d6215196118337aec9793a7d74ab5cca10b1d834873cb6ac492/osql_cli-0.10.0-py2.py3-none-win_amd64.whl .. _.whl windows (x86): https://files.pythonhosted.org/packages/4c/84/ba083d0677641f70ed11394fa93414275598161d1e8b6f444b67533079fa/osql_cli-0.10.0-py2.py3-none-win32.whl .. _.whl: https://files.pythonhosted.org/packages/a6/de/55b73b6aa03e9890585ef5df5dac5717708db1a5018acde2582526b42fc9/osql_cli-0.10.0-py2.py3-none-macosx_10_11_intel.whl
FAQs
CLI for SQL Server Database. With auto-completion and syntax highlighting.
We found that osql-cli demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
CISOs are racing to adopt AI for cybersecurity, but hurdles in budgets and governance may leave some falling behind in the fight against cyber threats.
Research
Security News
Socket researchers uncovered a backdoored typosquat of BoltDB in the Go ecosystem, exploiting Go Module Proxy caching to persist undetected for years.
Security News
Company News
Socket is joining TC54 to help develop standards for software supply chain security, contributing to the evolution of SBOMs, CycloneDX, and Package URL specifications.