mcp-postgres

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:

git clone https://github.com/a21071/mcp-postgres.git
cd mcp-postgres
npm install

3. Set up PostgreSQL database:

docker-compose up -d

4. Run database migrations:

npx prisma migrate dev

5. Build the project:

npm run build

Usage

Run the server:

npm start

Available MCP Tools

• getData: Retrieve user data from PostgreSQL

  {
    "tableName": "user"
  }

  Copy

• addUserData: Add new user to database

  {
    "email": "[email protected]",
    "name": "John Doe",
    "age": 30
  }

  Copy

• deleteUserData: Delete user by ID, email or name

  {
    "id": "clxyz...",
    "email": "[email protected]",
    "name": "John Doe"
  }

  Copy

• updateUserData: Update user information

  {
    "id": "clxyz...",
    "email": "[email protected]",
    "name": "New Name"
  }

  Copy

Database Schema

The server uses the following Prisma schema:

model User {
  id        String   @id @default(cuid())
  email     String   @unique
  name      String?
  age       Int?
  createdAt DateTime @default(now())
  posts     Post[]
}

Development

• Watch mode:

npm run watch

Dependencies

• https://github.com/modelcontextprotocol/sdk - MCP server SDK
• https://www.prisma.io/ - Type-safe database client
• https://www.typescriptlang.org/ - Type checking

License

MIT