Chat SDK adds PostgreSQL state adapter

Chat SDK now supports PostgreSQL as a state backend, joining Redis and ioredis as a production-ready option with the new PostgreSQL adapter.

Teams that already run PostgreSQL can persist subscriptions, distributed locks, and key-value cache state without adding Redis to their infrastructure.

Try the PostgreSQL state adapter today:

1
import { Chat } from "chat";
2
import { createPostgresState } from "@chat-adapter/state-pg";
3

4
const bot = new Chat({
5
  userName: "mybot",
6
  adapters: {
7
    /* ... */
8
  },
9
  state: createPostgresState(),
10
});

The adapter uses pg (node-postgres) with raw SQL queries and automatically creates the required tables on first connect. It supports TTL-based caching, distributed locking across multiple instances, and namespaced state via a configurable key prefix.

Read the documentation to get started or browse the adapters directory.

Special thanks to @bai, whose community contribution in PR #154 laid the groundwork for this adapter.