Enables creation and management of markdown notes in local Vimango SQLite databases, with support for organizing notes by contexts and folders, and automatic synchronization with full-text search databases.
Vimango MCP Server
A Model Context Protocol (MCP) server that enables Claude Desktop to write markdown notes directly to the local vimango SQLite databases.
Overview
This MCP server allows Claude to create research notes and other content directly in your vimango note-taking application during conversations. It handles the database insertion logic, allowing seamless integration between Claude Desktop's research capabilities and your local note database.
Architecture
Database Structure
Vimango uses two separate SQLite databases:
vimango.db - Main database containing tasks/notes, contexts, folders, and keywords
fts5_vimango.db - Full-text search database (FTS5) for fast searching
Note Creation Workflow
MCP server creates new entry in
tasktable without settingtid(left NULL until sync assigns it)Entry includes: title, note body, folder_tid, context_tid, timestamps
FTS database is NOT touched - it will be updated during sync
When you sync vimango with the remote server:
Server assigns real
tidto entrySync process updates local FTS database
This design keeps the MCP server simple and leverages vimango's existing sync machinery.
Installation
Prerequisites
Python 3.11 or higher
UV package manager
Vimango application with configured databases
Setup
Configuration
Create a config.json file in the project root:
Usage
Running the MCP Server
Claude Desktop Configuration
Add to your Claude Desktop MCP settings:
Available MCP Tools
create_note - Create a new note with title and markdown body
list_contexts - List available contexts for note categorization
list_folders - List available folders for note organization
Development
Project Structure
Running Tests
Notes
The MCP server creates notes with
tidleft NULL so the server can assign IDs during syncFTS synchronization happens automatically during vimango's normal sync process
Concurrent access is handled by SQLite's locking mechanisms
Research notes are typically created in the "research" folder
License
MIT