Skip to main content
SQLite is a lightweight, self-contained relational database engine where an entire database lives in a single file. With BonData, you can upload a SQLite database file to read, enrich, and act on its data within Agent workflows.

​
Database Connection

Because SQLite is file-based, there is no server to connect to. Instead of connection credentials, you provide the database file itself, which BonData reads and stores securely.

​
Step 1: Prepare Your Database File

  1. Locate your SQLite database file - typically with a .sqlite, .db, or .sqlite3 extension
  2. Make sure the file contains the tables you want to work with
  3. Confirm the file is not currently locked by another process (close any application writing to it)
BonData reads SQLite databases in read-only mode. Uploading a file never modifies your original database.

​
Step 2: Upload the File

  1. In BonData, navigate to Integrations and select SQLite
  2. Click Upload and select your database file
  3. Wait for the upload to complete - BonData stores the file securely and inspects its schema

​
Step 3: Review Discovered Tables

Once uploaded, BonData reads the database schema and lists the available tables and their row counts. You can then select the tables you want to sync.
BonData discovers tables directly from the database’s internal catalog, so no manual schema definition is required. Internal sqlite_* system tables are excluded automatically.

​
Required Fields

​
Available Data

Once uploaded, BonData can sync:
  • Tables - All tables in the uploaded database
  • Views - Views defined within the database
  • Custom Queries - Run custom SQL queries to extract specific data