Skip to main content

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.

Source facts

Repository
LalitMaganti/syntaqlite
Last source activity
August 15, 2026 at 16:28
Detected SKILL.md language
English
Stars
823
Forks
16

Install options

The review-first prompt is selected by default. You can switch to a direct command or download a local copy.

Review the source files

Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.

Showing SKILL.md

SKILL.md
Source instructions · Read-only preview
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 SQL Validate SQLite SQL and report diagnostics (errors, warnings) using the syntaqlite CLI. ## Usage ```bash # 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.
View on GitHub