validate
Validate SQL and report diagnostics using syntaqlite. Use when the user wants to check SQL for errors, lint SQL files, or verify correctness against a schema.
Best use case
validate is best used when you need a repeatable AI agent workflow instead of a one-off prompt.
Validate SQL and report diagnostics using syntaqlite. Use when the user wants to check SQL for errors, lint SQL files, or verify correctness against a schema.
Teams using validate should expect a more consistent output, faster repeated execution, less prompt rewriting.
When to use this skill
- You want a reusable workflow that can be run more than once with consistent structure.
When not to use this skill
- You only need a quick one-off answer and do not need a reusable workflow.
- You cannot install or maintain the underlying files, dependencies, or repository context.
Installation
Claude Code / Cursor / Codex
Manual Installation
- Download SKILL.md from GitHub
- Place it in
.claude/skills/validate/SKILL.mdinside your project - Restart your AI agent — it will auto-discover the skill
How validate Compares
| Feature / Agent | validate | Standard Approach |
|---|---|---|
| Platform Support | Not specified | Limited / Varies |
| Context Awareness | High | Baseline |
| Installation Complexity | Unknown | N/A |
Frequently Asked Questions
What does this skill do?
Validate SQL and report diagnostics using syntaqlite. Use when the user wants to check SQL for errors, lint SQL files, or verify correctness against a schema.
Where can I find the source code?
You can find the source code on GitHub using the link provided at the top of the page.
SKILL.md Source
# Validate SQL Validate SQLite SQL and report diagnostics (errors, warnings) using the syntaqlite CLI. ## Usage ```bash # Validate a file syntaqlite validate query.sql # Validate from stdin echo "SELECT * FORM t" | syntaqlite validate # Validate an inline expression syntaqlite validate -e "SELECT 1 + " # Validate against a schema syntaqlite validate --schema schema.sql query.sql # Validate multiple files via glob syntaqlite validate "**/*.sql" # Validate with multiple schema files syntaqlite validate --schema "migrations/*.sql" --schema extra.sql query.sql ``` ## Options - `-e, --expression <SQL>` — Validate an inline SQL expression instead of files - `--schema <FILE>` — Schema DDL file to load before validation (repeatable, supports globs) - `--experimental-lang <LANG>` — Extract embedded SQL from host language files (`python`, `typescript`) ## Notes - Without `--schema`, validation checks syntax only. With `--schema`, it also checks table/column references. - Exit code is 0 if valid, non-zero if errors are found. - For continuous validation while editing, the LSP server provides real-time diagnostics automatically.
Related Skills
parse
Parse SQL and inspect the AST using syntaqlite. Use when the user wants to see the parse tree, debug SQL syntax, or understand how a query is structured.
format
Format SQL files using the syntaqlite formatter. Use when the user wants to format, reformat, or pretty-print SQL code.
run-tests
Run tests to verify correctness after code changes. Use when the user asks to run tests, verify changes, or check that things still work. Runs Rust unit tests and integration tests.
run-codegen
Regenerate all generated code from .synq definitions and SQLite grammar. Use when .synq files, grammar actions, or dialect definitions have been modified and generated C/Rust code needs updating.
release
Bump version, commit, tag, and create a draft GitHub Release. Use when the user
debug-formatter
Debug a SQL formatter bug. Use when the user reports incorrect formatting output — wrong whitespace, misplaced comments, blank lines, etc.
cpfast
Quickly commit and push current changes to a feature branch and create a PR, skipping pre-push checks. WARNING: if CI starts failing, use /cp instead.
cp
Commit all current changes, push to a feature branch, and create a PR. Use when the user asks to commit, push, save progress, or ship changes.
lint-and-validate
MANDATORY: Run appropriate validation tools after EVERY code change. Do not finish a task until the code is error-free.
deployment-validation-config-validate
You are a configuration management expert specializing in validating, testing, and ensuring the correctness of application configurations. Create comprehensive validation schemas, implement configurat
validate-trigger
Audit an existing Sim webhook trigger against the service's webhook API docs and repository conventions, then report and fix issues across trigger definitions, provider handler, output alignment, registration, and security. Use when validating or repairing a trigger under `apps/sim/triggers/{service}/` or `apps/sim/lib/webhooks/providers/{service}.ts`.
validate-integration
Audit an existing Sim integration against the service API docs and repository conventions, then report and fix issues across tools, blocks, outputs, OAuth scopes, triggers, and registry entries. Use when validating or repairing a service integration under `apps/sim/tools`, `apps/sim/blocks`, or `apps/sim/triggers`.