spatialite(1)

✨ NAME ✨

okay so bestie, welcome to spatialite — the CLI backend for SpatiaLite 💅 it's the little command-line door you walk through to talk to your SpatiaLite databases, and honestly? it ate.

---

🌸 SYNOPSIS 🌸

spatialite [OPTIONS] FILENAME [SQL]

like. you give it a file, you give it some options maybe, you give it some SQL if you're feeling spicy. that's the whole vibe. 🦋

---

💖 DESCRIPTION 💖

spatialite is a CLI backend for SpatiaLite. that's it, that's the description, no cap. it's a command-line interface that hooks you up with SpatiaLite and lets you run your little SQL statements against a database file. main character energy fr. 👑

---

🎀 OPTIONS 🎀

bestie there are so many options and I am listing every single one of them, no skipping, we don't do that here 💅

• -bail — hit an error? we're DONE. stop right there. 💀
• -batch — force batch I/O, like, no chatting, just doing.
• -column — sets the output mode to 'column', cute little columns ✨
• -cmd command — run command before it starts reading from stdin, a little warm-up before the main event 🫶
• -csv — set output mode to 'csv', commas everywhere, iconic
• -echo — prints your commands before executing them, so you can see your own work, love that for you
• -init filename — read and process the named filename, get it together bestie
• -[no]header — turn headers on or off, your call, you're in charge here 👑
• -help — show the help message, when you're lost, which, same
• -html — set output mode to HTML, serving looks in markup form 💅
• -interactive — force interactive I/O, let's talk about it 🌸
• -line — set output mode to 'line', one line at a time, very put-together
• -list — set output mode to 'list', classic, timeless, no notes
• -multiplex — enable the multiplexor VFS, but ONLY if support is built in, don't assume, check first 🙈
• -nullvalue 'text' — set the text string that shows up for NULL values, so they don't just ghost you 😭
• -separator 'x' — set the output field separator (the default is |, just so you know) ⭐
• -stats — print memory stats before each finalize, numbers girlies rise 🌈
• -version — show the SQLite version, bc knowing is half the battle
• -vfs NAME — use NAME as the default VFS, pick your fave
• -vfstrace — enable tracing of all VFS calls, again only if support is built in, don't come for me if it's not there 🧚

---

ngl, those last two? -multiplex and -vfstrace? they only work if support is built in. so like, vibe check your build first bestie, or you'll be standing there confused. 💜

---

and that's the whole page, we did it, we made it to the end 🎀 this was spatialite(1), the CLI backend for SpatiaLite, and this little doc is dated 9 February 2026 — that's the version and the date bestie, noted, archived, slay. bye bye, go run some SQL 💖🦋✨