Grant SQLitePilot SSH Access

SQLitePilot now generates a unique Ed25519 SSH keypair for every new connection. You do not upload your own private key.

What you need

• SSH access to your server (terminal access with a user that can write ~/.ssh/authorized_keys).
• Your server host, SSH username, and SQLite file path.

Step 1: Create the connection in SQLitePilot

1. Open Connections.
2. Click Add new connection.
3. Fill in connection name, host, username, and database path.
4. Click Save.

After save, SQLitePilot shows the generated public key.

Step 2: Add the generated public key to your server

1. On your server, ensure the SSH directory exists:

mkdir -p ~/.ssh && chmod 700 ~/.ssh

2. Open ~/.ssh/authorized_keys in an editor (or create it).
3. Paste the generated public key from SQLitePilot on a new line.
4. Save the file and set safe permissions:

chmod 600 ~/.ssh/authorized_keys

Step 3: Test the connection

1. Return to Connections.
2. Click Test Connection in the setup panel.
3. If it fails with auth errors, re-check the exact key text and file permissions.

Quick checks

• Keep each key on its own line in authorized_keys.
• Do not add extra spaces before ssh-ed25519.
• Confirm you pasted the key for the same connection you are testing.

Once test succeeds, the connection is ready for schema browsing and SQL execution.