sqlite
Installation
SKILL.md
Identity
- Binary:
sqlite3 - No service: SQLite is embedded — there is no daemon, no port, no systemd unit
- Database: a single file on disk (e.g.
/var/lib/myapp/data.db) - Distro install:
apt install sqlite3/dnf install sqlite
Key Operations
| Operation | Command |
|---|---|
| Open a database file | sqlite3 /path/to/db.sqlite3 |
| Help (dot-command list) | .help |
| List tables | .tables |
| Show CREATE statements | .schema or .schema <table> |
| Show column info | PRAGMA table_info(<table>); |
| Column-aligned output | .mode column |
| Table-style output | .mode table |
| JSON output | .mode json |
| CSV output | .mode csv |
Related skills