> ## Documentation Index
> Fetch the complete documentation index at: https://docs.bondata.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# SQLite

> Connect BonData to SQLite by uploading your database file

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)

<Note>
  BonData reads SQLite databases in read-only mode. Uploading a file never modifies your original database.
</Note>

### 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.

<Tip>
  BonData discovers tables directly from the database's internal catalog, so no manual schema definition is required. Internal `sqlite_*` system tables are excluded automatically.
</Tip>

## Required Fields

| Field         | Description                                                          |
| ------------- | -------------------------------------------------------------------- |
| Database File | The SQLite database file to upload (`.sqlite`, `.db`, or `.sqlite3`) |

## 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