Reference Servers · MODEL CONTEXT PROTOCOL

a21071 mcp postgres

MCP example for postgres

WHAT IT CONNECTS

a21071 mcp postgres 为 AI Agent 提供什么

  • CRUD operations for User and Post entities
  • Type-safe database operations using Prisma
  • MCP-compatible tool interface
  • Built with TypeScript for type safety
  • Clone the repository
  • Install dependencies:
  • Set up PostgreSQL database:
  • Run database migrations:
  • Build the project:
  • **getData**: Retrieve user data from PostgreSQL
  • **addUserData**: Add new user to database
  • **deleteUserData**: Delete user by ID, email or name
  • **updateUserData**: Update user information
  • Watch mode:
  • [@modelcontextprotocol/sdk](https://github.com/modelcontextprotocol/sdk) - MCP server SDK
  • [Prisma](https://www.prisma.io/) - Type-safe database client
  • [TypeScript](https://www.typescriptlang.org/) - Type checking

SECURITY

MCP 收录不等于安全审核

MCP 服务器可能获得模型上下文、凭据、本地文件或调用外部系统的权限。连接 Agent 前,请检查代码、环境变量、网络行为、软件包来源与维护状态。