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.

lalitmaganti Updated
The syntaqlite playground: a query with a typo in a column name, its formatted output, and the error "unknown column 'nme'" with the suggestion "did you mean 'n

File contents

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.

lalitmaganti/syntaqlite commit 54efbecaa0

Frequently asked questions

npx get-skill add lalitmaganti/validate