# SingleStoreDBChatMessageHistory

> **Class** in `langchain_community`

📖 [View in docs](https://reference.langchain.com/python/langchain-community/chat_message_histories/singlestoredb/SingleStoreDBChatMessageHistory)

Chat message history stored in a SingleStoreDB database.

## Signature

```python
SingleStoreDBChatMessageHistory(
    self,
    session_id: str,
    *,
    table_name: str = 'message_store',
    id_field: str = 'id',
    session_id_field: str = 'session_id',
    message_field: str = 'message',
    pool_size: int = 5,
    max_overflow: int = 10,
    timeout: float = 30,
    **kwargs: Any = {},
)
```

## Extends

- `BaseChatMessageHistory`

## Constructors

```python
__init__(
    self,
    session_id: str,
    *,
    table_name: str = 'message_store',
    id_field: str = 'id',
    session_id_field: str = 'session_id',
    message_field: str = 'message',
    pool_size: int = 5,
    max_overflow: int = 10,
    timeout: float = 30,
    **kwargs: Any = {},
)
```

| Name | Type |
|------|------|
| `session_id` | `str` |
| `table_name` | `str` |
| `id_field` | `str` |
| `session_id_field` | `str` |
| `message_field` | `str` |
| `pool_size` | `int` |
| `max_overflow` | `int` |
| `timeout` | `float` |


## Properties

- `table_name`
- `session_id`
- `id_field`
- `session_id_field`
- `message_field`
- `connection_kwargs`
- `connection_pool`
- `table_created`
- `messages`

## Methods

- [`add_message()`](https://reference.langchain.com/python/langchain-community/chat_message_histories/singlestoredb/SingleStoreDBChatMessageHistory/add_message)
- [`clear()`](https://reference.langchain.com/python/langchain-community/chat_message_histories/singlestoredb/SingleStoreDBChatMessageHistory/clear)

## ⚠️ Deprecated

Deprecated since version 0.3.22.

---

[View source on GitHub](https://github.com/langchain-ai/langchain-community/blob/4b280287bd55b99b44db2dd849f02d66c89534d5/libs/community/langchain_community/chat_message_histories/singlestoredb.py#L20)