# Install sqlcmd with Homebrew, chocolatey, Nix, winget Microsoft SQL Server command-line interface. Version 1.10.0 via Homebrew; verified 2026-04-10. ## Install ```sh sudo av install brew:sqlcmd ``` ## Agent safety answer sqlcmd sends SQL to Microsoft SQL Server and Azure SQL targets. - **Credential access:** Reads database passwords, connection strings, tokens, and environment credentials. - **Remote mutation:** Can create, alter, drop, import, and export database state. - **Publish/artifact risk:** Can dump or load data artifacts containing sensitive records. - **Recommended control:** Gate write SQL, dumps, imports, and credential-bearing connection strings. - **Agent-use guidance:** Allow safe metadata queries; require approval for writes, exports, and secret use. Additional install commands: ### macOS - Homebrew (100%): ```sh brew install sqlcmd ``` Evidence: local Homebrew formula metadata ### Linux - Nix (92%): ```sh nix profile install nixpkgs#sqlcmd ``` Evidence: nixpkgs package indexes: pkgs/by-name/sq/sqlcmd/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 ### Windows - Chocolatey (92%): ```sh choco install sqlcmd ``` Evidence: Chocolatey community package catalog: sqlcmd from http://community.chocolatey.org/api/v2/Packages?$filter=IsLatestVersion&$select=Id&$top=1000&$skiptoken='11','sql2008r2.cmdline' - winget (92%): ```sh winget install --id Microsoft.Sqlcmd -e ``` Evidence: Windows Package Manager source index: Microsoft.Sqlcmd from https://cdn.winget.microsoft.com/cache/source.msix ## Package facts - **Package key:** brew:sqlcmd - **Package manager:** Homebrew - **Package manager page:** - **Version:** 1.10.0 - **Source summary:** Microsoft SQL Server command-line interface - **Homepage:** - **Repository:** - **Upstream docs:** - **License:** MIT - **Source archive:** - **Last updated:** 2026-04-10T21:11:12Z - **Generated:** 2026-07-08T07:18:31+00:00 ## Executables - sqlcmd (cli) - sqlcmd (alias) ## Build dependencies - go ## Install behavior - Post-install hook: not defined - Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux ## Freshness - Page generated: 2026-07-08 - Package-manager version: 1.10.0 - Package-manager updated: 2026-04-10 - Local data: ok - Upstream repository: https://github.com/microsoft/go-sqlcmd - Upstream latest detected: v1.10.0 (current) ## Project history and usage sqlcmd is Microsoft's command-line interface for SQL Server and Azure SQL. The Homebrew formula tracks the newer Go implementation, go-sqlcmd, which preserves much of the long-running ODBC sqlcmd workflow while adding modern package-manager distribution and container-oriented commands. ### Project history Microsoft's go-sqlcmd repository was created in 2021, and its README says the project aims to be a complete Go port of the original ODBC sqlcmd using the go-mssqldb driver. The first preview releases appeared in 2021. The README documents both backward-compatible ODBC-style flags and newer POSIX-style flags, plus additions such as local SQL Server container creation and context management. ### Adoption history The Go version is explicitly packaged for major platforms: the README lists Winget, Chocolatey, Homebrew, Linuxbrew, apt, yum, zypper, and release artifacts. The input package metadata lists Homebrew, Chocolatey, Nix, and Winget identifiers. ### How it is used Common usage includes running queries against SQL Server or Azure SQL, piping SQL into the CLI for scripts, creating local SQL Server containers with sqlcmd create mssql, and switching saved connection contexts stored under ~/.sqlcmd/sqlconfig. ### Why package nerds care Package nerds care about go-sqlcmd because it turns a historically vendor-installed database utility into a cross-platform package-manager CLI, bridging Windows SQL Server habits with Homebrew, Winget, Chocolatey, Linux packaging, and container-first local development. ### Timeline - 2021: go-sqlcmd repository created. - 2021: v0.0.5 and v0.1.0 preview releases published. - 2022: early releases add more compatibility switches. - Current README: documents package-manager installs and backward compatibility differences from ODBC sqlcmd. ### Related projects - go-sqlcmd is related to the original ODBC sqlcmd, Microsoft's go-mssqldb driver, SQL Server, Azure SQL Database, Azure Synapse, Docker or Podman local SQL Server workflows, and Azure Data Studio integration. ### Sources - - - - - input.source_facts.package-manager ## Security Notes broad file, network, media, or database tool signal. - **Geiger risk:** blue / medium - broad file, network, media, or database tool signal ## Configuration and credential file locations These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval. ## Configuration files - Unix: ~/.sqlcmd/sqlconfig ## Credential files - Unix: ~/.sqlcmd/sqlconfig ## Source Database Details - **Source Database:** Homebrew formula API - **Tap:** homebrew/core - **Full Name:** sqlcmd - **Version Scheme:** 0 - **Revision:** 0 - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** no - **URL Keys:** stable ## Other Package-Manager Records - Nix - sqlcmd: normalized package name match | nixpkgs package indexes: pkgs/by-name/sq/sqlcmd/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 - Chocolatey - sqlcmd: normalized package name match | Chocolatey community package catalog: sqlcmd from http://community.chocolatey.org/api/v2/Packages?$filter=IsLatestVersion&$select=Id&$top=1000&$skiptoken='11','sql2008r2.cmdline' - winget - Microsoft.Sqlcmd: normalized package name match | Windows Package Manager source index: Microsoft.Sqlcmd from https://cdn.winget.microsoft.com/cache/source.msix ## Related links - [Cloud CLI packages](https://www.automicvault.com/pkg/cloud-clis/) - Belongs to a cloud or infrastructure command family. - [Source-control packages](https://www.automicvault.com/pkg/source-control-tools/) - Belongs to a source-control command family. - [Secret-risk packages](https://www.automicvault.com/pkg/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals. - [Terminal utility packages](https://www.automicvault.com/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata. - [go](https://www.automicvault.com/pkg/brew/go/) - Build dependency declared by Homebrew. - [dbhash](https://www.automicvault.com/pkg/brew/dbhash/) - Shares av.db curated category or tags: cli, database, developer-tools. - [neonctl](https://www.automicvault.com/pkg/brew/neonctl/) - Shares av.db curated category or tags: cli, database, developer-tools. - [golang-migrate](https://www.automicvault.com/pkg/brew/golang-migrate/) - Shares av.db curated category or tags: cli, database, developer-tools, go. - [jet](https://www.automicvault.com/pkg/brew/jet/) - Shares av.db curated category or tags: cli, database, developer-tools, go. - [litecli](https://www.automicvault.com/pkg/brew/litecli/) - Shares av.db curated category or tags: cli, database, developer-tools. - [mongosh](https://www.automicvault.com/pkg/brew/mongosh/) - Shares av.db curated category or tags: cli, database, developer-tools. - [sqlboiler](https://www.automicvault.com/pkg/brew/sqlboiler/) - Shares av.db curated category or tags: cli, database, developer-tools, go. - [sqlc](https://www.automicvault.com/pkg/brew/sqlc/) - Shares av.db curated category or tags: cli, database, developer-tools, go. - [sqlx-cli](https://www.automicvault.com/pkg/brew/sqlx-cli/) - Local metadata places this package in an adjacent workflow. Shared terms: cli, command-line, database, developer, developer-tools. ## Combined YAML source View the package source record on GitHub. [combined/sqlcmd.yml](https://github.com/automic-vault/db/blob/main/combined/sqlcmd.yml) ## Sources - Nucleus package database - Geiger risk classifier - package-page enrichment - curated configuration and credential file locations - curated package history - package version freshness - av.db category and tag curation - package relationship graph - external package-manager database matches - cross-ecosystem install command graph - curated agent safety answer