{"id":21446,"date":"2017-12-12T09:00:01","date_gmt":"2017-12-12T17:00:01","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=21446"},"modified":"2024-01-22T22:51:08","modified_gmt":"2024-01-23T06:51:08","slug":"try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/","title":{"rendered":"Try mssql-cli, a new interactive command line tool for SQL Server"},"content":{"rendered":"<p>mssql-cli, a new and interactive command line query tool for SQL Server. This open source tool works cross-platform and is a proud member of the dbcli community.<\/p>\n<p>Read on to learn more about mssql-cli features, how to submit feature requests or issues, and our open source collaboration story to bring you this great tool.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-21465 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssql-cli-autocomplete.gif\" alt=\"\" width=\"756\" height=\"338\" \/><\/p>\n<p style=\"text-align: center\"><em>mssql-cli auto-completion that is context aware<\/em><\/p>\n<h2>Features<\/h2>\n<p>Mssql-cli is a new and interactive command line tool that provides the following key enhancements over sqlcmd in the Terminal environment:<\/p>\n<ul>\n<li>T-SQL IntelliSense<\/li>\n<li>Syntax highlighting<\/li>\n<li>Pretty formatting for query results, including Vertical Format<\/li>\n<li>Multi-line edit mode<\/li>\n<li>Configuration file support<\/li>\n<\/ul>\n<p>Mssql-cli aims to offer an improved interactive command line experience for T-SQL. It is fully open source under the BSD-3 license, and a contribution to the <a href=\"https:\/\/github.com\/dbcli\/\">dbcli organization<\/a>, an open source suite of interactive CLI tools for relational databases including SQL Server, PostgresSQL, and MySQL. The command-line UI is written in Python and the tool leverages the same microservice backend (<a href=\"https:\/\/github.com\/Microsoft\/sqltoolsservice\/\">sqltoolsservice<\/a>) that powers the VS Code SQL extension, SQL Operations Studio, and the other Python CLI tool we announced earlier, mssql-scripter.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21477 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssqlcli-multiline1.png\" alt=\"\" width=\"1153\" height=\"228\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssqlcli-multiline1.webp 1793w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssqlcli-multiline1-300x59.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssqlcli-multiline1-1024x203.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssqlcli-multiline1-768x152.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssqlcli-multiline1-1536x304.webp 1536w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssqlcli-multiline1-330x65.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssqlcli-multiline1-800x158.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssqlcli-multiline1-400x79.webp 400w\" sizes=\"auto, (max-width: 1153px) 100vw, 1153px\" \/><\/p>\n<p style=\"text-align: center\"><em>mssql-cli multi-line queries to build readable queries. Also includes syntax highlighting and \u201csmart\u201d auto-completion.<\/em><\/p>\n<h2>Try it now<\/h2>\n<p>In order to install mssql-cli, you must have Python on your machine.<\/p>\n<p>Mssql-cli is installed via pip. If you know pip, you can install mssql-cli using command.<\/p>\n<pre>$ pip install mssql-cli<\/pre>\n<p>This command may need to run as sudo if you are installing to the system site packages. Mssql-cli can be installed using the &#8211;user option, which does not require sudo.<\/p>\n<pre>$ pip install --user mssql-cli<\/pre>\n<p>Once you have mssql-cli installed, connect to your database with the command:<\/p>\n<pre>$ mssql-cli -S &lt;server name&gt; -U &lt;user name&gt; -d &lt;database name&gt;<\/pre>\n<h2>Contact us<\/h2>\n<p>We are open to any questions, feedback, or any feature suggestions for future releases, which can be submitted on our <a href=\"https:\/\/github.com\/dbcli\/mssql-cli\/issues\">GitHub Issues<\/a>.<\/p>\n<h2>Our Open Source Story<\/h2>\n<p>Over the years, customers have told us we need to modernize sqlcmd. This feedback got significantly amplified after SQL Server 2017 was released on Linux and macOS (Docker). Customers asked us for richer experiences on the command line including tab completion for T-SQL keywords and database objects and syntax highlighting.<\/p>\n<p>Thus, the SQL Developer Experiences team set out to create a modern version of sqlcmd. As we worked through our scenarios, we discovered an awesome and immensely popular set of open source command line tools for databases on GitHub at <a href=\"https:\/\/github.com\/dbcli\">https:\/\/github.com\/dbcli<\/a> maintained by the dbcli organization. The repo contains open source cross-platform CLI tools for databases, which support &#8220;smart&#8221; auto-completion, syntax highlighting and easy installation. We were particularly impressed with the <a href=\"https:\/\/github.com\/dbcli\/pgcli\">pgcli<\/a> and <a href=\"https:\/\/github.com\/dbcli\/mycli\">mycli<\/a> tools, as well as how active and passionate their community was in creating better database cli tools.<\/p>\n<p>We reached out to Amjith Ramanujam, the founder of the dbcli organization, did an in-depth demo, explained what we were trying to do, and explored if <strong>mssql-cli<\/strong> could be included in the dbcli family. Simply put, Amjith and the other maintainers of the project were delighted and welcomed us with open arms!<\/p>\n<p>This is a momentous occasion for the SQL Developer Experiences team because it represents <strong>the first time our team is contributing source code to an existing open source organization with a commitment to be a good citizen in an existing open source community<\/strong>. It is also an exciting moment to build an awesome tool by collaborating with the OSS community, which we will continue to do in the future.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>mssql-cli, a new and interactive command line query tool for SQL Server. This open source tool works cross-platform and is a proud member of the dbcli community. Read on to learn more about mssql-cli features, how to submit feature requests or issues, and our open source collaboration story to bring you this great tool.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5227,2406,2409,2418],"content-type":[2421],"topic":[2475],"coauthors":[2487],"class_list":["post-21446","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2017","product-sql-server-2017-on-linux","product-sql-server-on-linux","content-type-announcements","topic-oltp-database-management","review-flag-1593580427-503","review-flag-1593580770-633","review-flag-3-1593580441-293","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Try mssql-cli, a new interactive command line tool for SQL Server - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Try mssql-cli, a new interactive command line tool for SQL Server - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"mssql-cli, a new and interactive command line query tool for SQL Server. This open source tool works cross-platform and is a proud member of the dbcli community. Read on to learn more about mssql-cli features, how to submit feature requests or issues, and our open source collaboration story to bring you this great tool.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2017-12-12T17:00:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssql-cli-autocomplete.gif\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2017\\\/12\\\/12\\\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2017\\\/12\\\/12\\\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\\\/\"},\"author\":[{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/author\\\/sql-server-team\\\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Try mssql-cli, a new interactive command line tool for SQL Server\",\"datePublished\":\"2017-12-12T17:00:01+00:00\",\"dateModified\":\"2024-01-23T06:51:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2017\\\/12\\\/12\\\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\\\/\"},\"wordCount\":570,\"commentCount\":17,\"publisher\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2017\\\/12\\\/12\\\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/mssql-cli-autocomplete.gif\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2017\\\/12\\\/12\\\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2017\\\/12\\\/12\\\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\\\/\",\"url\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2017\\\/12\\\/12\\\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\\\/\",\"name\":\"Try mssql-cli, a new interactive command line tool for SQL Server - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2017\\\/12\\\/12\\\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2017\\\/12\\\/12\\\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/mssql-cli-autocomplete.gif\",\"datePublished\":\"2017-12-12T17:00:01+00:00\",\"dateModified\":\"2024-01-23T06:51:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2017\\\/12\\\/12\\\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2017\\\/12\\\/12\\\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2017\\\/12\\\/12\\\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/mssql-cli-autocomplete.gif\",\"contentUrl\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/mssql-cli-autocomplete.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2017\\\/12\\\/12\\\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Try mssql-cli, a new interactive command line tool for SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/Microsoft-Logo.png\",\"contentUrl\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"http:\\\/\\\/www.facebook.com\\\/sqlserver\",\"https:\\\/\\\/x.com\\\/SQLServer\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Try mssql-cli, a new interactive command line tool for SQL Server - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Try mssql-cli, a new interactive command line tool for SQL Server - Microsoft SQL Server Blog","og_description":"mssql-cli, a new and interactive command line query tool for SQL Server. This open source tool works cross-platform and is a proud member of the dbcli community. Read on to learn more about mssql-cli features, how to submit feature requests or issues, and our open source collaboration story to bring you this great tool.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2017-12-12T17:00:01+00:00","article_modified_time":"2024-01-23T06:51:08+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssql-cli-autocomplete.gif","type":"","width":"","height":""}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Try mssql-cli, a new interactive command line tool for SQL Server","datePublished":"2017-12-12T17:00:01+00:00","dateModified":"2024-01-23T06:51:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/"},"wordCount":570,"commentCount":17,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssql-cli-autocomplete.gif","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/","name":"Try mssql-cli, a new interactive command line tool for SQL Server - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssql-cli-autocomplete.gif","datePublished":"2017-12-12T17:00:01+00:00","dateModified":"2024-01-23T06:51:08+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssql-cli-autocomplete.gif","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2017\/12\/mssql-cli-autocomplete.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/12\/12\/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Try mssql-cli, a new interactive command line tool for SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_animated_featured_image":null,"bloginabox_display_generated_audio":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/21446","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=21446"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/21446\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=21446"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=21446"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=21446"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=21446"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=21446"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=21446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}