Levirge DevOps · connector

SQLite

Query SQLite database files behind a firewall through an outbound agent, with saved queries, query history and an audit log.

Verified

Verified means run through the app against a real system. In testing means the UI and agent support exist, but it has not been checked against real systems yet. Levirge DevOps is in private testing, with no public agent download yet.

Features

Feature Status
Connect to a database file on a remote machine Verified
Run SQL queries Verified
Save and recall queries Verified
Query history, per connection Verified
Audit log of queries Verified
Browse tables and columns In testing
View a table's DDL In testing
Export results as CSV, JSON or XLSX In testing

Capabilities

  • Connects to SQLite files on the machine where the agent runs.
  • WAL-mode databases are supported.
  • Each database file is its own connection in the sidebar.
  • Blob values are shown as 0x… hex strings.

Limits

  • The agent's user must be able to read the database file.
  • One statement per query: multi-statement SQL returns an error.
  • Exports cover the rows already fetched, so add a LIMIT for large tables.
  • Files over 2 GB can be slow on unindexed full-table scans.
  • Databases held under an exclusive lock may show stale reads during concurrent writes.