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.

Install

From the VSCode Marketplace here or from Open VSIX here.

Usage

• You need to have sqlite3 as a global executable available in your $PATH.
• Open any .sql or .sqlite file
• Start writing SQL statements
• 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.

There are no configurable options.

Development for VSCode extension

Run npm i and then launch Client + Server