MCP KnowledgeBase Server
About
Model Context Protocol (MCP) server allowing LLMs to store and search knowledge in a SQLite database
Details
- Author
- mbcrawfo
- GitHub stars
- 7
- Downloads
- 257
- Categories
- Database
Jump to
- Store memories during LLM conversations
- Search memories using SQLite full text search
- Docker deployment with persistent volume support
- Local deployment with .NET 9 SDK
- Custom database location via environment variables
- Includes a default memory usage prompt for LLMs
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
MCP KnowledgeBase ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Deploy via Docker with a persistent volume or run locally with the .NET 9 SDK. Configure the server in claude_desktop_config.json using the provided examples. Control the database location with the environment variables DATABASE_NAME or DATABASE_PATH. A default "General Memory Usage" prompt is included to guide the LLM.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mcp knowledgebase server": {
"knowledgebase": {
"command": "docker",
"args": [
"run",
"--interactive",
"--rm",
"--volume",
"knowledgebase:/db",
"mbcrawfo/knowledge-base-server"
]
}
}
}
}McpServers
{
"knowledgebase": {
"command": "docker",
"args": [
"run",
"--interactive",
"--rm",
"--volume",
"knowledgebase:/db",
"mbcrawfo/knowledge-base-server"
]
}
}MCP KnowledgeBase Server
A Model Context Protocol (MCP) server that allows LLMS to store memories during a conversation and search them later. Memories are stored in a SQLite database, and its full text search features power the memory search.
Usage
Two environment variables control the location and filename of the database.
DATABASE_NAME: Use the default location, but a custom db filename. For example, my_custom_db.sqlite.
DATABASE_PATH: Specify the fully path to the db file (ignores DATABASE_NAME). For example, /Users/your_name/.db/my_db.sqlite.
Docker
When using docker you must create a persistent volume to store the database (advanced users can mount a folder from their file system, if desired). Run docker volume create knowledgebase to set it up, then configure the server in your claude_desktop_config.json as below.
If you want to use a custom database file with docker you must use DATABASE_PATH and pass it to the docker command using the --env arg. For example (place these strings in the args array of the config, before the image name), "--env", "DATABASE_PATH=/db/my_db.sqlite".
{
"mcpServers": {
"knowledgebase": {
"command": "docker",
"args": [
"run",
"--interactive",
"--rm",
"--volume", "knowledgebase:/db",
"mbcrawfo/knowledge-base-server"
]
}
}
}
Run locally with dotnet cli
1. You will need the .Net 9 SDK.
2. Clone this repository.
3. Navigate to the repo in your terminal and run dotnet build.
4. Add the config below to claude_desktop_config.json (if you get errors, try specifying the full path to the dotnet cli).
When running locally the default database location is in your Application Data directory.
{
"mcpServers": {
"knowledgebase": {
"command": "dotnet",
"args": [
"run",
"--project", "/full/path/to/repo/src/KnowledgeBaseServer/KnowledgeBaseServer.csproj",
"--no-restore",
"--no-build"
]
}
}
}
Prompts
The server includes a "General Memory Usage" prompt to tell the LLM how to use memory. However you may wish to use a custom prompt to be more specific to your usage.
Development
You can use the app with the --init-db parameter to create or upgrade databases for testing. From the KnowledgeBaseServer project directory, run dotnet run -- --init-db /path/to/db.sqlite.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
