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. Add your SSH key

1. Go to Keys.
2. Click Add new key and paste the private key that already works with your server. Keep the BEGIN and END lines when you copy it.
3. Give the key a helpful name so you can find it later.

Read more at How to Prepare and Upload Your SSH Key.

2. Create a connection

1. Go to Connections.
2. Choose Add new connection.
3. Enter the server address, SSH username, database file path, and the key you just uploaded, then save.

Read more at Create Your First Connection.

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.