Koskamo

Zovo ER Diagram MCP

Turns SQL CREATE TABLE statements from PostgreSQL, MySQL, or SQLite into entity relationship diagrams. It generates PDFs, SVGs, CSVs, and JSON summaries, and includes a schema check for broken foreign keys or missing tables without connecting to a live database.

Visit Zovo

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.

Zovo ER Diagram MCP logo, by ZovoCommunity listingStreamable HTTPNo sign-inEndpoint checked 2026-11-08Published by Zovo
You need:No sign-in is needed.
MCP endpoint (Streamable HTTP)
https://er-diagram.zovo.one/mcp
Vendor documentation

What its tools do

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

Read-only (2)

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

Checks and signals

Each line is separate evidence, not a trust score.

  • Passed Endpoint answered the live check ·
  • Availability 1 of 1 checks passed in 30 days

What you can do with it

  • Draw an ER diagram from SQL CREATE TABLE statements
  • Check schema for broken foreign keys before migration
  • Generate a Tabloid PDF ER diagram of a MySQL dump
  • Export diagram data as SVG, CSV, or JSON

Source and maintenance

Community listingRegistry 1.0.0
mcp-registry: io.github.theluckystrike/er-diagram@1.0.0Project website

Protocol and capabilities

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

Server-provided instructions

Untrusted server output shown for inspection. It is not Koskamo guidance and is excluded from knowledge search.

Zovo ER Diagram draws an entity relationship diagram from SQL CREATE TABLE statements, with PDF, SVG, CSV and JSON downloads. Use make_er_diagram to draw it and check_schema to review the schema without drawing (foreign keys to missing tables or columns, type differences between a foreign key and the column it references, tables without a primary key, duplicate names). It reads CREATE TABLE only and lists every other statement as skipped with its line number. It does not connect to a database. Files of large diagrams are kept for 1 hour so the download links work, then deleted.

Tools

2 advertised

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

Use this when the user wants an ER diagram, entity relationship diagram or database schema diagram drawn from SQL CREATE TABLE statements, for example "draw an ER diagram of this schema" or "make a PDF of my database tables". Takes the DDL text, a dialect (auto, postgres, mysql, sqlite), a page size and an optional title. Reads CREATE TABLE with columns, types, NOT NULL, PRIMARY KEY, UNIQUE and REFERENCES / FOREIGN KEY, including composite keys; lists every other statement as skipped with its line number. Returns counts, relationships with crow's foot cardinality taken from the DDL, schema problems, a geometry check (overlapping tables, lines crossing a table), the PDF page count and smallest text size, an interactive diagram, and PDF, SVG, CSV and JSON downloads. Refuses a CREATE TABLE that does not parse, naming the line. Up to 50 tables. Does not connect to a database or run SQL. Download links of large diagrams expire after about 1 hour.

make_er_diagram input schema
{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "required": [
    "ddl"
  ],
  "properties": {
    "ddl": {
      "type": "string",
      "maxLength": 400000,
      "description": "The SQL DDL text: CREATE TABLE statements with columns, types, NOT NULL, PRIMARY KEY, UNIQUE and REFERENCES / FOREIGN KEY, up to 200,000 characters, e.g. \"CREATE TABLE users (id int PRIMARY KEY, email text NOT NULL UNIQUE); CREATE TABLE orders (id int PRIMARY KEY, user_id int NOT NULL REFERENCES users(id));\". Other statements are listed as skipped."
    },
    "title": {
      "type": "string",
      "maxLength": 400,
      "description": "Title printed on the diagram and used in file names, up to 80 characters, e.g. \"Shop database\"."
    },
    "dialect": {
      "enum": [
        "auto",
        "postgres",
        "mysql",
        "sqlite"
      ],
      "type": "string",
      "description": "Which SQL quoting and type names to read: auto (default; accepts \"x\", `x` and [x]), postgres, mysql or sqlite. It also sets how names are matched: postgres folds unquoted names to lower case and keeps quoted names exact; the others ignore case. Example: postgres."
    },
    "page_size": {
      "enum": [
        "letter",
        "a4",
        "tabloid"
      ],
      "type": "string",
      "description": "PDF page: letter (default), a4 or tabloid (11 x 17 in). Landscape unless portrait needs fewer pages."
    }
  }
}
make_er_diagram output schema
{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "required": [
    "title",
    "dialect",
    "name_rule",
    "counts",
    "tables",
    "relationships",
    "issues",
    "skipped",
    "pdf",
    "layout_check",
    "cardinality_rules",
    "warnings",
    "downloads"
  ],
  "properties": {
    "pdf": {
      "type": "object",
      "propertyNames": {
        "type": "string"
      },
      "additionalProperties": {}
    },
    "shown": {
      "type": "object",
      "propertyNames": {
        "type": "string"
      },
      "additionalProperties": {}
    },
    "title": {
      "type": "string"
    },
    "counts": {
      "type": "object",
      "required": [
        "tables",
        "columns",
        "foreign_keys",
        "relationships_drawn",
        "skipped_statements",
        "errors",
        "warnings"
      ],
      "properties": {
        "errors": {
          "type": "number"
        },
        "tables": {
          "type": "number"
        },
        "columns": {
          "type": "number"
        },
        "warnings": {
          "type": "number"
        },
        "foreign_keys": {
          "type": "number"
        },
        "skipped_statements": {
          "type": "number"
        },
        "relationships_drawn": {
          "type": "number"
        }
      },
      "additionalProperties": false
    },
    "issues": {
      "type": "array",
      "items": {
        "type": "object",
        "propertyNames": {
          "type": "string"
        },
        "additionalProperties": {}
      }
    },
    "tables": {
      "type": "array",
      "items": {
        "type": "object",
        "propertyNames": {
          "type": "string"
        },
        "additionalProperties": {}
      }
    },
    "dialect": {
      "type": "string"
    },
    "skipped": {
      "type": "array",
      "items": {
        "type": "object",
        "propertyNames": {
          "type": "string"
        },
        "additionalProperties": {}
      }
    },
    "warnings": {
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "downloads": {
      "type": "object",
      "properties": {
        "csv": {
          "type": "string"
        },
        "pdf": {
          "type": "string"
        },
        "svg": {
          "type": "string"
        },
        "json": {
          "type": "string"
        }
      },
      "additionalProperties": false
    },
    "name_rule": {
      "type": "string"
    },
    "layout_check": {
      "type": "object",
      "propertyNames": {
        "type": "string"
      },
      "additionalProperties": {}
    },
    "relationships": {
      "type": "array",
      "items": {
        "type": "object",
        "propertyNames": {
          "type": "string"
        },
        "additionalProperties": {}
      }
    },
    "cardinality_rules": {
      "type": "string"
    }
  },
  "additionalProperties": false
}
make_er_diagram annotations
{
  "title": "Make ER diagram",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}
check_schema — Check database schema
Advertised by the server during the last successful anonymous check.
Advertised read-only

Use this when the user wants SQL CREATE TABLE statements checked without a drawing, for example "check my schema for broken foreign keys" or "which tables have no primary key". Takes the same DDL text and dialect as make_er_diagram. Returns foreign keys that point to a missing table or column, foreign keys whose referenced columns are not a primary key or UNIQUE, type differences between a foreign key column and the column it references, tables without a primary key, duplicate table and column names (with the name rule used), and the statements it skipped with line numbers. Draws nothing and makes no files. Does not connect to a database or check data.

check_schema input schema
{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "required": [
    "ddl"
  ],
  "properties": {
    "ddl": {
      "type": "string",
      "maxLength": 400000,
      "description": "The SQL DDL text: CREATE TABLE statements with columns, types, NOT NULL, PRIMARY KEY, UNIQUE and REFERENCES / FOREIGN KEY, up to 200,000 characters, e.g. \"CREATE TABLE users (id int PRIMARY KEY, email text NOT NULL UNIQUE); CREATE TABLE orders (id int PRIMARY KEY, user_id int NOT NULL REFERENCES users(id));\". Other statements are listed as skipped."
    },
    "dialect": {
      "enum": [
        "auto",
        "postgres",
        "mysql",
        "sqlite"
      ],
      "type": "string",
      "description": "Which SQL quoting and type names to read: auto (default; accepts \"x\", `x` and [x]), postgres, mysql or sqlite. It also sets how names are matched: postgres folds unquoted names to lower case and keeps quoted names exact; the others ignore case. Example: postgres."
    }
  }
}
check_schema output schema
{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "required": [
    "dialect",
    "name_rule",
    "ready",
    "counts",
    "tables_without_primary_key",
    "issues",
    "skipped",
    "notes",
    "limits"
  ],
  "properties": {
    "notes": {
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "ready": {
      "type": "boolean"
    },
    "shown": {
      "type": "object",
      "propertyNames": {
        "type": "string"
      },
      "additionalProperties": {}
    },
    "counts": {
      "type": "object",
      "required": [
        "tables",
        "columns",
        "foreign_keys",
        "relationships_drawn",
        "skipped_statements",
        "errors",
        "warnings"
      ],
      "properties": {
        "errors": {
          "type": "number"
        },
        "tables": {
          "type": "number"
        },
        "columns": {
          "type": "number"
        },
        "warnings": {
          "type": "number"
        },
        "foreign_keys": {
          "type": "number"
        },
        "skipped_statements": {
          "type": "number"
        },
        "relationships_drawn": {
          "type": "number"
        }
      },
      "additionalProperties": false
    },
    "issues": {
      "type": "array",
      "items": {
        "type": "object",
        "propertyNames": {
          "type": "string"
        },
        "additionalProperties": {}
      }
    },
    "limits": {
      "type": "object",
      "propertyNames": {
        "type": "string"
      },
      "additionalProperties": {}
    },
    "dialect": {
      "type": "string"
    },
    "skipped": {
      "type": "array",
      "items": {
        "type": "object",
        "propertyNames": {
          "type": "string"
        },
        "additionalProperties": {}
      }
    },
    "name_rule": {
      "type": "string"
    },
    "tables_without_primary_key": {
      "type": "array",
      "items": {
        "type": "string"
      }
    }
  },
  "additionalProperties": false
}
check_schema annotations
{
  "title": "Check database schema",
  "readOnlyHint": true,
  "openWorldHint": false,
  "idempotentHint": true,
  "destructiveHint": false
}

Prompts

Not advertised

No prompt definitions available.

Resources

1 advertised

er-diagram-widget — Zovo ER Diagram view

Advertised by the server during the last successful anonymous check.

Interactive view for Zovo ER Diagram.

er-diagram-widget URI
ui://widget/er-diagram-v1-1.0.0-46b6114bdb0e38bf25fd3dad5e248670214d783e360555dfa0a076051be59b45.html

MIME type: text/html;profile=mcp-app

er-diagram-widget-legacy — Zovo ER Diagram view (previous versions)

Advertised by the server during the last successful anonymous check.

er-diagram-widget-legacy URI template
ui://widget/er-diagram-{version}.html

MIME type: text/html;profile=mcp-app

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
930 ms
95th percentile latency
930 ms

Maintenance history

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

  • · probe · passed · 930 ms · metadata changed · 2 tool(s), 1 resource(s), 1 resource template(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 zovo-er-diagram-mcp https://er-diagram.zovo.one/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 zovo-er-diagram-mcp --url https://er-diagram.zovo.one/mcp

Cursor

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

Cline

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

VS Code

Merge this server into .vscode/mcp.json. Use MCP: List Servers to start zovo-er-diagram-mcp and inspect its tools.
VS Code configuration
{
  "servers": {
    "zovo-er-diagram-mcp": {
      "type": "http",
      "url": "https://er-diagram.zovo.one/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 zovo-er-diagram-mcp https://er-diagram.zovo.one/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://er-diagram.zovo.one/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": {
    "zovo-er-diagram-mcp": {
      "serverUrl": "https://er-diagram.zovo.one/mcp"
    }
  }
}

Let your agent find its tools

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

Connect Koskamo Explore workflows
See all 9,322