1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
# sscli configuration example
#
# Quick setup:
# 1) Copy this file to `.sql-server/config.yaml` (or point SQL_SERVER_CONFIG at it)
# 2) Export the password env var(s) referenced by `passwordEnv`
# 3) Run: `sscli status`
#
# Notes:
# - `.sql-server/` is gitignored by default to avoid committing secrets.
# - Prefer `passwordEnv` over `password`.
defaultProfile: default
settings:
output:
# Output format when no explicit flag is used.
# Values: pretty | markdown | json
defaultFormat: pretty
json:
# Values: v1
contractVersion: v1
# Pretty-print JSON output.
pretty: true
csv:
# CSV naming when multiple result sets are exported.
# Values: suffix-number | placeholder
multiResultNaming: suffix-number
profiles:
# Default local/dev profile.
default:
server: localhost
port: 1433
database: master
user: sa
passwordEnv: SQL_PASSWORD
password: null
encrypt: true
trustCert: true
timeout: 30000
defaultSchemas:
# Example second profile:
# staging:
# server: staging-sql.example.com
# port: 1433
# database: app
# user: app_readonly
# passwordEnv: STAGING_SQL_PASSWORD
# encrypt: true
# trustCert: false
# timeout: 30000
# defaultSchemas: [dbo]