{"name":"io.github.cheveguerra/sqlite-local-ai-memory","slug":"cheveguerra-sqlite-local-ai-memory","title":"SQLite Local AI Memory","description":"100% In-Process Bare-Metal Hybrid Memory Engine & MCP Server for LLMs (SQLite + Int8 Vectors).","url":"https://mcp.market/server/cheveguerra-sqlite-local-ai-memory","rating":null,"grade":"B","score":83,"certified":false,"status":"active","category":"data","tags":["data"],"presence":{"score":33,"stars":1,"forks":0,"downloads_week":961,"last_push_at":"2026-10-24T02:34:38.000Z","license":"MIT"},"uptime":null,"claimed":false,"transport":"npm","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/cheveguerra/sqlite-local-ai-memory","website":null,"version":"1.5.3","remotes":[],"packages":[{"registryType":"npm","identifier":"sqlite-local-ai-memory","version":"1.5.3","transport":{"type":"stdio"},"environmentVariables":[{"description":"Google Gemini API key for Out-of-the-Box cloud cognitive agents and embeddings (gemini-2.5-flash-lite & gemini-embedding-001).","format":"string","isSecret":true,"name":"GEMINI_API_KEY"},{"description":"Optional custom path to the SQLite database file (defaults to ~/.local-ai-memory/memoria.db).","format":"string","name":"SQLITE_MEM_PATH"}]}],"tools":[{"name":"consolidate","description":"Executes cognitive memory maintenance (AutoDream): synthesizes progress, archives obsolete notes, and updates the project dashboard (batch write). Call only at session close or after major milestones, NOT on every turn. Preserves other projects' cards. Returns triage summary report.","write_action":true,"price_micros":0,"input_schema":null},{"name":"get_current_state","description":"Retrieves the active executive working dashboard, active project focus, and recent milestones (read-only). Use during session bootstrap or task switching for high-level orientation. Do NOT use for granular fact searches (use 'search_memory'). Returns formatted markdown dashboard.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_fact_lineage","description":"Traces the full evolutionary history and supersede chain of a fact by its UUID (read-only). Use when auditing how or why a rule changed, or resolving conflicting facts. Obtain the UUID via 'search_memory'. Returns chronological revisions and rationale.","write_action":false,"price_micros":0,"input_schema":null},{"name":"save_fact","description":"Persists an atomic fact, preference, or technical rule into long-term memory with automatic semantic deduplication and vector indexing (append-only write). Use for immediate logging; for search use 'search_memory', for evolution audits use 'get_fact_lineage', and for batch synthesis use 'consolidate'. Returns the assigned fact UUID and status.","write_action":false,"price_micros":0,"input_schema":null},{"name":"search_memory","description":"Searches long-term memory using hybrid FTS5 BM25 lexical and vector cosine similarity with RRF ranking (read-only). Supports Point-in-Time queries via 'as_of'. Use for factual lookup and technical recall. For active high-level board use 'get_current_state'; for fact revisions use 'get_fact_lineage'. Returns ranked list of scored memory items.","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":83,"grade":"B","scanned_at":"2026-10-24T04:05:41.199Z","report":{"scannerVersion":"0.1.10","scannedAt":"2026-10-24T04:05:41.128Z","components":{"code":{"score":25,"max":25,"notes":["23 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":6,"max":15,"notes":["static API keys via environment variables"]},"maintenance":{"score":15,"max":15,"notes":["last push 0 days ago"]},"identity":{"score":8,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[{"registryType":"npm","identifier":"sqlite-local-ai-memory","version":"1.5.3","found":true,"license":"MIT","hasInstallScripts":false,"dependencyCount":5,"publishedAt":"2026-10-23T20:49:11.101Z","repositoryUrl":"git+https://github.com/cheveguerra/sqlite-local-ai-memory.git","weeklyDownloads":961}],"repo":{"found":true,"owner":"cheveguerra","repo":"sqlite-local-ai-memory","archived":false,"pushedAt":"2026-10-24T02:34:38Z","stars":1,"forks":0,"openIssues":0,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/5891114?v=4","ownerCreatedAt":"2013-11-08T19:04:58Z","license":"MIT"},"icon":{"url":"https://avatars.githubusercontent.com/u/5891114?v=4&s=128","source":"github"},"presence":{"stars":1,"forks":0,"downloadsWeek":961,"license":"MIT","lastPushAt":"2026-10-24T02:34:38.000Z","score":33}}}},"grade_history":[],"reviews":[]}