sqlrite 1.0.2

RAG-oriented SQLite wrapper for AI agent workloads
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65

# Migrations

SQLRite can ingest existing SQLite-style datasets and exported vector-store data.

## Supported sources

| Source | Command |
|---|---|
| SQLite | `sqlrite migrate sqlite` |
| libSQL | `sqlrite migrate libsql` |
| pgvector JSONL | `sqlrite migrate pgvector` |
| Qdrant JSONL | `sqlrite migrate qdrant` |
| Weaviate JSONL | `sqlrite migrate weaviate` |
| Milvus JSONL | `sqlrite migrate milvus` |

## SQLite migration

```bash
sqlrite migrate sqlite \
  --source legacy.db \
  --target sqlrite.db \
  --doc-table legacy_documents \
  --doc-id-col doc_id \
  --chunk-table legacy_chunks \
  --chunk-id-col chunk_id \
  --chunk-doc-id-col doc_id \
  --chunk-content-col chunk_text \
  --chunk-embedding-col embedding_blob \
  --chunk-embedding-dim-col embedding_dim \
  --embedding-format blob_f32le \
  --batch-size 512 \
  --create-indexes
```

## libSQL migration

```bash
sqlrite migrate libsql --source libsql-replica.db --target sqlrite.db --create-indexes
```

## pgvector JSONL migration

```bash
sqlrite migrate pgvector \
  --input export.jsonl \
  --target sqlrite.db \
  --batch-size 512 \
  --create-indexes \
  --json
```

## API-first vector exports

```bash
sqlrite migrate qdrant --input qdrant_export.jsonl --target sqlrite.db --create-indexes
sqlrite migrate weaviate --input weaviate_export.jsonl --target sqlrite.db --create-indexes
sqlrite migrate milvus --input milvus_export.jsonl --target sqlrite.db --create-indexes
```

## Validate the migrated database

```bash
sqlrite doctor --db sqlrite.db --json
sqlrite query --db sqlrite.db --text "agent memory" --top-k 5
```