SqlGuard v1.0.0

SqlGuard v1.0.0

First stable release of SqlGuard — A deterministic, CI-first CLI tool for SQL Server contract testing and validation.

What's New

Core Commands

• version — Display version information
• validate-spec — Validate spec file syntax and configuration
• run — Execute validation checks against SQL Server
• snapshot — Capture database state baseline
• compare — Compare baselines for regression detection

Check Types

• Query Contracts — Validate result shapes (columns, types, nullability) and expected data
• Invariants — Assert database state with operators: rowCount, exists, notExists, isEmpty, isNotEmpty, scalar
• Permissions — Verify effective permissions for principals (EXECUTE, SELECT, INSERT, UPDATE, DELETE)

Key Capabilities

• Deterministic execution with consistent, reproducible results
• Fixture support with setup/teardown scripts
• Baseline snapshots for deployment validation
• Self-contained executables (Windows and Linux)
• Commercial licensing with file-based license discovery
• Clear exit codes (0=success, 1=failure, 2=config error, 3=execution error)

Platform Support

• Windows (win-x64)
• Linux (linux-x64)
• SQL Server 2019+

Installation

Download the appropriate binary for your platform:

Windows:
powershell curl -LO https://github.com/sqlguard-xtc/sqlguard/releases/download/v1.0.0/sqlguard-v1.0.0-win-x64.exe

Linux:
bash curl -LO https://github.com/sqlguard-xtc/sqlguard/releases/download/v1.0.0/sqlguard-v1.0.0-linux-x64 chmod +x sqlguard-v1.0.0-linux-x64

Verify integrity using SHA256 checksums provided in the release assets.

Checksums

a4ba0d1262d8f1ad0685a034c703757a71adba6dff47d7b665dedccc91227d67 sqlguard-v1.0.0-win-x64.exe 49f07af9d935f2f533206c546047dacf79adbdd4f65d01461d1c252f7b8ed3d9 sqlguard-v1.0.0-linux-x64

Documentation

• Getting Started
• Spec Format v1.0
• Examples
• CHANGELOG

Full Changelog

For complete details, see CHANGELOG.md