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 前,请检查代码、环境变量、网络行为、软件包来源与维护状态。