TigerQuery documentation
TigerQuery is a lightweight SQL script engine and parser with familiar
sqlcmd and SSMS SqlCmd-mode behavior. Its defining SqlCmdEx mode adds
protected application-provided variables for automation and embedded tooling.
Companion packages add named SQL Server connection profiles and reusable
connection-management commands for TigerCli applications.
tiger-sqlcmd is the first-class command-line product built on those components. It uses
TigerCli's One Command Model, Multiple Interaction Modes: the same commands serve
guided semi-interactive runs and automation-safe
--non-interactive execution.
Start with TigerSqlCmd interaction modes and usage, or use the separate
TigerSqlCmd E2E scenarios guide for safe unattended database
lifecycle automation.
TigerSqlCmd task guides
- Install TigerSqlCmd and manage saved connections
- Use the same commands non-interactively in scripts, CI, jobs, and agents
- Run SQL with explicit per-batch command timeouts
- Route SQL results and messages
- Pass a resolved saved connection to an external tool with
exec - Create, use, clone, and safely clean session-scoped E2E resources
- Provision an E2E database for memory-optimized tables
This site combines a short guide with API documentation generated from the libraries' C# source and XML documentation comments.
Tip
SqlCmdEx is controlled scripting for applications. It keeps familiar
sqlcmd syntax, but a script cannot replace host-provided variables with
:setvar. Non-conflicting script-local variables continue to work. See
SqlCmd and SqlCmdEx for the comparison and
a complete example.
Important
TigerQuery supports two execution modes. Streaming execution is the memory-efficient default and may discover a late directive error after earlier batches have run. Prepared execution parses the entire TigerQuery/sqlcmd structure before opening the connection or executing SQL. See Prepared versus streaming execution before choosing a mode.
Packages
| Package | Use it for |
|---|---|
| ItTiger.TigerQuery | Parsing and executing SQL scripts |
| ItTiger.TigerQuery.Core | Saving, validating, and resolving SQL Server connection profiles |
| ItTiger.TigerQuery.CliCore | Adding connection-management commands to a TigerCli application |
| ItTiger.TigerSqlCmd | Running SQL and managing saved connections from a shell, CI job, pipeline, or coding agent |
Start with Getting started, or browse the API reference.
For the E2E architecture and safety contract behind the operational guide, see E2E connection stores and database lifecycle.