To install SQLite on Windows 11, open Terminal and run winget install SQLite.SQLite, then open a new Terminal window and type sqlite3 --version. Or download sqlite-tools-win-x64 from sqlite.org, extract it to C:\sqlite, and add that folder to your Path environment variable. SQLite is a lightweight, file-based database that doesn’t need a server, which makes it perfect for learning SQL, prototyping apps, or inspecting database files.
When a project outgrows a single database file and needs a server several apps can share, SQL Server Express setup on Windows 10 walks through the free edition and its limits.

Method 1: Install with winget (Fastest)
- Right-click Start and choose Terminal.
- Run:
winget install SQLite.SQLite - Accept the source agreement if prompted.
- Close Terminal and open a new window so the updated PATH loads.
- Run
sqlite3 --version. You should see a version number such as 3.xx.x.
To update later, run winget upgrade SQLite.SQLite.
Is SQLite free?
Yes. SQLite is in the public domain and free for any use.
Method 2: Manual Install from sqlite.org
- Go to sqlite.org/download.html.
- Under Precompiled Binaries for Windows, download sqlite-tools-win-x64-(version).zip. It contains sqlite3.exe and related tools. (The separate sqlite-dll package is only needed by developers linking SQLite into their own programs.)
- Create a folder such as C:\sqlite.
- Right-click the ZIP, choose Extract All, and extract the files into C:\sqlite so sqlite3.exe sits directly in that folder.
Add SQLite to PATH
- Press Windows and search for Edit the system environment variables, then open it.
- Click Environment Variables.
- Under User variables, select Path and click Edit.
- Click New, type
C:\sqlite, and click OK on each window. - Open a new Terminal and run
sqlite3 --versionto confirm.
How do I uninstall SQLite?
Run winget uninstall SQLite.SQLite, or delete the C:\sqlite folder and remove it from PATH.
Create Your First Database
- In Terminal, go to a working folder:
cd $HOME\Documents - Create or open a database file:
sqlite3 test.db - Create a table:
CREATE TABLE notes (id INTEGER PRIMARY KEY, body TEXT); - Add a row:
INSERT INTO notes (body) VALUES ('Hello, SQLite'); - Query it:
SELECT * FROM notes; - Type
.tablesto list tables,.helpfor commands, and.quitto exit.
The whole database lives in test.db, so you can copy, back up, or share it like any other file.
To practice on that table, try SELECT DISTINCT with more than one column and compare the row counts.
Optional: GUI Tools
- DB Browser for SQLite (free, open source) lets you browse tables, edit data, and run queries visually. Install it with
winget install DBBrowserForSQLite.DBBrowserForSQLiteor from its official site. - VS Code has SQLite extensions for viewing databases inside the editor.
- Python includes the
sqlite3module, so you can use SQLite from scripts with no extra install.
If sqlite3 won’t run
- “sqlite3 is not recognized”: open a new Terminal after changing PATH, and make sure the folder you added contains sqlite3.exe directly (not in a subfolder).
- winget not found: update App Installer from the Microsoft Store.
- Windows SmartScreen warning: make sure you downloaded from sqlite.org, then choose More info > Run anyway if needed.
- “Database is locked”: close other programs using the same file, such as a GUI browser.

Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker’s official documentation. More about Kermit.