What is Knowledgebaseserver

KnowledgeBaseServer is a Model Context Protocol (MCP) server that enables Large Language Models (LLMs) to store and retrieve knowledge in a SQLite database during conversations.

Use cases

Use cases include enhancing chatbots with memory, providing personalized user experiences in applications, and enabling context-aware interactions in virtual environments.

How to use

To use KnowledgeBaseServer, set two environment variables: DATABASE_NAME for the database filename and DATABASE_PATH for the full path to the database file. It can be run using Docker or locally with the .Net CLI.

Key features

Key features include the ability to store memories during conversations, full-text search capabilities provided by SQLite, and support for Docker for easy deployment.

Where to use

KnowledgeBaseServer can be used in various fields such as customer support, virtual assistants, educational tools, and any application requiring conversational memory management.

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.