manage-conversation-db

What problem does it solve?

This skill provides a structured approach to implement stateless conversation persistence for chat applications, enabling reliable loading/creation of conversations by ID and durable storage of user and assistant messages.

Core Features & Use Cases

• Conversation Lifecycle: Create new conversations or load existing ones by ID.
• Message Storage: Persist messages with role, content, and optional metadata (tool_name, tool_call_id).
• History Retrieval: Fetch conversation history in chronological order for agent input.
• Async Operations: Support non-blocking database queries to improve throughput.
• User Isolation: Ensure conversations are scoped to a specific user_id.

Quick Start

• Set up the database models for Conversation and Message (as shown in the code sample).
• Initialize an AsyncSession and a ConversationService with the session.
• Example flows:
  • Get or create a conversation for user_id "user-123".
  • Save a user message and an assistant reply.
  • Retrieve the latest 50 messages for a conversation.