elizaos--eliza/plugins/plugin-sql/.env.example

# ────────────────────────────────────────────────────────
# Electric Cloud Integration (e2e write-back test)
# ────────────────────────────────────────────────────────
# These are consumed by the Caddy reverse proxy at:
#   plugins/plugin-sql/caddy/electric-proxy.Caddyfile
# Caddy rewrites path-based shape URLs to query-param format
# and injects these credentials, proxying to api.electric-sql.cloud.
#
# Get your source ID and secret from the Electric Cloud dashboard:
#   https://dashboard.electric-sql.cloud
ELECTRIC_CLOUD_SOURCE_ID=svc-xxxxxxxxxxxx
ELECTRIC_CLOUD_SECRET=

# ────────────────────────────────────────────────────────
# Electric Sync (PGlite ↔ Electric)
# ────────────────────────────────────────────────────────
# ELIZA_ELECTRIC_SYNC_URL is the base URL of your Electric
# sync service. For local dev with Caddy + Electric Cloud:
#   ELIZA_ELECTRIC_SYNC_URL=http://localhost:3001
# For direct Electric Cloud (no Caddy needed if your client
# library constructs query-param URLs natively):
#   ELIZA_ELECTRIC_SYNC_URL=https://api.electric-sql.cloud
ELIZA_ELECTRIC_SYNC_URL=http://localhost:3001

# Agent ID for per-agent sync filtering (required when
# ELIZA_ELECTRIC_SYNC_URL is set). Each PGlite instance
# syncs only rows matching its agent_id WHERE clause.
AGENT_ID=

# ────────────────────────────────────────────────────────
# Write-Back Service (PGlite → Cloud API)
# ────────────────────────────────────────────────────────
# URL of the write-back cloud endpoint that receives local
# PGlite writes and forwards them to Postgres.
ELIZA_CLOUD_WRITE_BASE_URL=

# Service key for authenticating write-back requests.
ELIZA_CLOUD_SERVICE_KEY=

# ────────────────────────────────────────────────────────
# PGlite Storage
# ────────────────────────────────────────────────────────
# Filesystem directory for PGlite data. Defaults to the
# project-relative .eliza/.elizadb when unset.
PGLITE_DATA_DIR=

# Set to "1" to disable PGlite extensions (vector, live
# queries, fuzzystrmatch, Electric sync).
# ELIZA_PGLITE_DISABLE_EXTENSIONS=1

# ────────────────────────────────────────────────────────
# Postgres (server-mode / Neon)
# ────────────────────────────────────────────────────────
# When set, plugin-sql runs in server mode against a remote
# Postgres instead of using embedded PGlite.
POSTGRES_URL=

# ────────────────────────────────────────────────────────
# Data Isolation / RLS
# ────────────────────────────────────────────────────────
# Enable row-level security for multi-tenant deployments.
# ENABLE_DATA_ISOLATION=true

# Server ID used as the RLS tenant identifier. Must be a
# valid UUID when ENABLE_DATA_ISOLATION is true.
ELIZA_SERVER_ID=

# ────────────────────────────────────────────────────────
# Migrations
# ────────────────────────────────────────────────────────
# Set to "true" to allow destructive DDL migrations in
# production (e.g., DROP COLUMN, DROP TABLE). Off by
# default in NODE_ENV=production.
# ELIZA_ALLOW_DESTRUCTIVE_MIGRATIONS=true