// 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.
| name | validate |
| description | 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. |
Validate SQLite SQL and report diagnostics (errors, warnings) using the syntaqlite CLI.
# 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
-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)--schema, validation checks syntax only. With --schema, it also checks table/column references.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.
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.
Debug a SQL formatter bug. Use when the user reports incorrect formatting output — wrong whitespace, misplaced comments, blank lines, etc.
Format SQL files using the syntaqlite formatter. Use when the user wants to format, reformat, or pretty-print SQL code.
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.
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.