Knowledge Base

How to connect to SQLite from the command line

This article describes how to connect to SQLite from the command line using the sqlite3 program. You can use the sqlite3 program as a quick and easy way to access SQLite databases directly.

Connecting to SQLite from the command line

To connect to SQLite from the command line, follow these steps:

  1. Log in to your A2 Hosting account using SSH.
  2. At the command line, type the following command, replacing example.db with the name of the database file that you want to use:
    sqlite3 example.db
    The database filename can be anything you want. If the database file does not exist, SQLite creates it. If the database file already exists, SQLite opens the database contained in the file.
  3. After you access a database, you can use regular SQL statements to run queries, create tables, insert data, and more. Additionally:

    • To display a current list of tables in the database, type the following command at the sqlite> prompt:
      .tables
    • To view the structure of a table, type the following command at the sqlite> prompt. Replace table with the name of the table that you want to view:

      .schema table
    • To view a complete list of sqlite3 commands, type .help at the sqlite> prompt.
    • To exit the sqlite3 program, type .quit at the sqlite> prompt.

More Information

  • To view information about the sqlite3 program from the command line, type the following command:
    man sqlite3
  • To view the SQLite online documentation for the sqlite3 program, please visit https://www.sqlite.org/cli.html.