Microsoft SQL Server
Overview
Microsoft SQL Server is a relational database engine for enterprise workloads. It provides T-SQL, columnstore indexes, in-memory OLTP, Always On availability groups, and integrated analytics. SQL Server is available on-premises, on Azure SQL Database, Azure SQL Managed Instance, and Amazon RDS.
Driver
- Crate:
tiberius - Version:
0.12
Connection fields
| Field | Description |
|---|---|
| Host | Hostname or IP address of the SQL Server instance. |
| Port | TCP port the server listens on. |
| Database | Name of the database to connect to. |
| User | SQL Server authentication username. |
| Password | Authentication password. Stored in the macOS Keychain. |
| SSL Mode | One of disable, prefer, require, verify-ca, or verify-full. |
| Options | Additional connection parameters as key1=val1&key2=val2. |
All connections also support an optional SSH tunnel. Configure the bastion host, port, user, and private key file under the SSH section of the connection form. SeeSSH tunnels for details.
URI format
Instead of filling in each field individually, you can paste a connection URI into thePaste URI field. Arris parses the URI and populates all fields automatically.
mssql://user:password@host:1433/dbname?encrypt=trueSSL & TLS
SQL Server supports five SSL modes. Arris defaults to prefer, which uses SSL if the server supports it but falls back to unencrypted if not.
| SSL Mode | Behavior |
|---|---|
disable | Never use SSL. Not recommended for production. |
prefer | Use SSL if available, fall back to unencrypted. |
require | Always use SSL. Fail if the server does not support it. |
verify-ca | Require SSL and verify the server certificate against a CA. |
verify-full | Require SSL, verify the CA, and verify the server hostname matches the certificate. |
Schema browser
Once connected, Arris fetches the schema tree from system catalog views and organizes it into groups. The default schema filter is set to dbo, but you can add or remove schemas from the filter dropdown in the sidebar.
The schema tree displays the following object types, grouped by category:
- Tables — regular tables
- Views — views
- Routines — functions and stored procedures
- Sequences — sequences
- Types — user-defined types
- Triggers — table-level triggers
- Indexes — clustered and non-clustered indexes
Double-click any table or view to open it in a new tab with browse mode.
Supported SQL commands
| Command | Notes |
|---|---|
SELECT | Query data with WHERE filters, JOINs, aggregates, and window functions. |
INSERT | Insert single or multiple rows. |
UPDATE | Update existing rows. |
DELETE | Delete rows. |
CREATE / DROP | Create and drop tables, views, and other schema objects. |