Validate

Validate SQL

Validate SQLite SQL and report diagnostics (errors, warnings) using the syntaqlite CLI.

Usage

# Validate a file
syntaqlite analyze query.sql

# Validate from stdin
echo "SELECT * FORM t" | syntaqlite analyze

# Validate an inline expression
syntaqlite analyze -e "SELECT 1 + "

# Validate against a schema
syntaqlite analyze --schema schema.sql query.sql

# Validate multiple files via glob
syntaqlite analyze "**/*.sql"

# Validate with multiple schema files
syntaqlite analyze --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.