packages/typescript-client/skills/electric-deployment/SKILL.md
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 for logical replication.
npx skillsauth add electric-sql/electric electric-deploymentInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
# postgresql.conf
wal_level = logical
max_replication_slots = 10
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:
npx @electric-sql/start my-app
pnpm claim && pnpm deploy
| 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 |
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
-- 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();
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
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
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
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.
Targets Electric sync service v1.x.
development
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.
development
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 collaborative editing with Yjs and Electric.
tools
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.
documentation
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.