Getting started

Choose how you want to use syntaqlite, then follow the guide for your setup.

Quick taste

Install the CLI (or try it in the browser first):

brew install LalitMaganti/tap/syntaqlite

curl --proto '=https' --tlsv1.2 -LsSf \
  https://github.com/LalitMaganti/syntaqlite/releases/latest/download/syntaqlite-cli-installer.sh \
  | sh

powershell -ExecutionPolicy ByPass -c "irm https://github.com/LalitMaganti/syntaqlite/releases/latest/download/syntaqlite-cli-installer.ps1 | iex"

cargo install syntaqlite-cli

Format a query:

echo "select id,name from users where active=1 and role='admin'" | syntaqlite fmt

SELECT id, name
FROM users
WHERE active = 1
  AND role = 'admin';

Catch a schema error:

echo "CREATE TABLE users (id, name, email); SELECT nme FROM users;" | syntaqlite validate

error: unknown column 'nme'
 --> stdin:1:43
  |
1 | ...; SELECT nme FROM users;
  |             ^^^
  |
  = help: did you mean 'name'?

That's the core loop: syntaqlite reads your CREATE TABLE statements to build a schema, then validates queries against it — no database required.