sqlite3

sqlite3 is the command-line shell for SQLite databases.

Exporting from db to csv

.mode csv
.header on
.output output.csv
SELECT * FROM table;
.quit

Source

sqlite.org — Command Line Shell

Imported Obsidian Notes

A terminal-based front-end to the SQLite library that can evaluate queries interactively and display the results in multiple formats.

Converting from other data type

csv

$ sqlite3 <filename>.db
sqlite3> .mode csv
sqlite3> .import <csv> <db name>