# SQLitePilot

> Effortless remote SQLite administration over SSH.

- Canonical URL: https://sqlitepilot.com/
- Last updated: 2026-04-22

## Product Summary

SQLitePilot is a web-based application for managing remote SQLite databases through secure SSH connections. It provides a visual workflow for connecting, querying, editing, and auditing remote SQLite data from a browser.

## Security Model

- SQLitePilot generates a unique Ed25519 keypair for each connection.
- You copy only the generated public key to your server.
- Access can be revoked at any time by removing the key from `~/.ssh/authorized_keys`.
- Generated private keys are encrypted at rest.
- Network traffic is protected through SSH and HTTPS/TLS.

## Core Features

- Generated SSH Keys: Per-connection keypairs so you do not upload personal private keys.
- AI-Powered Queries: Describe intent in natural language and generate SQL.
- Inline Edits: Update records directly from the data table view.
- One-Click Download: Download remote SQLite databases for local analysis.
- Revocable Access: Remove the generated public key to cut access immediately.

## Pricing

- Free: EUR 0 forever, 1 key, 1 connection, < 1 MiB DB download.
- Solo: USD 59 one-time lifetime access, unlimited keys, unlimited connections, < 1 GiB DB download, priority support.
- Team: Coming soon.

## Quick Start

1. Create a connection in SQLitePilot.
2. Copy the generated public key.
3. Paste it into your server `~/.ssh/authorized_keys`.
4. Test the connection.
5. Start querying and managing your remote SQLite database.

## FAQ

### Is Solo a subscription plan?

No. Solo is a one-time purchase: USD 59 for lifetime access.

### Do I need to upload my private SSH key?

No. SQLitePilot generates a dedicated keypair per connection. You copy only the public key to your server.

### Can I revoke SQLitePilot access myself?

Yes. Remove the generated public key from `~/.ssh/authorized_keys` and access stops.

### Do I need a credit card to start?

No. The free plan does not require a credit card.

## Important Links

- Website: https://sqlitepilot.com/
- App: https://app.sqlitepilot.com/
- Support: https://app.sqlitepilot.com/support
- Blog: https://app.sqlitepilot.com/blog
- Terms: https://sqlitepilot.com/terms.html
- Privacy: https://sqlitepilot.com/privacy.html
- Contact: mailto:hello@sqlitepilot.com