.env.example

# ============================================================
# Vision native/local environment (reference template)
# ============================================================
# The packaged macOS app creates its own isolated PostgreSQL credentials and
# runtime configuration automatically. Local development normally uses
# apps/node-backend/.env.local for database, CORS, and port overrides.
#
# Copy this file to .env only when you need shared provider settings or run the
# backend directly against a PostgreSQL database you manage. The .env file is
# git-ignored; never commit real credentials.
# ============================================================

# --- Database (optional for a manually managed backend) ---
# DATABASE_URL=postgresql://ftm_user:replace-with-a-random-password@127.0.0.1:5432/financial_transactions

# --- Least-privilege database role (optional hardening) ---
# Point DATABASE_URL at a non-superuser application role and keep the privileged
# migration role in DATABASE_URL_MIGRATIONS. At startup the backend creates the
# application role when needed and reapplies the grants from
# config/postgres/app-role-grants.sql.tpl.
# DATABASE_URL=postgresql://ftm_app:replace-with-a-second-random-password@127.0.0.1:5432/financial_transactions
# DATABASE_URL_MIGRATIONS=postgresql://ftm_user:replace-with-a-random-password@127.0.0.1:5432/financial_transactions

# --- Logging (optional, production defaults shown) ---
LOG_LEVEL=warn
ENABLE_LOGGING=true

# --- Local AI chat (optional) ---
# OLLAMA_URL=http://127.0.0.1:11434
# OLLAMA_NUM_CTX=8192
# AI_CHAT_CONTEXT_BUDGET_CHARS=24000
# AI_CHAT_MAX_TOOL_RESULT_CHARS=6000

# --- Research providers (ADR-079, all optional) ---
# The repository .env is the shared home for provider API keys. A provider with
# no key is omitted from the research capability chain (Yahoo needs no key).
# TWELVE_DATA_API_KEY=        # quotes/charts        — free tier 8/min, 800/day
# FINNHUB_API_KEY=            # news, US fundamentals — free tier 60/min
# FMP_API_KEY=                # fundamentals         — free tier 250/day
# ALPHA_VANTAGE_API_KEY=      # fallback quotes/fund. — free tier ~25/day
# FRED_API_KEY=               # macro series (ADR-082) — free tier