Release 2.1.0

surveilr v2.1.0 Release Notes

🚀 What's New

1. AI-Powered Natural Language to SQL (ask-ai)

• New Command: surveilr ask-ai sql converts natural language queries into SQL and executes them against your RSSD
• Smart Context Integration: Automatically retrieves relevant AI context from Surveilr notebook cells for
  domain-specific knowledge
• Multiple Output Formats: Support for table, JSON, CSV, and markdown output formats
• Flexible LLM Support: Works with OpenAI-compatible endpoints including local models (Ollama, etc.)

Basic natural language queries

surveilr ask-ai sql "show me all files ingested in the last week"
surveilr ask-ai sql "what devices have been scanned?"
surveilr ask-ai sql "find all JSON files larger than 1MB"

Different output formats

surveilr ask-ai sql "show device information" --output json
surveilr ask-ai sql "list recent sessions" --output csv
surveilr ask-ai sql "security audit summary" --output markdown

Development and debugging

surveilr ask-ai sql "show database tables" --show-query
surveilr ask-ai sql "count all records" --sql-only

🔧 Configuration

Environment variables for LLM configuration

export SURVEILR_LLM_API_KEY="your-api-key"
export SURVEILR_LLM_API_ENDPOINT="https://api.openai.com/v1/chat/completions" # For gpt or your preffered model
export SURVEILR_LLM_MODEL="gpt-4" # Or your preferred model