Person CRUD MCP Server

An MCP (Model Context Protocol) server that exposes Person CRUD operations as tools for Claude Desktop.

Setup

1. Clone and install

git clone https://github.com/Pearlshaline/person_mcp_server.git
cd person_mcp_server
npm install

2. Configure environment variables

cp .env.example .env
# Edit .env with your Neon database connection strings

3. Generate Prisma Client

npx prisma generate

4. Build

npm run build

5. Configure Claude Desktop

Edit your Claude Desktop config file:

• Windows: %APPDATA%\Claude\claude_desktop_config.json

• Mac: ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "person-crud": {
      "command": "node",
      "args": ["C:/path/to/person-mcp-server/dist/index.js"],
      "env": {
        "DATABASE_URL": "your-pooled-neon-connection-string",
        "DIRECT_URL": "your-direct-neon-connection-string"
      }
    }
  }
}

6. Restart Claude Desktop

Fully quit and reopen Claude Desktop. You should see the 🔨 tools icon.

Related MCP server: PostgreSQL MCP Server for Claude Desktop

Available MCP Tools

Example Prompts in Claude Desktop

• "List all persons in the database"

• "Create a person named John Doe with email john@email.com, age 25, phone + 63 946 882 2314"

• "Get person with ID 2"

• "Update person 2's age to 36"

• "Search for persons named Ana Reyes"

• "Delete person with ID 1"

Tech Stack

• Node.js + TypeScript

• MCP SDK (@modelcontextprotocol/sdk)

• Prisma ORM

• PostgreSQL (Neon)