SQLite CLI Overview
Understand what the sqlite3 shell is, when to use it, and how SQL statements differ from dot commands.
Opening a Database
Learn how to open an existing SQLite database file from the CLI and confirm which file is currently active.
Creating a New Database
Create a brand-new SQLite database file from the CLI and verify that the file is created correctly.
SQLite Dot Commands
Use dot commands to inspect databases, configure output, and control sqlite3 shell behavior efficiently.
Viewing Tables
List tables in the current SQLite database and understand why .tables output can sometimes look empty.
Viewing Schema
Inspect table definitions with .schema so you can understand structure before writing data queries.
Importing Data
Import CSV data into SQLite from the CLI using .mode and .import, then validate row counts.
Exporting Data
Export query results or full tables from SQLite CLI into CSV files using output mode and redirection commands.
Exiting the CLI
Exit sqlite3 cleanly using .quit or keyboard shortcuts and understand what happens to your current session.