.env.example

# ================================
# Cognitive Database Agent - Environment Configuration
# ================================
# INSTRUCTIONS:
# 1. Copy this file to .env
# 2. Replace placeholder values with your actual credentials
# 3. NEVER commit .env to version control
# ================================

# Google Gemini API Configuration
# Get your API key from: https://ai.google.dev/
GOOGLE_API_KEY=your_google_api_key_here

# Database Configuration
# PostgreSQL connection settings
DB_HOST=localhost
DB_PORT=5432
DB_NAME=cognitive_db_agent
DB_USER=postgres
DB_PASSWORD=your_postgres_password_here

# Database Roles (for role impersonation)
# These should match the roles created in your PostgreSQL database
DB_ROLE_ADMIN=db_admin
DB_ROLE_MANAGER=db_manager
DB_ROLE_VIEWER=db_viewer

# Vector Embedding Configuration
# Model to use for embeddings (Google's embedding model)
EMBEDDING_MODEL=models/embedding-001
EMBEDDING_DIMENSION=768

# LLM Configuration
# Gemini model for the cognitive agent
LLM_MODEL=gemini-1.5-flash
LLM_TEMPERATURE=0.1
LLM_MAX_TOKENS=2048

# FastAPI Configuration
API_HOST=0.0.0.0
API_PORT=8000
API_RELOAD=true

# Security
# Secret key for API authentication (generate with: openssl rand -hex 32)
SECRET_KEY=your_secret_key_here_generate_with_openssl_rand_hex_32

# CORS Settings (for React frontend)
CORS_ORIGINS=http://localhost:5173,http://localhost:3000

# Logging
LOG_LEVEL=INFO

# Agent Configuration
AGENT_VERBOSE=true
AGENT_MAX_ITERATIONS=10
AGENT_MAX_EXECUTION_TIME=120

# RAG Configuration
RAG_TOP_K=5
RAG_SIMILARITY_THRESHOLD=0.7

# Development Settings
ENVIRONMENT=development
DEBUG=true