GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → dbcli → Mssql Cli

dbcli / Mssql Cli

Licence: bsd-3-clause
A command-line client for SQL Server with auto-completion and syntax highlighting

Programming Languages

python
139335 projects - #7 most used programming language

Labels

clidatabasesqlserver

Projects that are alternatives of or similar to Mssql Cli

Csv2db
The CSV to database command line loader
Stars: ✭ 102 (-90.39%)
Mutual labels:  cli, database, sqlserver
Lev
The complete REPL & CLI for managing LevelDB instances.
Stars: ✭ 295 (-72.2%)
Mutual labels:  cli, database
Ronin
Ronin is a Ruby platform for vulnerability research and exploit development. Ronin allows for the rapid development and distribution of code, Exploits or Payloads, Scanners, etc, via Repositories.
Stars: ✭ 220 (-79.26%)
Mutual labels:  cli, database
Mongo Seeding
The ultimate solution for populating your MongoDB database.
Stars: ✭ 375 (-64.66%)
Mutual labels:  cli, database
Autoserver
Create a full-featured REST/GraphQL API from a configuration file
Stars: ✭ 188 (-82.28%)
Mutual labels:  cli, database
Klepto
Klepto is a tool for copying and anonymising data
Stars: ✭ 193 (-81.81%)
Mutual labels:  cli, database
Dibi
Dibi - smart database abstraction layer
Stars: ✭ 373 (-64.84%)
Mutual labels:  database, sqlserver
Evolve
Database migration tool for .NET and .NET Core projects. Inspired by Flyway.
Stars: ✭ 477 (-55.04%)
Mutual labels:  database, sqlserver
Jooq
jOOQ is the best way to write SQL in Java
Stars: ✭ 4,695 (+342.51%)
Mutual labels:  database, sqlserver
Monitor Table Change With Sqltabledependency
Get SQL Server notification on record table change
Stars: ✭ 459 (-56.74%)
Mutual labels:  database, sqlserver
Webtau
Webtau (short for web test automation) is a testing API, command line tool and a framework to write unit, integration and end-to-end tests. Test across REST-API, Graph QL, Browser, Database, CLI and Business Logic with consistent set of matchers and concepts. REPL mode speeds-up tests development. Rich reporting cuts down investigation time.
Stars: ✭ 156 (-85.3%)
Mutual labels:  cli, database
Typeorm Seeding
🌱 A delightful way to seed test data into your database.
Stars: ✭ 501 (-52.78%)
Mutual labels:  cli, database
Dynein
DynamoDB CLI written in Rust.
Stars: ✭ 126 (-88.12%)
Mutual labels:  cli, database
Ldb
A C++ REPL / CLI for LevelDB
Stars: ✭ 201 (-81.06%)
Mutual labels:  cli, database
Dksnap
Docker Snapshots for Development and Test Data
Stars: ✭ 122 (-88.5%)
Mutual labels:  cli, database
Dbachecks
✔ SQL Server Environmental Validation
Stars: ✭ 319 (-69.93%)
Mutual labels:  database, sqlserver
App
Reusable framework for micro services & command line tools
Stars: ✭ 66 (-93.78%)
Mutual labels:  cli, database
Mongoaudit
🔥 A powerful MongoDB auditing and pentesting tool 🔥
Stars: ✭ 1,174 (+10.65%)
Mutual labels:  cli, database
Symmetric Ds
SymmetricDS is a database and file synchronization solution that is platform-independent, web-enabled, and database agnostic. SymmetricDS was built to make data replication across two to tens of thousands of databases and file systems fast, easy and resilient. We specialize in near real time, bi-directional data replication across large node networks over the WAN or LAN.
Stars: ✭ 450 (-57.59%)
Mutual labels:  database, sqlserver
Things.sh
Simple read-only comand-line interface to your Things 3 database
Stars: ✭ 492 (-53.63%)
Mutual labels:  cli, database
View All Similar Projects ➔

PyPI Python 2.7|3.4|3.5|3.6|3.7|3.8

mssql-cli

mssql-cli is an interactive command line query tool for SQL Server. This open source tool works cross-platform and proud to be a part of the dbcli community.

mssql-cli Autocomplete

mssql-cli supports a rich interactive command line experience, with features such as:

  • Auto-completion: fewer keystrokes needed to complete complicated queries.
  • Syntax highlighting: highlights T-SQL keywords.
  • Query history: easily complete an auto-suggested query that was previously executed.
  • Configuration file support: customize the mssql-cli experience for your needs.
  • Multi-line queries: execute multiple queries at once using the multi-line edit mode.
  • Non-interactive support: execute a query without jumping into the interactive experience.

Quick Start

Read the section below to quickly get started with mssql-cli. Consult the usage guide for a deeper dive into mssql-cli features.

Install mssql-cli

Platform-specific installation instructions are below: | Windows (preview) | macOS | Linux | | - | - | - |

Visit the installation reference guide to view all supported releases and downloads.

Install with Linux Package Manager

Follow the Linux installation instructions to install mssql-cli using apt-get, yum, and other Linux package managers.

Install with pip

python -m pip install mssql-cli

Please refer to the pip installation docs for more platform-specific information.

Connect to Server

Complete the command below to connect to your server:

mssql-cli -S <server URL> -d <database name> -U <username> -P <password>

Exit mssql-cli

Press Ctrl+D or type quit.

Show Options

For general help content, pass in the -h parameter:

mssql-cli --help

Usage Docs

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.

Telemetry

The mssql-cli tool includes a telemetry feature. Please refer to the telemetry guide for more information.

Contributing

If you would like to contribute to the project, please refer to the development guide.

Contact Us

If you encounter any bugs or would like to leave a feature request, 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 [email protected] with any additional questions or comments.

License

mssql-cli is licensed under the BSD-3 license.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].