Janadasroor/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**:
* **macOS / Linux**:
*(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:**
*(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.
Setup
Users will need to provide their PostgreSQL credentials using the PG_BASE_DSN environment variable. This is a standard connection string:
postgresql:// : @ : /
Where to configure this (Client Setup)
The exact location depends on which AI client you are using. You need to add the server configuration to your client's MCP settings file.
**For Claude Desktop:**
- **Mac:** ~/Library/Application Support/Claude/claude_desktop_config.json
- **Windows:** %APPDATA%\Claude\claude_desktop_config.json
**For Cursor:**
- Go to Settings > Features > MCP and add a new MCP server, or edit your project's .cursor/mcp.json.
**For Roo Code / Cline (VS Code):**
- Edit the MCP settings file located at ~/Library/Application Support/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json (Mac) or the equivalent Windows path.
**For Gemini CLI & Qwen CLI:**
- Open your global configuration file (usually located at ~/.gemini/settings.json or ~/.qwen/settings.json).
- Alternatively, use the CLI:
**For Claude Code CLI:**
- The easiest way is to add it via the CLI:
- Manually, it lives in your global config at ~/.claude.json.
**For Codex CLI:**
- The easiest way is to add it via the CLI:
- Manually, it lives in your global config at ~/.codex/config.toml (TOML format).
**For Windsurf IDE:**
- Edit your global config at ~/.codeium/windsurf/mcp_config.json.
- Alternatively, click the **Hammer (MCP) icon** in the Cascade panel and select **Configure**.
**For Antigravity CLI (agy):**
Antigravity uses a plugin-based system. To add the server:
1. Create a plugin directory: mkdir -p ~/.gemini/config/plugins/pg-mnemosyne
2. Create ~/.gemini/config/plugins/pg-mnemosyne/mcp_config.json with the **Standard Template** below.
3. Add an entry to your ~/.gemini/config/import_manifest.json under the "imports" array: