iflow-mcp-yuzongmin-sqlite-literature-management-fastmcp-mcp-server

# Universal Source Management System A flexible system for managing various types of sources (papers, books, webpages, etc.) and integrating them with knowledge graphs. ## Features ### Core Features - Universal source identification with internal UUID system - Support for multiple source types (papers, webpages, books, videos, blogs) - Multiple identifier support per source (arxiv, DOI, semantic scholar, ISBN, URL) - Structured note-taking with titles and content - Status tracking (unread, reading, completed, archived) ### Entity Integration - Link sources to knowledge graph entities - Track relationships between sources and entities - Flexible relation types (discusses, introduces, extends, etc.) - Integration with memory graph ## Prerequisites This system integrates with the [MCP Memory Server](https://github.com/modelcontextprotocol/servers/tree/main/src/memory) for persistent knowledge graph storage. ## Quick Start 1. Create a new SQLite database with our schema: ```bash # Create a new database sqlite3 sources.db < create_sources_db.sql ``` 2. Install the source management server: ```bash # Install for Claude Desktop with your database path fastmcp install source-manager-server.py --name "Source Manager" -e SQLITE_DB_PATH=/path/to/sources.db ``` ## Schema ### Core Tables ```sql -- Sources table CREATE TABLE sources ( id UUID PRIMARY KEY, title TEXT NOT NULL, type TEXT CHECK(type IN ('paper', 'webpage', 'book', 'video', 'blog')) NOT NULL, identifiers JSONB NOT NULL, status TEXT CHECK(status IN ('unread', 'reading', 'completed', 'archived')) DEFAULT 'unread' ); -- Source notes CREATE TABLE source_notes ( source_id UUID REFERENCES sources(id), note_title TEXT NOT NULL, content TEXT NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (source_id, note_title) ); -- Entity links CREATE TABLE source_entity_links ( source_id UUID REFERENCES sources(id), entity_name TEXT, relation_typ…