Getting Started with SQLitePilot

SQLitePilot lets you open a secure tunnel to a remote server, browse tables, and run SQL without leaving your browser. Follow these three steps the first time you sign in.

1. Create a connection

1. Go to Connections.
2. Choose Add new connection.
3. Enter the server address, SSH username, and database file path, then save.
4. SQLitePilot generates a unique Ed25519 keypair for this connection and shows you the public key.

Read more at Grant SQLitePilot SSH Access.

2. Install the generated public key

1. SSH into your server.
2. Append the generated public key to ~/.ssh/authorized_keys.
3. Back in SQLitePilot, click Test Connection.

Read more at Grant SQLitePilot SSH Access.

3. Connect and explore

1. Return to the Dashboard.
2. Pick your connection from the dropdown and click Connect.
3. Once it says “Connected,” open the Schema, Tables, or SQL panels to browse data or run queries.

Read more at Explore Schema and Table Data

That is all you need to reach a remote SQLite database through SQLitePilot. Explore the other guides in this library if you want deeper knowledge for each step.