Query

app.db — voice_agent_configs

SQL

CREATE TABLE voice_agent_configs  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL,
  description TEXT,
  user_id INTEGER NOT NULL,
  -- Evolution API Configuration
                    evolution_api_url TEXT,
  evolution_api_key TEXT,
  evolution_instance_name TEXT,
  -- Airtable CRM Configuration
                    airtable_api_key TEXT,
  airtable_base_id TEXT,
  airtable_table_name TEXT DEFAULT 'Leads',
  -- Google Calendar Configuration
                    google_calendar_credentials_file TEXT,
  google_calendar_credentials_json TEXT,
  google_calendar_id TEXT,
  -- Email Configuration
                    smtp_server TEXT,
  smtp_port INTEGER DEFAULT 587,
  smtp_user TEXT,
  smtp_password TEXT,
  -- Zoom Configuration
                    zoom_client_id TEXT,
  zoom_client_secret TEXT,
  zoom_account_id TEXT,
  zoom_user_id TEXT,
  -- LiveKit Configuration
                    livekit_url TEXT,
  livekit_api_key TEXT,
  livekit_api_secret TEXT,
  sip_outbound_trunk_id TEXT,
  -- Active flag
                    is_active INTEGER DEFAULT 1,
  created_at TEXT NOT NULL,
  updated_at TEXT,
  is_default INTEGER DEFAULT 0,
  system_prompt TEXT,
  use_custom_prompt INTEGER DEFAULT 0,
  silence_timeout REAL DEFAULT 8.0,
  voice_name TEXT DEFAULT 'Puck',
  temperature REAL DEFAULT 0.8,
  initial_greeting TEXT,
  notify_human_enabled INTEGER DEFAULT 0,
  notify_human_phone_number TEXT,
  enabled_tools TEXT,
  agent_mode TEXT DEFAULT 'speech_to_speech',
  stt_provider TEXT DEFAULT 'deepgram',
  stt_model TEXT DEFAULT 'nova-3',
  llm_provider TEXT DEFAULT 'openai',
  llm_model TEXT DEFAULT 'gpt-4o-mini',
  tts_provider TEXT DEFAULT 'openai',
  tts_model TEXT DEFAULT 'gpt-4o-mini-tts',
  tts_voice TEXT DEFAULT 'nova',
  tts_instructions TEXT,
  enable_affective_dialog INTEGER DEFAULT 0,
  enable_thinking INTEGER DEFAULT 0,
  include_thoughts INTEGER DEFAULT 1,
  enable_proactivity INTEGER DEFAULT 0,
  use_livekit_turn_detection INTEGER DEFAULT 0,
  FOREIGN KEY (user_id) REFERENCES users(id),
  UNIQUE(name, user_id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
name TEXT Rename | Drop
description TEXT ✓ Rename | Drop
user_id INTEGER Rename | Drop
evolution_api_url TEXT ✓ Rename | Drop
evolution_api_key TEXT ✓ Rename | Drop
evolution_instance_name TEXT ✓ Rename | Drop
airtable_api_key TEXT ✓ Rename | Drop
airtable_base_id TEXT ✓ Rename | Drop
airtable_table_name TEXT ✓ Rename | Drop
google_calendar_credentials_file TEXT ✓ Rename | Drop
google_calendar_credentials_json TEXT ✓ Rename | Drop
google_calendar_id TEXT ✓ Rename | Drop
smtp_server TEXT ✓ Rename | Drop
smtp_port INTEGER ✓ Rename | Drop
smtp_user TEXT ✓ Rename | Drop
smtp_password TEXT ✓ Rename | Drop
zoom_client_id TEXT ✓ Rename | Drop
zoom_client_secret TEXT ✓ Rename | Drop
zoom_account_id TEXT ✓ Rename | Drop
zoom_user_id TEXT ✓ Rename | Drop
livekit_url TEXT ✓ Rename | Drop
livekit_api_key TEXT ✓ Rename | Drop
livekit_api_secret TEXT ✓ Rename | Drop
sip_outbound_trunk_id TEXT ✓ Rename | Drop
is_active INTEGER ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT ✓ Rename | Drop
is_default INTEGER ✓ Rename | Drop
system_prompt TEXT ✓ Rename | Drop
use_custom_prompt INTEGER ✓ Rename | Drop
silence_timeout REAL ✓ Rename | Drop
voice_name TEXT ✓ Rename | Drop
temperature REAL ✓ Rename | Drop
initial_greeting TEXT ✓ Rename | Drop
notify_human_enabled INTEGER ✓ Rename | Drop
notify_human_phone_number TEXT ✓ Rename | Drop
enabled_tools TEXT ✓ Rename | Drop
agent_mode TEXT ✓ Rename | Drop
stt_provider TEXT ✓ Rename | Drop
stt_model TEXT ✓ Rename | Drop
llm_provider TEXT ✓ Rename | Drop
llm_model TEXT ✓ Rename | Drop
tts_provider TEXT ✓ Rename | Drop
tts_model TEXT ✓ Rename | Drop
tts_voice TEXT ✓ Rename | Drop
tts_instructions TEXT ✓ Rename | Drop
enable_affective_dialog INTEGER ✓ Rename | Drop
enable_thinking INTEGER ✓ Rename | Drop
include_thoughts INTEGER ✓ Rename | Drop
enable_proactivity INTEGER ✓ Rename | Drop
use_livekit_turn_detection INTEGER ✓ Rename | Drop

Foreign Keys

Column Destination
user_id users.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_voice_agent_configs_is_active is_active SQL 
CREATE INDEX idx_voice_agent_configs_is_active
ON voice_agent_configs(is_active)
Drop
idx_voice_agent_configs_is_default is_default SQL 
CREATE INDEX idx_voice_agent_configs_is_default
ON voice_agent_configs(is_default)
Drop
idx_voice_agent_configs_user_id user_id SQL 
CREATE INDEX idx_voice_agent_configs_user_id
ON voice_agent_configs(user_id)
Drop
sqlite_autoindex_voice_agent_configs_1
  • name
  • user_id
 ✓ SQL
-- no sql found --
 Drop