@mhoshdev/prompt-store-mcp

A local-only MCP (Model Context Protocol) server for managing AI prompts with SQLite storage. Designed for individual developers to organize prompts without complex web services.

✨ Why Use This?

Your personal prompt library - Store, search, and reuse prompts across all your AI tools.

• Simple & focused - Just prompts, nothing more. No cloud, no accounts, no complexity.
• Works everywhere - Same prompts available in Claude, Cursor, Windsurf, any MCP client.
• 100% local - All data stays on your machine in SQLite. Your prompts, your control.
• Fast search - Find prompts by keyword or filter by tags instantly.
• Zero setup - One command with npx, no configuration needed.

📦 Installation

# Run directly with npx (recommended)
npx @mhoshdev/prompt-store-mcp

# Or install globally
npm install -g @mhoshdev/prompt-store-mcp
prompt-store-mcp

⚙️ MCP Client Configuration

Claude Desktop

Add to ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows):

{
  "mcpServers": {
    "prompt-store": {
      "command": "npx",
      "args": ["@mhoshdev/prompt-store-mcp"]
    }
  }
}

Cursor IDE

Add to your Cursor MCP settings:

{
  "mcpServers": {
    "prompt-store": {
      "command": "npx",
      "args": ["@mhoshdev/prompt-store-mcp"]
    }
  }
}

Windsurf

Add to your Windsurf MCP configuration:

{
  "mcpServers": {
    "prompt-store": {
      "command": "npx",
      "args": ["@mhoshdev/prompt-store-mcp"]
    }
  }
}

CLI Options

# Start MCP server (default)
npx @mhoshdev/prompt-store-mcp

# Reset database (clear all data, keep schema)
npx @mhoshdev/prompt-store-mcp --reset

🛠️ Available Tools

| Tool | Description | |------|-------------| | add_prompt | Store a new prompt with optional tags | | list_prompts | List prompts with pagination | | get_prompt | Retrieve full prompt by ID | | update_prompt | Update prompt title, content, and tags | | delete_prompt | Permanently remove a prompt | | search_prompts | Search by keyword in title/content | | filter_by_tags | Filter prompts by tags (OR logic) | | list_tags | List all tags with prompt counts |

💡 Example Usage

Store a Prompt

Use add_prompt with:
- title: "Code Review Assistant"
- content: "You are a senior code reviewer. Analyze code for bugs, security issues, and suggest improvements."
- tags: ["coding", "review"]

Search Prompts

Use search_prompts with:
- query: "review"

Filter by Tags

Use filter_by_tags with:
- tags: ["coding", "review"]

💾 Data Storage

• Location: ~/.prompt-store/prompts.db
• Format: SQLite database
• Permissions: User-only read/write (600)

🔧 Development

# Install dependencies
pnpm install

# Build
pnpm build

# Run tests
pnpm test

# Type check
pnpm typecheck

🔍 Troubleshooting

Server won't start

1. Ensure Node.js v20+ is installed: node --version
2. Check database directory permissions: ls -la ~/.prompt-store
3. View error logs: errors output to stderr

Database corruption

1. Backup: cp ~/.prompt-store/prompts.db ~/.prompt-store/prompts.db.backup
2. Reset: npx @mhoshdev/prompt-store-mcp --reset
3. Re-add prompts

MCP client can't connect

1. Verify MCP client configuration path is correct
2. Restart MCP client after configuration changes
3. Ensure npx @mhoshdev/prompt-store-mcp runs successfully in terminal

License

MIT