libSQL / Turso with DBine
How to connect DBine to libSQL / Turso and what you can do once it's connected. This page is written from what the libSQL / Turso driver says about itself, so it matches the version of DBine you download.
Connect
- In DBine, open New connection.
- Pick libSQL / Turso in the list of engines.
- Fill in the fields below, press Test connection and then Save.
Default port: 8080.
General
| Field | Description |
|---|---|
| Database URL required | Turso: turso db show <base> --url. For a local file use the SQLite connection. Example: libsql://mydb-myorg.turso.io or http://localhost:8080 |
| Token | Turso: turso db tokens create <base>. Empty if the server doesn't require authentication. Kept in the system keychain, never in DBine's files. |
| Read-only | On or off. |
SSH tunnel. The connection can go through an SSH server, even through a chain of bastions, with a password, a private key or the SSH agent. The server's fingerprint is checked against known_hosts or confirmed the first time.
What the explorer shows
The objects appear right under the connection:
- Tables
- Virtual tables
- Views
- Triggers
Query editor
The editor uses SQL, with completion for the connection's objects. Statements and commands run against the database selected in the tab.
Ready-made templates for new objects:
- New view
- New trigger
Tools for libSQL / Turso
Available
- Graphical execution plans
- Server monitor
- Manual transactions (commit and rollback)
- Index usage
- Database properties
- Relations in the ER diagram
- Visual designer for new objects
- Rename objects
- Compare and sync schemas
- Native bulk load when migrating data
Not available for libSQL / Turso
- Live query profiler
- Sessions and running queries
- End a session
- Locks: who blocks whom
- Cancel another session's query from the sessions list
- Create databases
- Drop databases
- Clone tables
- Users and permissions
- Backups
Why a tool doesn't apply to an engine, and the details of each one, are in the engine support reference.
Generated from the libSQL / Turso driver 0.1.12, which DBine downloads the first time you connect to libSQL / Turso.