Reference Servers · MODEL CONTEXT PROTOCOL
a21071 mcp postgres
MCP example for postgres
WHAT IT CONNECTS
What a21071 mcp postgres gives an 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
An MCP listing is not a security review
An MCP server may receive model context, credentials, local files, or permission to call external systems. Review its code, requested environment variables, network behavior, package provenance, and maintenance status before connecting it to an agent.