mssql

# MSSQL Run SQL Server queries using `scripts/mssql_query.sh`. ## Quick start 1. Ensure credentials exist at: `~/.openclaw/credentials/mssql.env` 2. Run a query: `bash skills/mssql/scripts/mssql_query.sh --query "SELECT TOP 20 name FROM sys.tables"` 3. Save to file: `bash skills/mssql/scripts/mssql_query.sh --query "SELECT TOP 100 * FROM dbo.MyTable" --out /tmp/mytable.dsv` ## Credentials format Expected env vars in `~/.openclaw/credentials/mssql.env`: - `MSSQL_HOST` - `MSSQL_DB` - `MSSQL_USER` - `MSSQL_PASSWORD` - Optional: `MSSQL_PORT` (default `1433`), `MSSQL_ENCRYPT` (`yes`/`no`, default `yes`), `MSSQL_TRUST_CERT` (`yes`/`no`, default `no`), `SQLCMD_BIN` The credential file path can be overridden with the `MSSQL_ENV_FILE` environment variable. ## Permissions Query permissions are controlled entirely at the SQL Server user level. The script does not impose any restrictions on query type — the database user's grants determine what is allowed. ## Database reference map Place your database map at `references/DB_MAP.md` inside this skill folder. This file tells the agent which databases, schemas, and tables to use and how they relate to each other. See `references/DB_MAP.example.md` for the expected format. ## Useful patterns - Run long query from file: `bash skills/mssql/scripts/mssql_query.sh --file /path/query.sql --out /tmp/out.dsv` - Override database: `bash skills/mssql/scripts/mssql_query.sh --db OtherDB --query "SELECT TOP 10 * FROM dbo.Users"` - Change delimiter: `bash skills/mssql/scripts/mssql_query.sh --query "SELECT ..." --delim ","` - Increase timeout: `bash skills/mssql/scripts/mssql_query.sh --query "SELECT ..." --timeout 180` ## Output format Output is **delimiter-separated text**, not RFC 4180 CSV. Fields are not quoted or escaped. This works well for structured numeric and short-text data. If your columns contain embedded delimiters, quotes, or newlines, the output may be malformed — choose a delimiter that does not appear in the data, or post-process the output. ## Best practices - Prefer explicit columns over `SELECT *`. - Use `TOP` for exploratory samples. - Keep queries scoped to the user request. - Answer in business language by default; provide SQL details when requested. - Never print or expose credentials in responses. ## Troubleshooting - `sqlcmd not found` -> install sqlcmd v18+ or set `SQLCMD_BIN`. - TLS/certificate issues on internal networks -> set `MSSQL_TRUST_CERT=yes` in your credentials file. The default is `no` (certificate validation enabled).