MCP Mermaid ER Server

Example Use Cases

• 1

  Convert Mermaid ER diagrams into PostgreSQL database schemas automatically.

• 2

  Quickly generate REST and GraphQL CRUD APIs based on database entities.

• 3

  Validate and manage ER diagrams and their corresponding database schemas.

Description

This MCP server enables users to parse Mermaid ER diagrams, automatically generate and execute PostgreSQL DDL to create database schemas, and expose REST and GraphQL APIs for CRUD operations. It supports key detection for primary, foreign, and unique keys, and is configurable via environment variables. The server streamlines database and API setup from ER diagrams, facilitating rapid development and integration.