Koskamo

ErdDocs MCP

An MCP server that allows AI coding agents to generate interactive ER diagrams and data dictionaries from database schemas. It accepts SQL dumps, Prisma schemas, DBML, Mermaid, PlantUML, and various ORM models (Django, SQLAlchemy, Sequelize, TypeORM, Laravel). The server processes the schema locally in the browser via a generated link, ensuring no data is stored on the server, and returns a URL to the visual diagram and documentation.

Endpoint and access

No sign-in to connect and list tools. Individual tools may still need a vendor account, credentials, or permissions; check the documented prerequisites.

ErdDocs MCP logo, by ErdDocsVendor evidenceStreamable HTTPNo sign-inEndpoint checked 2026-11-06Operated by ErdDocs
MCP endpoint (Streamable HTTP)
https://erddocs.com/mcp
Vendor documentation

What its tools do

1 tool, grouped by the hints the server advertises. Hints are self-declared, not verified behavior.

Read-only (1)

1 of 1 have a description · 1 of 1 declare behavior hints · 1 of 1 with parameters document them all

Checks and signals

Each line is separate evidence, not a trust score.

  • Passed Endpoint answered the live check ·
  • Passed Official MCP Registry namespace is tied to erddocs.com ·
  • Passed Endpoint is on the registry namespace domain ·
  • Availability 1 of 1 checks passed in 30 days

What you can do with it

  • Generate ER diagrams from SQL dumps or ORM models
  • Create printable data dictionaries for database schemas
  • Visualize database relations and table structures in AI agents

Source and maintenance

Vendor evidenceRegistry 1.0.1

Protocol and capabilities

Server
erddocs 1.0.0
MCP protocol negotiated in check
2025-11-25
Tools
1 advertised
Resources
Not advertised
Resource templates
Not advertised
Prompts
Not advertised
Server-advertised capabilities
{
  "tools": {
    "listChanged": true
  }
}

Tools

1 advertised

open_er_diagram — Open ER diagram
Advertised by the server during the last successful anonymous check.
Advertised read-only

Open an interactive ER diagram of a database schema on erddocs.com. Use it when the user wants to see, understand, review or document their database structure, or asks for an ER diagram. Pass the schema text exactly as it is in the project. It reads SQL dumps and DDL (PostgreSQL, MySQL, SQL Server, SQLite), Prisma schema.prisma, DBML, Mermaid erDiagram, PlantUML, Django models.py, SQLAlchemy models, Sequelize models, TypeORM entities and a folder of Laravel migrations (concatenate the files). For SQL, the structure is enough: no INSERT data. Returns a link. The user opens it in a browser and gets the diagram with every table and relation laid out, relations without declared foreign keys found by column name and drawn dashed, and a data dictionary. Nothing is stored on the server: the schema travels inside the link and is parsed in the user's browser. A link holds a schema of a few dozen tables (about 100–200 characters of link per table, depending on comments); for a larger one the tool says so and the user pastes it on erddocs.com instead.

open_er_diagram input schema
{
  "type": "object",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "required": [
    "schema"
  ],
  "properties": {
    "format": {
      "enum": [
        "sql",
        "prisma",
        "dbml",
        "mermaid",
        "plantuml",
        "django",
        "sqlalchemy",
        "sequelize",
        "typeorm",
        "laravel"
      ],
      "type": "string",
      "description": "Only if automatic detection would get it wrong."
    },
    "schema": {
      "type": "string",
      "maxLength": 2000000,
      "minLength": 1,
      "description": "The schema text as it is: SQL DDL, schema.prisma, models.py, migrations, DBML, Mermaid or PlantUML."
    }
  }
}
open_er_diagram annotations
{
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true
}

Prompts

Not advertised

No prompt definitions available.

Resources

Not advertised

No resource definitions available.

90-day uptime

A lightweight connection check about every six hours, sampled on hosts with many listings. It shows the server answered, not that its tools work.

Too few checks for a percentage yet (3 of 3 answered).

  1. 2026-11-07: 2 of 2 checks answered
  2. 2026-11-09: 1 of 1 checks answered

30-day availability

Aggregated from read-only remote checks; this is not a tool-execution or security guarantee.

Successful checks
1 of 1 (100%)
Average latency
627 ms
95th percentile latency
627 ms

Maintenance history

Public check and source-refresh events. Editorial and ownership records remain private.

  • · probe · passed · 627 ms · metadata changed · 1 tool(s)

Connect from your client

Each snippet registers the same endpoint; pick the client you use.

This server is operated by the named third party. Listing and endpoint checks are not an endorsement or a security audit. Review the operator's permissions, terms, and data handling before connecting. How listings are checked and corrected.

Claude Code

Run this once in a terminal. It registers the remote server. Use --scope project to write .mcp.json for the repo.
Claude Code configuration
claude mcp add --transport http erddocs-mcp https://erddocs.com/mcp

Codex

Run this once. Codex stores MCP servers in ~/.codex/config.toml (or .codex/config.toml in a trusted project).
Codex configuration
codex mcp add erddocs-mcp --url https://erddocs.com/mcp

Cursor

Merge this server into .cursor/mcp.json in your project, then enable erddocs-mcp in your MCP settings.
Cursor configuration
{
  "mcpServers": {
    "erddocs-mcp": {
      "url": "https://erddocs.com/mcp"
    }
  }
}

Cline

Merge this into cline_mcp_settings.json (Cline → MCP Servers → Configure).
Cline configuration
{
  "mcpServers": {
    "erddocs-mcp": {
      "type": "streamableHttp",
      "url": "https://erddocs.com/mcp",
      "disabled": false
    }
  }
}

VS Code

Merge this server into .vscode/mcp.json. Use MCP: List Servers to start erddocs-mcp and inspect its tools.
VS Code configuration
{
  "servers": {
    "erddocs-mcp": {
      "type": "http",
      "url": "https://erddocs.com/mcp"
    }
  }
}

Gemini CLI

Run this once. It writes .gemini/settings.json in the current project; pass --scope user for ~/.gemini/settings.json.
Gemini CLI configuration
gemini mcp add --transport http erddocs-mcp https://erddocs.com/mcp

Claude Desktop

Open Claude Settings > Connectors > Add custom connector, enter this server URL and enable it for the conversation. This is a manual remote-connector handoff, not a desktop JSON configuration.
Claude Desktop configuration
https://erddocs.com/mcp

Windsurf

Merge this into ~/.codeium/windsurf/mcp_config.json, then refresh MCP in Cascade. Windsurf remote servers use serverUrl, not url.
Windsurf configuration
{
  "mcpServers": {
    "erddocs-mcp": {
      "serverUrl": "https://erddocs.com/mcp"
    }
  }
}

Let your agent find its tools

Find servers like ErdDocs MCP from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.

Do you run ErdDocs MCP?

Prove ownership with a DNS record, a well-known file, or your Official MCP Registry entry, and your edits publish immediately. Proofs are re-checked weekly; admins can still hide or remove a listing.

Claim this listing