How to Install SQLite on Windows 10

SQLite is a small, fast database engine that stores an entire database in a single file. There’s no server to set up and nothing running in the background, which makes it perfect for learning SQL, testing apps, or managing small data projects. On Windows 10, “installing” SQLite just means downloading the command-line tools and adding them to your Path.

Microsoft ended Windows 10 support on October 14, 2025, so a PC without Extended Security Updates no longer receives security fixes; that program runs until October 12, 2027.

This guide takes about five minutes. It covers the manual install, a one-line winget option, your first database, importing a spreadsheet, and fixes for common errors.

How to Install SQLite on Windows 10

Download the command-line tools

Go to the official SQLite download page and scroll to Precompiled Binaries for Windows. Download the sqlite-tools-win-x64 ZIP file (for example, sqlite-tools-win-x64-3540000.zip for version 3.54.0). This bundle includes the sqlite3 command-line shell plus sqldiff and sqlite3_analyzer. The separate “sqlite-dll” files are only needed by programmers building apps.

Extract the files

Create a folder called C:\sqlite. Right-click the ZIP, choose Extract All, and extract the files into that folder. You should see sqlite3.exe inside.

Add SQLite to your Path

1. Search Start for Edit the system environment variables and open it.
2. Click Environment Variables.
3. Under System variables, select Path and click Edit.
4. Click New, enter C:\sqlite, and click OK on every window.

If you can’t find these windows, the walkthrough on setting environment variables in Windows 10 shows each one.

Verify the installation

Open a new Command Prompt window and type sqlite3 --version. You should see the version number. Type sqlite3 on its own to open the interactive shell, and .quit to leave it.

Install SQLite with winget

If you have the App Installer from the Microsoft Store, open Command Prompt and run winget install SQLite.SQLite. Winget downloads the tools and updates your Path. Close and reopen Command Prompt before testing.

Create Your First Database

1. In Command Prompt, go to the folder where you want the database, such as cd %USERPROFILE%\Documents.
2. Run sqlite3 shop.db. SQLite creates the file the first time you save data.
3. Create a table: CREATE TABLE products (id INTEGER PRIMARY KEY, name TEXT, price REAL);
4. Add a row: INSERT INTO products (name, price) VALUES ('Mouse', 19.99);
5. Query it: SELECT * FROM products;

Useful shell commands include .tables to list tables, .schema to show table definitions, and .mode table for neatly formatted output.

Import a CSV File

SQLite can load data straight from a spreadsheet saved as CSV. Open your database with sqlite3, then run .import --csv C:/data/sales.csv sales. If the table doesn’t exist yet, SQLite creates it and uses the first row of the file as column names. Forward slashes in the file path avoid escaping problems. To export query results back out, switch to CSV mode with .mode csv, send output to a file with .output results.csv, and run your SELECT.

When Should You Use SQLite?

SQLite is ideal when one program or one person works with the data at a time: desktop apps, prototypes, data analysis, small websites and learning SQL. Because the whole database is one file, backing it up is as simple as copying that file. For a busy website or an app where many users write data at the same time, a client-server database such as SQL Server, MySQL or PostgreSQL is a better fit. If a small website built on it starts getting real traffic, you can set up JMeter on Windows 10 to see how it holds up under load.

Prefer a Graphical Tool?

If you’d rather click than type, free tools such as DB Browser for SQLite let you create tables, browse data and run queries in a window. They work with the same .db files the command-line shell creates.

Troubleshooting

• “sqlite3 is not recognized.” The folder isn’t on your Path, or you’re using an old Command Prompt window. Check the Path entry and open a new window.
• Windows SmartScreen blocks sqlite3.exe. Click More info > Run anyway if you downloaded it from sqlite.org. You can also right-click the ZIP, choose Properties and check Unblock before extracting.
• “Unable to open database file.” You don’t have write permission in that folder. Use a folder under your user profile, such as Documents.
• Commands seem to do nothing. SQL statements must end with a semicolon. Dot commands like .tables don’t need one.
• Wrong version shows up. Another program installed its own sqlite3.exe earlier in your Path. Move C:\sqlite higher in the list.

Frequently Asked Questions

What is SQLite used for?

It’s built into browsers, phones and countless apps, and it’s popular for prototypes, small websites, data analysis and learning SQL.

Do I need admin rights to install SQLite?

Only to edit the system Path. You can add the folder to your user Path instead, or run sqlite3.exe directly from its folder without changing anything.

How do I update SQLite?

Download the newer tools ZIP and replace the files in C:\sqlite, or run winget upgrade SQLite.SQLite.

Is SQLite free?

Yes. SQLite is in the public domain and free for any use.

Does this work on Windows 11?

Yes, the steps are the same.

Wrapping Up

Download the sqlite-tools ZIP from sqlite.org, extract it to C:\sqlite, add that folder to your Path, and run sqlite3 –version to confirm. If you outgrow a single file and need a full database server, you can install SQL Server on Windows 10.