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