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/syntaqlite
- 最近来源活动
- 2026年8月15日 16:28
- 检测到的 SKILL.md 语言
- 英语
- 星标
- 823
- 分支
- 16
安装方式
默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。
检查来源文件
决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。
正在显示 SKILL.md
SKILL.md
来源说明 · 只读预览- 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.
在 GitHub 查看