How to get column names with query data in sqlite3? July 31, 2023 by Tarik Yes, after logged into sql prompt mode, execute the following each at a time: .header on .mode column