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.
Informations de source
- Dépôt
- LalitMaganti/syntaqlite
- Dernière activité de la source
- 15 août 2026 à 16:28
- Langue détectée de SKILL.md
- anglais
- Étoiles
- 823
- Forks
- 16
Options d'installation
Le prompt qui vérifie d'abord la source est sélectionné par défaut. Vous pouvez passer à une commande directe ou télécharger une copie locale.
Vérifiez les fichiers source
Lisez SKILL.md et les fichiers associés affichés par SkillsMP avant de décider de l'installer.
Affichage de SKILL.md
SKILL.md
Instructions source · Aperçu en lecture seule- 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.
Voir sur GitHub