⚡ MCP SQLite Persistent Memory & Knowledge Server

Production-grade Generative AI, LLMs & Agentic Systems built and maintained by Wajid Raza.

📖 Overview

MCP SQLite Persistent Memory & Knowledge Server is a high-performance, enterprise-grade engineering solution designed for Generative AI, LLMs & Agentic Systems. It delivers robust scalability, sub-millisecond response latency, and complete resilience across distributed cloud environments.

🌟 Key Features

• Scalable Architecture: Engineered following domain-driven design (DDD) and clean microservice paradigms.

• High Throughput: Optimized connection pooling, asynchronous worker queues, and distributed memory caching.

• Security & RBAC: Strict authentication pipelines with cryptographic token verification and input sanitization.

• Observability: Structured logging, health check probes, Prometheus metrics exporters, and APM telemetry.

Related MCP server: thoughtgraph-mcp

🛠️ Technology Stack

• Core Frameworks: TypeScript, Node.js 20, Anthropic @modelcontextprotocol/sdk, SQLite3, Better-SQLite3

• Databases & Cache: PostgreSQL, Redis, In-Memory Storage

• Infrastructure: Docker, Container Orchestration, GitHub Actions CI/CD

• Testing: Jest / Pytest / Go Testing suite with >90% code coverage

🚀 Quick Start & Local Setup

1. Clone the Repository

git clone https://github.com/wajidraza/mcp-sqlite-memory-server.git
cd mcp-sqlite-memory-server

2. Configure Environment

cp .env.example .env

3. Launch with Docker Compose

docker-compose up -d

4. Run Locally

# Install dependencies
npm install  # or pip install -r requirements.txt / go mod download

# Start development server
npm run dev  # or uvicorn main:app --reload / go run cmd/server/main.go

🧪 Automated Testing

Execute the unit and integration test suite:

npm test     # or pytest / go test -v ./...

👤 Author & Architecture Lead

Wajid Raza
Senior Full-Stack Engineer

• Portfolio: craftsetup.com/team/wajid-raza

• Email: wajidrazapk@outlook.com

• GitHub: @wajidraza