Microsoft SQL Server
Connect to a Microsoft SQL Server (MSSQL) database using an ADO.NET connection string.
Usage
sql-studio mssql <CONNECTION>Arguments
| Argument | Description |
|---|---|
CONNECTION | ADO.NET connection string |
Connection String Format
Server=tcp:localhost,1433;Database=mydb;User Id=sa;Password=YourPassword;TrustServerCertificate=trueNotes
- SQL Studio uses the Tiberius driver with
rustlsfor TLS. - Set
TrustServerCertificate=truefor local development with self-signed certificates.
Examples
# Connect to a local MSSQL instance
sql-studio mssql "Server=tcp:localhost,1433;Database=sample;User Id=sa;Password=YourStrong@Passw0rd;TrustServerCertificate=true"