> electric-deployment
Deploy Electric via Docker, Docker Compose, or Electric Cloud. Covers DATABASE_URL (direct connection, not pooler), ELECTRIC_SECRET (required since v1.x), ELECTRIC_INSECURE for dev, wal_level=logical, max_replication_slots, ELECTRIC_STORAGE_DIR persistence, ELECTRIC_POOLED_DATABASE_URL for pooled queries, IPv6 with ELECTRIC_DATABASE_USE_IPV6, Kubernetes readiness probes (200 vs 202), replication slot cleanup, and Postgres v14+ requirements. Load when deploying Electric or configuring Postgres fo
curl "https://skillshub.wtf/electric-sql/electric/electric-deployment?format=md"Electric — Deployment
Setup
Postgres configuration
# postgresql.conf
wal_level = logical
max_replication_slots = 10
Docker Compose
name: 'electric-backend'
services:
postgres:
image: postgres:16-alpine
environment:
POSTGRES_DB: electric
POSTGRES_USER: postgres
POSTGRES_PASSWORD: password
ports: ['54321:5432']
volumes: ['./postgres.conf:/etc/postgresql/postgresql.conf:ro']
tmpfs: ['/var/lib/postgresql/data', '/tmp']
command: ['postgres', '-c', 'config_file=/etc/postgresql/postgresql.conf']
electric:
image: electricsql/electric:latest
environment:
DATABASE_URL: postgresql://postgres:password@postgres:5432/electric?sslmode=disable
ELECTRIC_SECRET: ${ELECTRIC_SECRET}
ports: ['3000:3000']
volumes: ['electric_data:/var/lib/electric']
depends_on: ['postgres']
volumes:
electric_data:
Electric Cloud
npx @electric-sql/start my-app
pnpm claim && pnpm deploy
Core Patterns
Environment variables
| Variable | Required | Description |
|---|---|---|
DATABASE_URL | Yes | Direct Postgres connection (not pooler) |
ELECTRIC_SECRET | Yes (prod) | API authentication secret |
ELECTRIC_INSECURE | Dev only | Set true to skip secret requirement |
ELECTRIC_STORAGE_DIR | No | Persistent shape cache directory |
ELECTRIC_POOLED_DATABASE_URL | No | Pooled connection for non-replication queries |
ELECTRIC_DATABASE_USE_IPV6 | No | Set true for IPv6 Postgres connections |
Kubernetes health checks
livenessProbe:
httpGet:
path: /v1/health
port: 3000
readinessProbe:
exec:
command: ['curl', '-sf', 'http://localhost:3000/v1/health']
# Use exec, not httpGet — 202 means "alive but not ready"
# Only 200 means fully ready for traffic
Replication slot cleanup
-- When stopping Electric for extended periods:
SELECT pg_drop_replication_slot('electric_slot_default');
-- Prevent unbounded WAL growth:
ALTER SYSTEM SET max_slot_wal_keep_size = '10GB';
SELECT pg_reload_conf();
Common Mistakes
CRITICAL Not setting wal_level to logical
Wrong:
# postgresql.conf (default)
wal_level = replica
Correct:
wal_level = logical
max_replication_slots = 10
Electric requires logical replication. The default wal_level = replica does not support it. Requires Postgres restart after change.
Source: packages/sync-service/dev/postgres.conf
CRITICAL Running without ELECTRIC_SECRET in production
Wrong:
docker run electricsql/electric \
-e DATABASE_URL=postgres://user:pass@host/db
Correct:
docker run electricsql/electric \
-e DATABASE_URL=postgres://user:pass@host/db \
-e ELECTRIC_SECRET=my-secret-key
Since v1.x, ELECTRIC_SECRET is required. Without it, Electric refuses to start unless ELECTRIC_INSECURE=true is set (dev only).
Source: packages/sync-service/CHANGELOG.md:832-834
MEDIUM Using ephemeral storage for ELECTRIC_STORAGE_DIR
Wrong:
electric:
image: electricsql/electric:latest
# No volume — shape cache lost on restart
Correct:
electric:
image: electricsql/electric:latest
volumes: ['electric_data:/var/lib/electric']
Electric caches shape logs on disk. Ephemeral storage causes full re-sync on every container restart.
Source: website/docs/guides/deployment.md:133-157
MEDIUM Using deprecated ELECTRIC_QUERY_DATABASE_URL
Wrong:
ELECTRIC_QUERY_DATABASE_URL=postgres://user:pass@pooler:6432/db
Correct:
ELECTRIC_POOLED_DATABASE_URL=postgres://user:pass@pooler:6432/db
Renamed from ELECTRIC_QUERY_DATABASE_URL to ELECTRIC_POOLED_DATABASE_URL in v1.3.x. The old name may stop working in future versions.
Source: packages/sync-service/CHANGELOG.md:415
See also: electric-proxy-auth/SKILL.md — Production requires proxy with ELECTRIC_SECRET. See also: electric-postgres-security/SKILL.md — Deployment requires correct Postgres configuration. See also: electric-debugging/SKILL.md — Many sync issues stem from deployment configuration.
Version
Targets Electric sync service v1.x.
> related_skills --same-repo
> blog-planner
Interactive blog post authoring. Produces a draft blog post file with structured outline, inline guidance comments, and meta briefs that the author proses up in place. Supports pyramid principle, best sales deck, and release post formats.
> electric-yjs
Set up ElectricProvider for real-time collaborative editing with Yjs via Electric shapes. Covers ElectricProvider configuration, document updates shape with BYTEA parser (parseToDecoder), awareness shape at offset='now', LocalStorageResumeStateProvider for reconnection with stableStateVector diff, debounceMs for batching writes, sendUrl PUT endpoint, required Postgres schema (ydoc_update and ydoc_awareness tables), CORS header exposure, and sendErrorRetryHandler. Load when implementing collabora
> electric-shapes
Configure ShapeStream and Shape to sync a Postgres table to the client. Covers ShapeStreamOptions (url, table, where, columns, replica, offset, handle), custom type parsers (timestamptz, jsonb, int8), column mappers (snakeCamelMapper, createColumnMapper), onError retry semantics, backoff options, log modes (full, changes_only), requestSnapshot, fetchSnapshot, subscribe/unsubscribe, and Shape materialized view. Load when setting up sync, configuring shapes, parsing types, or handling sync errors.
> electric-schema-shapes
Design Postgres schema and Electric shape definitions together for a new feature. Covers single-table shape constraint, cross-table joins using multiple shapes, WHERE clause design for tenant isolation, column selection for bandwidth optimization, replica mode choice (default vs full for old_value), enum casting in WHERE clauses, and txid handshake setup with pg_current_xact_id() for optimistic writes. Load when designing database tables for use with Electric shapes.