Janadasroor/pg-mnemosyne-mcp

Pg-Mnemosyne MCP

A Model Context Protocol (MCP) server that provides AI assistants with a robust "super memory", task tracker, and dynamic PostgreSQL database management capabilities.

⚡ Quick Start

1. Install the package globally:

   • Windows:

     pip install pg-mnemosyne-mcp
     

   • macOS / Linux:

     pipx install pg-mnemosyne-mcp
     

     (If you prefer standard pip or don't have pipx, run: pip install pg-mnemosyne-mcp --break-system-packages)

2. Auto-configure all your AI agents (Claude, Gemini, Qwen, Cursor, etc.) at once:

   pg-mnemosyne init --dsn "postgresql://user:password@localhost:5432/postgres"
   

   (Be sure to replace user and password with your actual PostgreSQL username and database password!)

3. Restart your AI agents. You're done!

Features

• High-Performance: Uses cached connection pooling (asyncpg.create_pool) for instant sub-millisecond database queries.
• Dynamic Projects: The AI can create new databases for different projects on the fly.
• Dynamic Schema: The AI can modify table schemas dynamically to adapt to changing memory needs.
• Standard Memory Tracker: Built-in support for tracking, updating, and deleting memory items with tags.
• Advanced Task Management: Dedicated tasks schema with fields for status transitions, priority, and deadlines.
• Multi-Agent Coordination: Centralized session tracking preventing duplicate coding and file-editing conflicts.
• Raw SQL Execution: Gives AI ultimate flexibility for complex queries and DDL operations.