mcp

mcp

3.4

If you are the rightful owner of mcp 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.

The Model-Context-Protocol (MCP) provides a structured way for LLMs to interact with external systems via APIs.

The Model-Context-Protocol (MCP) is a framework that allows large language models (LLMs) to interact with external systems through well-defined API calls. This protocol is designed to enhance the capabilities of LLMs by enabling them to access and manipulate data stored in external databases, perform complex operations, and integrate seamlessly with various platforms. Prisma offers two types of MCP servers: a local server for developers working on their machines and a remote server for AI platforms that manage databases for users. The local server is ideal for individual developers who need AI assistance with database workflows, while the remote server is suited for platforms that provide database management capabilities to their users. Both servers expose a range of tools that facilitate database operations such as creating backups, executing SQL queries, and managing connection strings.

Features

  • Local and Remote Servers: Offers both local and remote MCP servers to cater to different user needs.
  • Tool Integration: Provides a variety of tools for database management and operations.
  • JSON-based Configuration: Utilizes a standard JSON format for server configuration.
  • Platform Compatibility: Compatible with various AI tools and platforms for seamless integration.
  • Enhanced LLM Capabilities: Extends the functionality of LLMs by enabling API-based interactions with external systems.

Tools

  1. CreateBackupTool

    Create a new managed Prisma Postgres Backup.

  2. CreateConnectionStringTool

    Create a new Connection String for a Prisma Postgres database with the given id.

  3. CreateRecoveryTool

    Restore a Prisma Postgres Database to a new database with the given Backup id.

  4. DeleteConnectionStringTool

    Delete a Connection String with the given connection string id.

  5. DeleteDatabaseTool

    Delete a Prisma Postgres database with the given id.

  6. ListBackupsTool

    Fetch a list of available Prisma Postgres Backups for the given database id and environment id.

  7. ListConnectionStringsTool

    Fetch a list of available Prisma Postgres Database Connection Strings for the given database id and environment id.

  8. ListDatabasesTool

    Fetch a list of available Prisma Postgres Databases for user's workspace.

  9. ExecuteSqlQueryTool

    Execute a SQL query on a Prisma Postgres database with the given id.

  10. IntrospectSchemaTool

    Introspect the schema of a Prisma Postgres database with the given id.

  11. migrate-status

    Checks your migration status via the prisma migrate status command.

  12. migrate-dev

    Creates and executes a migration via the prisma migrate dev --name command.

  13. migrate-reset

    Resets your database via the prisma migrate reset --force command.

  14. Prisma-Postgres-account-status

    Checks your authentication status with Prisma Console via the platform auth show --early-access command.

  15. Create-Prisma-Postgres-Database

    Creates a new Prisma Postgres database via the 'init --db --name' '--region' '--non-interactive' command.

  16. Prisma-Login

    Authenticates with Prisma Console via the platform auth login --early-access command.

  17. Prisma-Studio

    Open Prisma Studio via the prisma studio command.