SQLite Runner LSP

A very simple VSCode extension (and LSP) that validates SQL files by running them against a temporary SQLite database in real-time.

Tested on Linux with SQLite 3.51-3.53 (2026-04). Should also work on Windows and MacOS - feedback welcome.

Install

From the VSCode Marketplace here or from Open VSIX here.

Usage

1. You need to have sqlite3 as a global executable available in your $PATH.
2. Open any .sql or .sqlite file
3. Start writing SQL statements
4. Errors will appear inline as you type

Each validation run creates a fresh temporary database, so you can test CREATE TABLE statements and other DDL without conflicts.

The script is internally prefixed with PRAGMA foreign_keys = "ON"; so foreign key errors will show by default.

There are no configurable options.

Development for VSCode extension

Run npm i and then launch Client + Server