Does this skill handle database migrations automatically?

Yes, the PostgresStore automatically creates necessary tables such as rooms, events, and participants upon the first successful connection.

Does it support telemetry and monitoring?

Yes, the skill provides patterns for integrating OpenTelemetry, allowing PostgresStore to automatically wrap database queries with spans for better observability.

Can I configure connection pool sizes?

Yes, the PostgresStore allows you to define min_pool_size and max_pool_size parameters to optimize database performance for your specific load.

What are the technical requirements for this skill?

It requires Python 3.12 or higher, a running PostgreSQL database, and the 'roomkit[postgres]' Python package extras.

RoomKit PostgreSQL Setup

Name: RoomKit PostgreSQL Setup
Author: roomkit-live

byroomkit-live

•

数据库管理

Configures production-grade PostgreSQL storage for RoomKit agents with connection pooling and automatic schema migration.

This skill streamlines the transition from local memory-based storage to production-ready PostgreSQL for RoomKit AI conversation agents. It automates the initialization of essential tables—including rooms, events, participants, and tasks—while configuring optimized connection pooling for high-concurrency environments. Developers can quickly implement persistent message history, advanced querying patterns, and OpenTelemetry integration to ensure their AI agents are scalable, observable, and reliable in production deployments.

主要功能

01Pre-built fallback patterns for development and testing environments

022 GitHub stars

03Automated database schema and table initialization

04Integrated OpenTelemetry support for database query tracing

05Configurable connection pooling for production performance

06JSONB-optimized querying for rooms and event history

使用场景

01Setting up scalable database infrastructure for multi-channel AI agents

02Migrating RoomKit agents from InMemoryStore to persistent SQL storage

03Implementing long-term conversation history and room state persistence

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add roomkit-live/roomkit-skills setup-postgres

For use in Claude.ai and ChatGPT

主要功能

01Pre-built fallback patterns for development and testing environments

022 GitHub stars

03Automated database schema and table initialization

04Integrated OpenTelemetry support for database query tracing

05Configurable connection pooling for production performance

06JSONB-optimized querying for rooms and event history

使用场景

01Setting up scalable database infrastructure for multi-channel AI agents

02Migrating RoomKit agents from InMemoryStore to persistent SQL storage

03Implementing long-term conversation history and room state persistence

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add roomkit-live/roomkit-skills setup-postgres

For use in Claude.ai and ChatGPT