# ⚡ MCP SQLite Persistent Memory & Knowledge Server

> **Production-grade Generative AI, LLMs & Agentic Systems built and maintained by [Wajid Raza](https://craftsetup.com/team/wajid-raza).**

[![Architecture](https://img.shields.io/badge/Architecture-Clean%20Microservices-blue.svg?style=flat-square)](#)
[![Tech Stack](https://img.shields.io/badge/Tech%20Stack-TypeScript%20%7C%20Node.js%2020%20%7C%20Anthropic%20@modelcontextprotocol/sdk%20%7C%20SQLite3%20%7C%20Better-SQLite3-gold.svg?style=flat-square)](#)
[![Release Era](https://img.shields.io/badge/Era-2026%20Engineering-orange.svg?style=flat-square)](#)

---

## 📖 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.

---

## 🛠️ 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
```bash
git clone https://github.com/wajidraza/mcp-sqlite-memory-server.git
cd mcp-sqlite-memory-server
```

### 2. Configure Environment
```bash
cp .env.example .env
```

### 3. Launch with Docker Compose
```bash
docker-compose up -d
```

### 4. Run Locally
```bash
# 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:
```bash
npm test     # or pytest / go test -v ./...
```

---

## 👤 Author & Architecture Lead

**Wajid Raza**  
*Senior Full-Stack Engineer*  
- **Portfolio**: [craftsetup.com/team/wajid-raza](https://craftsetup.com/team/wajid-raza)  
- **Email**: [wajidrazapk@outlook.com](mailto:wajidrazapk@outlook.com)  
- **GitHub**: [@wajidraza](https://github.com/wajidraza)