MCP PostgreSQL Server

MCP PostgreSQL Server

-

A Model Context Protocol (MCP) server that provides PostgreSQL database operations through MCP tools.

Features

• CRUD operations for User and Post entities
• Type-safe database operations using Prisma
• MCP-compatible tool interface
• Built with TypeScript for type safety

Installation

1. Clone the repository
2. Install dependencies:

3. Set up PostgreSQL database:

4. Run database migrations:

5. Build the project:

Usage

Run the server:

Available MCP Tools

• getData: Retrieve user data from PostgreSQL
  { "tableName": "user" }
• addUserData: Add new user to database
  { "email": "user@example.com", "name": "John Doe", "age": 30 }
• deleteUserData: Delete user by ID, email or name
  { "id": "clxyz...", "email": "user@example.com", "name": "John Doe" }
• updateUserData: Update user information
  { "id": "clxyz...", "email": "new@example.com", "name": "New Name" }

Database Schema

The server uses the following Prisma schema:

Development

• Watch mode:

Dependencies

• @modelcontextprotocol/sdk - MCP server SDK
• Prisma - Type-safe database client
• TypeScript - Type checking

License

MIT