SQLite Local AI Memory MCP
An in-process hybrid memory engine and MCP server for LLMs using SQLite and Int8 vectors. It provides AI assistants with permanent, organized memory stored in a local file, featuring active notepads, knowledge vaults, and auto-cleanup mechanisms to prevent context loss and reduce token usage.
Package and access
Local package with source-attributed installation metadata. Koskamo does not execute packages during review.
What you can do with it
- Provide AI assistants with permanent memory across sessions
- Store and retrieve technical facts and configurations
- Auto-cleanup and summarize chat history to save tokens
Source and maintenance
- Maintenance checked
Packages and installation
Source-provided package data. Koskamo has not executed or live-probed this package.
sqlite-local-ai-memory 1.5.3
{
"version": "1.5.3",
"transport": "stdio",
"identifier": "sqlite-local-ai-memory",
"registryType": "npm",
"environmentVariables": [
{
"name": "GEMINI_API_KEY",
"format": "string",
"description": "Google Gemini API key for Out-of-the-Box cloud cognitive agents and embeddings (gemini-2.5-flash-lite & gemini-embedding-001)."
},
{
"name": "SQLITE_MEM_PATH",
"format": "string",
"description": "Optional custom path to the SQLite database file (defaults to ~/.local-ai-memory/memoria.db)."
}
]
}Tools
Reported by the attributed source; not independently observed by Koskamo.
Connect from your client
Each snippet configures the same source-provided package; replace placeholders before use.
Cursor
{
"mcpServers": {
"sqlite-local-ai-memory-mcp": {
"command": "npx",
"args": [
"-y",
"sqlite-local-ai-memory@1.5.3"
],
"env": {
"GEMINI_API_KEY": "<YOUR_GEMINI_API_KEY>",
"SQLITE_MEM_PATH": "<YOUR_SQLITE_MEM_PATH>"
}
}
}
}Cline
{
"mcpServers": {
"sqlite-local-ai-memory-mcp": {
"command": "npx",
"args": [
"-y",
"sqlite-local-ai-memory@1.5.3"
],
"env": {
"GEMINI_API_KEY": "<YOUR_GEMINI_API_KEY>",
"SQLITE_MEM_PATH": "<YOUR_SQLITE_MEM_PATH>"
}
}
}
}VS Code
{
"servers": {
"sqlite-local-ai-memory-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"sqlite-local-ai-memory@1.5.3"
],
"env": {
"GEMINI_API_KEY": "<YOUR_GEMINI_API_KEY>",
"SQLITE_MEM_PATH": "<YOUR_SQLITE_MEM_PATH>"
}
}
}
}Claude Desktop
{
"mcpServers": {
"sqlite-local-ai-memory-mcp": {
"command": "npx",
"args": [
"-y",
"sqlite-local-ai-memory@1.5.3"
],
"env": {
"GEMINI_API_KEY": "<YOUR_GEMINI_API_KEY>",
"SQLITE_MEM_PATH": "<YOUR_SQLITE_MEM_PATH>"
}
}
}
}Let your agent find its tools
Find servers like SQLite Local AI Memory MCP from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.