---
name: "spatialite"
section: "1"
platform: "linux"
package: "spatialite-bin"
version: "5.1.0a-2"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/spatialite"
---

# spatialite(1)

CLI backend for SpatiaLite

## NAME

spatialite - CLI backend for SpatiaLite

## SYNOPSIS

FC**spatialite**F\[0\]  \[*OPTIONS*\] *FILENAME* \[*SQL*\]

## DESCRIPTION

**spatialite** is a CLI backend for SpatiaLite.

## OPTIONS

- FC**-bail**F\[0\]

  stop after hitting an error

- FC**-batch**F\[0\]

  force batch I/O

- FC**-column**F\[0\]

  set output mode to 'column'

- FC**-cmd**F\[0\] *command*

  run *command* before reading stdin

- FC**-csv**F\[0\]

  set output mode to 'csv'

- FC**-echo**F\[0\]

  print commands before execution

- FC**-init**F\[0\] *filename*

  read/process named file

- FC**-\[no\]header**F\[0\]

  turn headers on or off

- FC**-help**F\[0\]

  show help message

- FC**-html**F\[0\]

  set output mode to HTML

- FC**-interactive**F\[0\]

  force interactive I/O

- FC**-line**F\[0\]

  set output mode to 'line'

- FC**-list**F\[0\]

  set output mode to 'list'

- FC**-multiplex**F\[0\]

  enable the multiplexor VFS (if support built in)

- FC**-nullvalue**F\[0\] '*text*'

  set text string for NULL values

- FC**-separator**F\[0\] '*x*'

  set output field separator (\|)

- FC**-stats**F\[0\]

  print memory stats before each finalize

- FC**-version**F\[0\]

  show SQLite version

- FC**-vfs**F\[0\] *NAME*

  use NAME as the default VFS

- FC**-vfstrace**F\[0\]

  enable tracing of all VFS calls (if support built in)