.env.example

APP_NAME=Laravel
APP_ENV=local
APP_KEY=
APP_DEBUG=true
LOG_CHANNEL=stack
LOG_LEVEL=debug
APP_URL=http://localhost

# For HTTPS environments, set these:
# SESSION_SECURE_COOKIE=true
# SESSION_DOMAIN=.yourdomain.com

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=homestead
DB_USERNAME=homestead
DB_PASSWORD=secret
# Database timezone - MUST match APP_TIMEZONE (config/app.php) to prevent TIMESTAMP conversion issues
# IMPORTANT: Use numeric offset format (e.g., '+08:00') instead of named timezones
# Named timezones (e.g., 'Asia/Shanghai') require MySQL time zone tables to be loaded
# and will cause "Unknown or incorrect time zone" errors if not available.
# For GMT+8 (Asia/Shanghai equivalent), use: +08:00
DB_TIMEZONE=+08:00

# For migration user only
DB_MIGRATE_USERNAME=homestead_migrate
DB_MIGRATE_PASSWORD=secret

BROADCAST_DRIVER=log
CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_CONNECTION=sync

REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379

MAIL_MAILER=smtp
MAIL_HOST=smtp.mailtrap.io
MAIL_PORT=2525
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null
MAIL_FROM_ADDRESS=null
MAIL_FROM_NAME="${APP_NAME}"

SEND_CLOUD_USER=
SEND_CLOUD_KEY=

PUSHER_APP_ID=
PUSHER_APP_KEY=
PUSHER_APP_SECRET=

# Google Gemini API for Natural Language Query
# Get your API key from: https://makersuite.google.com/app/apikey
GEMINI_API_KEY=
# OpenAI-compatible API endpoint
GEMINI_API_ENDPOINT=https://generativelanguage.googleapis.com/v1beta/openai/chat/completions
# Model name (e.g., gemini-3-flash-preview, gemini-2.0-flash-exp)
GEMINI_MODEL=gemini-3-flash-preview
# Max output tokens for a single completion
GEMINI_MAX_COMPLETION_TOKENS=8192

# LLM API fallback (optional; auto-switch when primary fails)
# Only GEMINI_API_KEY_1 is required to enable; endpoint/model inherit from primary if omitted
GEMINI_API_KEY_1=
GEMINI_API_ENDPOINT_1=
GEMINI_MODEL_1=

# Prometheus Metrics
PROMETHEUS_ENABLED=false
PROMETHEUS_NAMESPACE=cbdb
# Storage adapter: memory, redis, or apc
PROMETHEUS_STORAGE_ADAPTER=apc
PROMETHEUS_HTTP_METRICS_ENABLED=true
# IP whitelist for /metrics endpoint (comma-separated, empty = allow all)
PROMETHEUS_ALLOWED_IPS=
# Basic auth for /metrics endpoint (optional)
PROMETHEUS_AUTH_ENABLED=false
PROMETHEUS_AUTH_USERNAME=prometheus
PROMETHEUS_AUTH_PASSWORD=

# MCP Settings
MCP_ALLOWED_TABLES=ADDRESSES,ADDR_BELONGS_DATA,ADDR_CODES,ADMIN_CAT_CODES,ADMIN_CAT_CODE_TYPE_REL,ADMIN_CAT_TYPES,ALTNAME_CODES,ALTNAME_DATA,APPOINTMENT_CODES,APPOINTMENT_CODE_TYPE_REL,APPOINTMENT_TYPES,ASSOC_CODES,ASSOC_CODE_TYPE_REL,ASSOC_DATA,ASSOC_TYPES,ASSUME_OFFICE_CODES,BIOG_ADDR_CODES,BIOG_ADDR_DATA,BIOG_INST_CODES,BIOG_INST_DATA,BIOG_MAIN,BIOG_SOURCE_DATA,BIOG_TEXT_DATA,CHORONYM_CODES,COUNTRY_CODES,DYNASTIES,ENTRY_CODES,ENTRY_CODE_TYPE_REL,ENTRY_DATA,ENTRY_TYPES,ETHNICITY_TRIBE_CODES,EVENTS_ADDR,EVENTS_DATA,EVENT_CODES,EXTANT_CODES,GANZHI_CODES,HOUSEHOLD_STATUS_CODES,INDEXYEAR_TYPE_CODES,KINSHIP_CODES,KIN_DATA,KIN_MOURNING,KIN_MOURNING_STEPS,LITERARYGENRE_CODES,MEASURE_CODES,MERGED_PERSON_DATA,NIAN_HAO,OCCASION_CODES,OFFICE_CATEGORIES,OFFICE_CODES,OFFICE_CODE_TYPE_REL,OFFICE_TYPE_TREE,PARENTAL_STATUS_CODES,POSSESSION_ACT_CODES,POSSESSION_ADDR,POSSESSION_DATA,POSTED_TO_ADDR_DATA,POSTED_TO_OFFICE_DATA,POSTING_DATA,SCHOLARLYTOPIC_CODES,SOCIAL_INSTITUTION_ADDR,SOCIAL_INSTITUTION_ADDR_TYPES,SOCIAL_INSTITUTION_ALTNAME_CODES,SOCIAL_INSTITUTION_ALTNAME_DATA,SOCIAL_INSTITUTION_CODES,SOCIAL_INSTITUTION_NAME_CODES,SOCIAL_INSTITUTION_TYPES,STATUS_CODES,STATUS_CODE_TYPE_REL,STATUS_DATA,STATUS_TYPES,TEXT_BIBLCAT_CODES,TEXT_BIBLCAT_CODE_TYPE_REL,TEXT_BIBLCAT_TYPES,TEXT_CODES,TEXT_INSTANCE_DATA,TEXT_ROLE_CODES,TEXT_TYPE,YEAR_RANGE_CODES
MCP_REQUIRED_ABILITY=mcp:read