Generates type-safe GraphQL queries and mutations for all entities.
Parses Mermaid ER diagrams to extract entities, attributes, and relationships for database schema generation.
Automatically creates PostgreSQL tables from ER diagrams and generates CRUD APIs.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@MCP Mermaid ER Server Parse my ER diagram and create the tables"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
An open-source Model Context Protocol (MCP) server that parses Mermaid ER diagrams, creates PostgreSQL database tables, and exposes automatic REST/GraphQL CRUD APIs.
🔍 Parse Mermaid ER Diagrams - Extract entities, attributes, and relationships
🗄️ Auto-Create PostgreSQL Tables - Generate DDL and execute against your database
🚀 REST API Generation - Automatic CRUD endpoints for all entities
📊 GraphQL API Generation - Type-safe queries and mutations
🔑 Key Detection - Identifies PK, FK, and UK constraints
⚙️ Configurable - Environment variables for database and API settings
Related MCP server: PostgreSQL MCP Server
git clone https://github.com/yourusername/mcp-mermaid-er-server.git
cd mcp-mermaid-er-server
npm install
npm run buildCreate a .env file (copy from .env.example):
# Mermaid Source
MERMAID_DIAGRAM_PATH=./examples/sample-er.mmd
# Database (PostgreSQL)
DB_HOST=localhost
DB_PORT=5432
DB_NAME=mydb
DB_USER=postgres
DB_PASSWORD=password
# API Server
API_TYPE=rest # rest, graphql, or both
API_PORT=3000
API_HOST=0.0.0.0Add to claude_desktop_config.json:
{
"mcpServers": {
"mermaid-er": {
"command": "node",
"args": ["/path/to/mcp-tools/dist/index.js"],
"env": {
"MERMAID_DIAGRAM_PATH": "/path/to/your/diagram.mmd",
"DB_HOST": "localhost",
"DB_NAME": "mydb",
"DB_USER": "postgres",
"DB_PASSWORD": "password"
}
}
}
}Tool | Description |
| Parse ER diagram, return full schema |
| List all entity names |
| Get attributes for an entity |
| Get all relationships |
| Validate diagram syntax |
Tool | Description |
| Test PostgreSQL connection |
| Generate DDL without executing |
| Create tables in database |
| Drop all tables (requires confirmation) |
Tool | Description |
| Start REST/GraphQL server |
| Stop the API server |
| List all endpoints |
Parse your ER diagram → parse_er_diagram
Review the SQL → generate_sql
Create database tables → create_schema
Start the API server → start_api_server
Use the auto-generated endpoints!
API_TYPE=rest or both)GET /api/{entity} - List all records
GET /api/{entity}/:id - Get by ID
POST /api/{entity} - Create record
PUT /api/{entity}/:id - Update record
DELETE /api/{entity}/:id - Delete recordAPI_TYPE=graphql or both)# Queries
query { customers { customer_id email } }
query { customer(id: "1") { email } }
# Mutations
mutation { createCustomer(input: { email: "test@example.com" }) { customer_id } }
mutation { updateCustomer(id: "1", input: { email: "new@example.com" }) { email } }
mutation { deleteCustomer(id: "1") { customer_id } }erDiagram
CUSTOMER {
int customer_id PK "Primary key"
string email UK "Unique email"
string name
}
ORDER {
int order_id PK
int customer_id FK
datetime order_date
}
CUSTOMER ||--o{ ORDER : "places"npm run dev # Run with ts-node
npm run build # Compile TypeScript
npm test # Run testsMIT License - see LICENSE
This server cannot be installed
Unclaimed servers have limited discoverability.
If you are the server author, to access and configure the admin panel.
Generate dynamic Mermaid diagrams and charts with AI assistance. Customize styles and export diagr…
Query PostgreSQL databases in plain English — LLM-generated, safety-validated SQL.
Let Claude, Cursor, or ChatGPT author Mermaid diagrams your team can read and share.
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/dixitayush/mcp-api'
If you have feedback or need assistance with the MCP directory API, please join our Discord server