MCP KnowledgeBase Server
Model Context Protocol (MCP) server allowing LLMs to store and search knowledge in a SQLite database
mbcrawfo
README
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
IMPORTANT - Due to a bug in the .Net MCP library, the server may hang on shutdown. You will need to manually kill the docker container after closing Claude Desktop, and may have dangling dotnet processes if running locally.
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
- You will need the .Net 9 SDK.
- Clone this repository.
- Navigate to the repo in your terminal and run
dotnet build. - 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.
Recommended Servers
Sequential Thinking MCP Server
This server facilitates structured problem-solving by breaking down complex issues into sequential steps, supporting revisions, and enabling multiple solution paths through full MCP integration.
dbt Semantic Layer MCP Server
A server that enables querying the dbt Semantic Layer through natural language conversations with Claude Desktop and other AI assistants, allowing users to discover metrics, create queries, analyze data, and visualize results.
mixpanel
Connect to your Mixpanel data. Query events, retention, and funnel data from Mixpanel analytics.
MCP PubMed Search
Server to search PubMed (PubMed is a free, online database that allows users to search for biomedical and life sciences literature). I have created on a day MCP came out but was on vacation, I saw someone post similar server in your DB, but figured to post mine.
Crypto Price & Market Analysis MCP Server
A Model Context Protocol (MCP) server that provides comprehensive cryptocurrency analysis using the CoinCap API. This server offers real-time price data, market analysis, and historical trends through an easy-to-use interface.
Vectorize
Vectorize MCP server for advanced retrieval, Private Deep Research, Anything-to-Markdown file extraction and text chunking.
Nefino MCP Server
Provides large language models with access to news and information about renewable energy projects in Germany, allowing filtering by location, topic (solar, wind, hydrogen), and date range.
MATLAB MCP Server
Integrates MATLAB with AI to execute code, generate scripts from natural language, and access MATLAB documentation seamlessly.
Macrostrat MCP Server
Enables Claude to query comprehensive geologic data from the Macrostrat API, including geologic units, columns, minerals, and timescales through natural language.
MCP Word Counter
A Model Context Protocol server that provides tools for analyzing text documents, including counting words and characters. This server helps LLMs perform text analysis tasks by exposing simple document statistics functionality.