Give a Pydantic AI agent memory and read access to your tables

Pydantic AI Harness version 0.66.0 adds a Pixeltable integration that can expose allowlisted Pixeltable tables as read-only agent tools and use a Pixeltable table for persistent agent memory, following its merge on November 3, 2026 and package release on November 4. Tests conducted in a Python 3.12 Linux container with Pixeltable 0.7.23 showed that table tools can list and describe tables, filter rows, perform embedding-based similarity search, and omit inaccessible media columns, while requests for video data or version handles are rejected. A locally built sentence-transformers embedding index ranked a 60 EUR meal-policy rule first for a relevant query, and Pixeltable updated indexes automatically after data changes. The memory store creates rows on demand and uses compare-and-set versioning plus operation receipts to make repeated writes with the same operation ID replay the original result rather than overwrite it; reusing an ID with different arguments raises a conflict error. Memory history and receipts remain readable through table versions, but the store does not support metadata writes and Pixeltable offers no history-pruning API, making table deletion the stated way to fully purge stored memory. The integration is most suitable when agent notes benefit from residing alongside structured data, video, and embedding indexes, whereas Harness’s file or SQLite stores may be simpler for schema-free or standalone notes.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.