Create Your First Connection

Connections tell SQLitePilot where your database lives and which key to use. After you set one up, it appears on the dashboard so you can connect with one click.

What to prepare

• One SSH key stored on the Keys page.
• The server address, SSH username, and the full path to the .db file (for example /var/www/app/data.sqlite).

Step 1: Open the page

1. Go to Connections.
2. If you still need a key, follow the link on the yellow banner to add one first.

Step 2: Start a new connection

1. Select Add new connection.
2. If you are on the free plan and already have one saved, you will see a blue notice explaining that you must delete the old one or upgrade before continuing.

Step 3: Fill in the details

1. Name: choose something clear like “Production orders.”
2. Server IP or hostname: the address you SSH into today.
3. SSH username: the account that owns the database file (often root, user, or deploy).
4. Database path: the full path to the SQLite file on the server (for example /home/deploy/apps/orders/db.sqlite or /root/data/analytics.db).
5. Platform: leave the suggested option unless support told you otherwise.
6. SSH Key: pick the entry you uploaded earlier.

The Save button becomes active once every field is filled out.

Step 4: Save and check the list

1. Click Save.
2. The dialog closes and the new connection appears in the table. Use the actions menu to edit or delete it later.

Step 5: Move to the dashboard

1. Open the Dashboard.
2. Select your new connection from the dropdown and click Connect to start browsing tables.

That is all it takes to give SQLitePilot a remote server to work with.