Skip to main content

SQLite CLI

Quick Start

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

praisonai persistence doctor \
  --conversation-backend sqlite \
  --conversation-path ./praisonai.db

Run with Session

praisonai persistence run \
  --conversation-backend sqlite \
  --conversation-path ./praisonai.db \
  --session-id my-session \
  "What is AI?"

Resume Session

praisonai persistence resume \
  --conversation-backend sqlite \
  --conversation-path ./praisonai.db \
  --session-id my-session

Export Session

praisonai persistence export \
  --conversation-backend sqlite \
  --conversation-path ./praisonai.db \
  --session-id my-session \
  --output session.json

Import Session

praisonai persistence import \
  --conversation-backend sqlite \
  --conversation-path ./praisonai.db \
  --input session.json

Python Test

python3 -c "
from praisonai.persistence import create_conversation_store
store = create_conversation_store('sqlite', path='./test.db')
print('SQLite OK')
"