zenstack-mcp-auth

jiashengguo/zenstack-mcp-auth

3.4

If you are the rightful owner of zenstack-mcp-auth and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

ZenStack Remote MCP Server with Authorization is a streamable HTTP server that supports auto-generated CRUD tools for database models with authorization and credential authentication.

The ZenStack Remote MCP Server is a robust Model Context Protocol (MCP) Streamable HTTP server designed to facilitate seamless CRUD operations on database models with integrated authorization and credential authentication. This server is particularly useful for applications that require multiple simultaneous connections, ensuring secure and efficient data management. By leveraging ZenStack integration, the server automatically generates MCP tools for models defined in the ZenStack schema, streamlining the development process. In this demonstration, a simple blog application with 'User' and 'Post' models is used to showcase the server's capabilities. The server supports a wide range of operations, including finding, creating, updating, and deleting records, as well as more advanced functions like aggregation and grouping. With its comprehensive feature set, the ZenStack Remote MCP Server is an ideal solution for developers looking to implement secure and scalable data management in their applications.

Features

  • MCP Streamable HTTP Protocol: Supports multiple simultaneous server connections with credential authentication.
  • ZenStack Integration: Automatically generates MCP tools for CRUD operations based on the ZenStack schema.
  • Comprehensive CRUD Operations: Includes tools for finding, creating, updating, and deleting records.
  • Advanced Data Management: Supports aggregation, grouping, and counting operations.
  • Authorization and Authentication: Ensures secure access to data with integrated authorization and credential authentication.

Tools

  1. findUnique

    Finds a unique record based on specified criteria.

  2. findFirst

    Finds the first record that matches the specified criteria.

  3. findMany

    Finds multiple records that match the specified criteria.

  4. create

    Creates a new record in the database.

  5. createMany

    Creates multiple new records in the database.

  6. delete

    Deletes a record from the database.

  7. deleteMany

    Deletes multiple records from the database.

  8. update

    Updates an existing record in the database.

  9. updateMany

    Updates multiple records in the database.

  10. upsert

    Creates or updates a record in the database.

  11. aggregate

    Performs aggregation operations on records.

  12. groupBy

    Groups records based on specified criteria.

  13. count

    Counts the number of records that match specified criteria.