{"_id":"@a2arium/callagent-memory-sql","name":"@a2arium/callagent-memory-sql","dist-tags":{"latest":"0.2.0"},"versions":{"0.2.0":{"name":"@a2arium/callagent-memory-sql","version":"0.2.0","main":"dist/index.js","types":"dist/index.d.ts","scripts":{"build":"tsc -p tsconfig.json","test":"node --experimental-vm-modules ../../node_modules/jest/bin/jest.js","postinstall":"prisma generate","db:migrate":"prisma migrate deploy","db:generate":"prisma generate","db:setup-vectors":"tsx scripts/setup-vectors.ts","db:setup":"yarn db:migrate && yarn db:generate && yarn db:setup-vectors","db:reset":"prisma migrate reset && yarn db:setup","db:dev":"prisma migrate dev && yarn db:setup-vectors","npm:publish":"npm publish --access public","npm:publish:dry-run":"npm publish --access public --dry-run","version:patch":"npm version patch","version:minor":"npm version minor","version:major":"npm version major"},"publishConfig":{"access":"public"},"private":false,"description":"SQL-backed memory adapter for the CallAgent framework.","license":"MIT","keywords":["memory","sql","prisma","callagent"],"dependencies":{"@a2arium/callagent-types":"0.2.0","@a2arium/callagent-utils":"0.2.0","@prisma/client":"^6.7.0"},"devDependencies":{"jest":"^29.7.0","jest-mock-extended":"^4.0.0-beta1","prisma":"^6.7.0","ts-jest":"^29.3.2","tsx":"^4.19.4","typescript":"^5.8.3"},"type":"module","exports":{".":{"import":"./dist/index.js","require":"./dist/index.js","types":"./dist/index.d.ts"}},"_id":"@a2arium/callagent-memory-sql@0.2.0","gitHead":"36eb1e234829192a6b0a89a9d0aa5c5203b9d0a0","_nodeVersion":"20.9.0","_npmVersion":"10.1.0","dist":{"integrity":"sha512-Il8hm77ZyINjvvSO5vjn8w+CkAOji6/02iNUHZL2+IPndAThzrvU2Sh6DGrKBBiosu4JB06lBWFOJl65bRPi2A==","shasum":"614e2b2dd655eec57e16260f2c053b292772279d","tarball":"https://registry.npmjs.org/@a2arium/callagent-memory-sql/-/callagent-memory-sql-0.2.0.tgz","fileCount":45,"unpackedSize":218424,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIFQMztbg8inK1kEiN2UDcVusG0/JY11rEe3KDv05oi7WAiEA2WrLsANwHOV74JIKjmpdlXzjKuLqwTY3wdTuaToNc6E="}]},"_npmUser":{"name":"a2arium","email":"antonov@me.com"},"directories":{},"maintainers":[{"name":"a2arium","email":"antonov@me.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/callagent-memory-sql_0.2.0_1753021178516_0.33806439557254886"},"_hasShrinkwrap":false}},"time":{"created":"2025-07-20T14:19:38.390Z","0.2.0":"2025-07-20T14:19:38.697Z","modified":"2025-07-20T14:19:39.014Z"},"maintainers":[{"name":"a2arium","email":"antonov@me.com"}],"description":"SQL-backed memory adapter for the CallAgent framework.","keywords":["memory","sql","prisma","callagent"],"license":"MIT","readme":"# @a2arium/callagent-memory-sql\n\nSQL-backed memory persistence adapter for the CallAgent framework using Prisma.\n\n## Installation\n\n```bash\nnpm install @a2arium/callagent-memory-sql\n```\n\nor with yarn:\n\n```bash\nyarn add @a2arium/callagent-memory-sql\n```\n\n## Setup\n\n1. **Database Setup**: Configure your database connection in your environment:\n\n```bash\nDATABASE_URL=\"postgresql://username:password@localhost:5432/callagent\"\n```\n\n2. **Run Migrations**: Set up the database schema:\n\n```bash\nnpx prisma migrate deploy\n```\n\n3. **Generate Client**: Generate the Prisma client:\n\n```bash\nnpx prisma generate\n```\n\n## Usage\n\n### Working Memory\n\n```typescript\nimport { WorkingMemoryRegistry } from '@a2arium/callagent-memory-sql';\n\nconst workingMemory = new WorkingMemoryRegistry({\n  tenantId: 'user-123'\n});\n\n// Store data\nawait workingMemory.store('key', 'value');\n\n// Retrieve data\nconst record = await workingMemory.recall('key');\nconsole.log(record?.content); // 'value'\n```\n\n### Episodic Memory\n\n```typescript\nimport { EpisodicMemoryRegistry } from '@a2arium/callagent-memory-sql';\n\nconst episodicMemory = new EpisodicMemoryRegistry({\n  tenantId: 'user-123'\n});\n\n// Store an event\nawait episodicMemory.store({\n  event: 'user_login',\n  timestamp: new Date(),\n  context: { userId: '123', ip: '192.168.1.1' }\n});\n```\n\n### Semantic Memory\n\n```typescript\nimport { SemanticMemoryRegistry } from '@a2arium/callagent-memory-sql';\n\nconst semanticMemory = new SemanticMemoryRegistry({\n  tenantId: 'user-123'\n});\n\n// Store knowledge\nawait semanticMemory.store({\n  concept: 'AI Agent',\n  definition: 'An autonomous software entity...',\n  embeddings: vectorData\n});\n\n// Semantic search\nconst results = await semanticMemory.search('artificial intelligence');\n```\n\n## Features\n\n- **Multi-tenant Support**: Isolated data per tenant/user\n- **Vector Storage**: Semantic search with embeddings\n- **ACID Transactions**: Reliable data persistence\n- **Binary Data Support**: Store files, images, and binary content\n- **Optimized Queries**: Performance-tuned database operations\n\n## Database Support\n\n- PostgreSQL (recommended)\n- MySQL\n- SQLite (for development)\n\n## License\n\nMIT ","readmeFilename":"README.md","_rev":"1-f66dd4109ccaf80f20112334c2992a50"}