.env.example

APP_NAME=PLSQL Insight
APP_ENVIRONMENT=local
APP_MODE=local
APP_HOST=127.0.0.1
APP_PORT=8000
FRONTEND_HOST=127.0.0.1
FRONTEND_PORT=3000
CORS_ALLOWED_ORIGINS=http://127.0.0.1:3000,http://localhost:3000
LOG_LEVEL=INFO
LOG_SOURCE_CODE=false

# Backend admin password. This is checked locally and never invokes the LLM.
# Administrators can persist knowledge, ingest Oracle metadata, review context,
# submit supporting documents, and run maintenance actions. Analysts remain
# transient. Use a long random secret; do not reuse OLLAMA_API_KEY. Leave blank
# to disable admin access until an approved secret is provisioned.
ADMIN_API_KEY=
ADMIN_AUTH_HEADER=X-Admin-Key

METADATA_DB_BACKEND=sqlite
SQLITE_DATABASE_PATH=./data/plsql_ai.db

ORACLE_ENABLED=false
ORACLE_USER=plsql_ai
ORACLE_PASSWORD=change_me_before_enabling_oracle
ORACLE_DSN=localhost:1521/FREEPDB1
ORACLE_AI_SCHEMA=PLSQL_AI
ORACLE_ALLOWED_OWNERS=PLSQL_AI
ORACLE_POOL_MIN=1
ORACLE_POOL_MAX=5
ORACLE_POOL_INCREMENT=1
BLOCK_PRODUCTION=true
ALLOW_PRODUCTION_OVERRIDE=false

CHROMA_MODE=persistent
CHROMA_PATH=./data/chroma
CHROMA_TENANT=default_tenant
CHROMA_DATABASE=default_database
CHROMA_HOST=127.0.0.1
CHROMA_PORT=8000
CHROMA_SSL=false

LLM_PROVIDER=ollama
OLLAMA_BASE_URL=http://localhost:11434
# Separate from ADMIN_API_KEY. Leave blank for local Ollama. For an
# authenticated office gateway, load the value from your approved secret store
# instead of committing it to this file.
OLLAMA_API_KEY=
OLLAMA_AUTH_HEADER=Authorization
OLLAMA_AUTH_SCHEME=Bearer
OLLAMA_TIMEOUT_SECONDS=300
OLLAMA_MAX_RETRIES=2

MODEL_METADATA_REVIEW=qwen2.5-coder:7b
MODEL_PROCEDURE_CONTEXT=qwen2.5-coder:7b
MODEL_PROCEDURE_ANALYSIS=qwen2.5-coder:7b
MODEL_TABLE_CONTEXT=qwen2.5-coder:7b
MODEL_PACKAGE_CONTEXT=deepseek-r1:7b
MODEL_AUDITOR=deepseek-r1:7b
MODEL_FINAL_MERGE=deepseek-r1:7b

EMBEDDING_PROVIDER=ollama
EMBEDDING_MODEL=nomic-embed-text

LLM_TEMPERATURE=0.1
LLM_TOP_P=0.9
LLM_NUM_CTX=32768
LLM_MAX_OUTPUT_TOKENS=8192

MAX_UPLOAD_MB=20
MAX_SOURCE_LINES=50000
MAX_CHUNK_CHARS=18000
CHUNK_OVERLAP_CHARS=800
MAX_RETRIEVAL_CONTEXT_CHARS=30000
RETRIEVAL_TOP_K=8
RETRIEVAL_MIN_SIMILARITY=0.55
MAX_AUDIT_REVISIONS=2
ANALYSIS_CONCURRENCY=2

SAVE_GENERATED_CONTEXT=true
INDEX_AI_GENERATED_CONTEXT=true
INDEX_RAW_CODE_CHUNKS=true
INDEX_THUMBS_DOWN=false