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

# SQLite CLI

> CLI commands for SQLite conversation store

# SQLite CLI

## Quick Start

```bash theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
# Test connection
praisonai persistence doctor --conversation-backend sqlite --conversation-path ./data.db

# Run agent with persistence
praisonai persistence run --conversation-backend sqlite --conversation-path ./data.db "Hello"

# Resume session
praisonai persistence resume --conversation-backend sqlite --conversation-path ./data.db --session-id my-session
```

## Commands

### Doctor (Connection Test)

```bash theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
praisonai persistence doctor \
  --conversation-backend sqlite \
  --conversation-path ./praisonai.db
```

### Run with Session

```bash theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
praisonai persistence run \
  --conversation-backend sqlite \
  --conversation-path ./praisonai.db \
  --session-id my-session \
  "What is AI?"
```

### Resume Session

```bash theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
praisonai persistence resume \
  --conversation-backend sqlite \
  --conversation-path ./praisonai.db \
  --session-id my-session
```

### Export Session

```bash theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
praisonai persistence export \
  --conversation-backend sqlite \
  --conversation-path ./praisonai.db \
  --session-id my-session \
  --output session.json
```

### Import Session

```bash theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
praisonai persistence import \
  --conversation-backend sqlite \
  --conversation-path ./praisonai.db \
  --input session.json
```

## Python Test

```bash theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
python3 -c "
from praisonai.persistence import create_conversation_store
store = create_conversation_store('sqlite', path='./test.db')
print('SQLite OK')
"
```