LinkIt SQL: query
queryExecute read-only SELECT/WITH queries on any LinkIt SQL environment with automatic result capping and secure credentials. Prevents destructive operations.
Instructions
Run a READ-ONLY SELECT/WITH query against a LinkIt SQL Server env. INSERT/UPDATE/DELETE/DDL/EXEC are blocked. Results are auto-capped (maxRows default 50, max 500) with truncation hints; set countTotal for COUNT(*).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| env | Yes | Target env: internal | staging | uat | preprod | prod | au (always explicit, no default) | |
| sql | Yes | Single SELECT or WITH...SELECT statement | |
| action | No | select | select |
| maxRows | No | Max rows returned (default 50, max 500) | |
| database | No | Override the env default database | |
| trimChars | No | Trim long text cells at N chars (default 500) | |
| countTotal | No | Also run COUNT(*) over the query (default false; can be slow on huge scans) |