@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.
Easy setup - One npx command, no install needed.

📦 Installation

No installation needed. Just use npx:

npx -y @mhoshdev/prompt-store-mcp@latest

Note: Requires Node.js 20+.

⚙️ 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": ["-y", "@mhoshdev/prompt-store-mcp@latest"]
    }
  }
}

Cursor IDE

Add to your Cursor MCP settings:

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

Windsurf

Add to your Windsurf MCP configuration:

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

For CLI access (e.g., --reset): npx -y @mhoshdev/prompt-store-mcp@latest --reset

CLI Options

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

# Reset database (clear all data, keep schema)
npx -y @mhoshdev/prompt-store-mcp@latest --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

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

Database corruption

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

MCP client can't connect

Verify MCP client configuration path is correct
Restart MCP client after configuration changes
Ensure npx -y @mhoshdev/prompt-store-mcp@latest runs successfully in terminal

License

MIT

Prompt Store MCP