Skip to main content
Glama

@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.

Related MCP server: mcp-hub

📦 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

  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 -y @mhoshdev/prompt-store-mcp@latest --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 -y @mhoshdev/prompt-store-mcp@latest runs successfully in terminal

License

MIT

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      C
      maintenance
      A lightweight, file-based server for managing and serving personal prompt templates with variable substitution support via the Model Context Protocol. It allows users to store, update, and organize prompts in a local directory through integrated MCP tools and CLI assistants.
      7
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      A self-hosted remote MCP server that provides reusable prompts and development conventions across various AI tools. It features a modular architecture for organizing and namespacing custom prompts to streamline AI-assisted coding workflows.
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      An MCP server that enables users to manage, search, and apply specialized AI personas within Claude Desktop and Claude Code CLI. It features a local-first architecture with YAML-based storage for organizing curated prompts and role collections.
      1
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      A local-first MCP server providing persistent, searchable knowledge base via SQLite, enabling AI agents to save and recall facts across sessions without cloud dependencies.
      13 PyPI
      MIT