Schema | MCP Mermaid ER Server

MCP Mermaid ER Server

Describes the environment variables required to run the server.

Name	Required	Description	Default
`DB_HOST`	Yes	PostgreSQL host
`DB_NAME`	Yes	PostgreSQL database name
`DB_PORT`	No	PostgreSQL port	5432
`DB_USER`	Yes	PostgreSQL user
`API_HOST`	No	API server host	0.0.0.0
`API_PORT`	No	API server port	3000
`API_TYPE`	No	API type: rest, graphql, or both	rest
`DB_PASSWORD`	Yes	PostgreSQL password
`MERMAID_DIAGRAM_PATH`	Yes	Path to the Mermaid ER diagram file

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Features and capabilities supported by this server

Protocol revision2025-11-25

Capability	Details
`tools`	{ "listChanged": true }

Functions exposed to the LLM to take actions

Name	Description
parse_er_diagramB	Parse a Mermaid ER diagram and extract the complete database schema including entities, attributes, and relationships.
list_entitiesC	List all entities (tables) in the ER diagram with their names and aliases.
get_entity_detailsA	Get detailed information about a specific entity including all its attributes, types, and keys (PK, FK, UK).
get_relationshipsB	Get all relationships between entities in the ER diagram with cardinality information.
validate_diagramB	Validate a Mermaid ER diagram for syntax errors and structural issues.
test_connectionA	Test the PostgreSQL database connection. Returns success or error message.
generate_sqlA	Generate SQL DDL statements from the ER diagram without executing them. Useful for reviewing the SQL before creating tables.
create_schemaA	Create PostgreSQL tables from the ER diagram. This will execute DDL statements to create tables and foreign key constraints.
drop_schemaA	Drop all tables defined in the ER diagram. WARNING: This will delete all data!
start_api_serverA	Start the REST/GraphQL API server for the entities in the ER diagram.
stop_api_serverB	Stop the running API server.
get_api_endpointsB	Get information about the running API server and its endpoints.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

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