.env.example

# Lang2SQL v4.1 — copy to .env and fill in. Only DISCORD_BOT_TOKEN is required.

# Discord bot token from https://discord.com/developers/applications (Bot tab).
# Required to run `lang2sql-bot`; the bot exits with a clear error if it's unset.
DISCORD_BOT_TOKEN=

# OpenAI API key. Optional: when set, the agent uses gpt-4.1-mini. When unset,
# it falls back to the offline FakeLLM (deterministic canned tool cycles — fine
# for a smoke run, not for real answers).
OPENAI_API_KEY=

# Fernet key used to encrypt stored secrets (DSNs / API keys) at rest. Optional:
# if unset, a key is auto-generated and persisted in the SQLite kv table. Set it
# in production so secrets decrypt across restarts and machines. Generate one:
#   python -c "from cryptography.fernet import Fernet; print(Fernet.generate_key().decode())"
LANG2SQL_SECRET_KEY=

# ── Database connection ──────────────────────────────────────────────────
# The default explorer is chosen from these (precedence: LANG2SQL_DB_URL, then
# Cloudflare D1, else an offline canned stub). Install the matching driver
# extra, e.g.  uv sync --extra postgres  (or bigquery/snowflake/mysql/duckdb).
#
# Any SQLAlchemy URL works (one adapter, many engines):
#   postgresql+psycopg://user:pass@host:5432/dbname
#   bigquery://project/dataset
#   snowflake://user:pass@account/db/schema?warehouse=wh
#   mysql+pymysql://user:pass@host/dbname
#   duckdb:////absolute/path/to/file.duckdb
LANG2SQL_DB_URL=
# Optional default schema for the SQLAlchemy explorer.
LANG2SQL_DB_SCHEMA=

# Cloudflare D1 (used when LANG2SQL_DB_URL is unset). D1 is SQLite over an HTTP
# API — no driver needed. Find IDs in the Cloudflare dashboard → D1.
CLOUDFLARE_D1_ACCOUNT_ID=
CLOUDFLARE_D1_DATABASE_ID=
# API token with D1 read access (Account → API Tokens). Required for D1 queries.
CLOUDFLARE_API_TOKEN=