io.github.sqemo/sqemo

Auto-arranges entities by relationships (dagre LR). Entities with no relationship are placed in a grid below the connected ones instead of a single vertical column (2.8.2+). v5 has a single shared layout (no separate logical/physical placement — the removed `view` parameter had no other effect). Reference copies, notes, and relationship waypoints are not moved.

Checks whether a live database (url) or a schema dump (schemaSql) has drifted from the ERD's physical model. Errors: missing/extra tables and columns, PK/FK/NOT NULL mismatches. Warnings (strict promotes to errors): type/unique/auto-increment representation differences. Read-only; the database URL never leaves this process. Pro plan required; requires login.

Checks a logical name against the team naming standard (word list + rules). With physicalName, compares it to the generated name (providedMatches). With a {workspaceId} source, reads the latest workspace-standard master.

Creates a new ERD — empty or from SQL/DBML text. With a {file} target it saves locally; with {server:true} it saves to the server (login required). Pass workspaceId to bind it to that workspace's naming standard from the start.

Deletes an attribute.

Deletes a glossary entry. Standard-linked (glossaryLink) dictionaries are rejected with dictionary_is_linked.

Deletes a domain (attributes referencing it are unlinked).

Deletes an entity (including its relationships).

Deletes a relationship (including derived FKs).

Compares two ERD sources (entities/attributes/domains/relationships — unchanged omitted). A dry run before full-replace import_sql/import_dbml. A side freshly parsed from text has different ids, so most items appear as added/removed — matching the actual import behavior (full replace). summary aggregates entities only; see the arrays for domain/relationship changes.

Generates a migration (ALTER) script from the physical diff between a baseline and the current model — renames stay renames (stable-id matching), destructive changes come commented out, unsupported changes are flagged as [WARNING] comments. Baselines from the same project lineage ({file}/{erdId}) preserve renames; freshly parsed SQL/DBML text falls back to name matching. Pro plan required; requires login.

Exports the project as DBML text.

Exports the physical model as CREATE TABLE SQL. Without dialect, uses the project dialect.

Generates a physical name from a logical name via the word list and naming rules (unregistered words go to warnings). With a {workspaceId} source, reads the latest workspace-standard master.

Entity detail (attributes and physical mapping). Prefers entityId; otherwise exact logicalName match (first hit on duplicates).

Returns an ERD summary (entity/relationship/domain/word-list stats, standard link status).

Fully replaces an existing ERD with the DBML parse result (project id preserved, dialect fixed to mysql). Rejected as invalid_source when no tables are found.

Fully replaces an existing ERD with the SQL parse result (project id preserved). Rejected as invalid_source when no tables are found.

Imports the schema of a live PostgreSQL/MySQL database into an existing ERD (full replace, project id preserved). Read-only — queries only the information schema/catalog; never reads table data. The database URL is used by this local process only and is never sent to Sqemo servers. Pro plan required; requires login.

Lints the whole project — structure (PKs, attributes, descriptions, domains), referential integrity, duplicate physical names (including names that differ only by case, which collide on case-insensitive databases), duplicate logical entity names, identifier length limits (dialect-aware, tables/columns/indexes/FK constraints), auto-increment on non-integer column types (dialect-aware), and the naming standard (unregistered words, physical-name drift) in one pass. Quality/standards oriented, unlike validate_erd (structural validity).

Lists domain definitions (name, data type). With a {workspaceId} source, reads the latest workspace-standard master.

Lists entities (logical name, physical name, attribute count).

Lists server ERDs (owned/shared). Owner and shared editors can both write. Requires login — `npx sqemo-mcp login`.

Lists the workspace-standard proposal queue (word/domain, newest first, mine = my proposals). Filterable by status. Requires login.

Lists relationships (endpoint entity names, cardinality, identifying flag).

Lists my workspaces (owner first) and whether a standard (word list + naming rules) exists. Requires login.

Proposes a new word for the workspace standard's word list (the owner approves/rejects in the web app). source is {workspaceId} or a standard-linked ERD ({file}/{erdId}, resolved via glossaryLink). Registered words return already_exists; a pending duplicate returns already_proposed. Requires login.

Partial-match word-list search across logical/physical/abbreviation/English/synonyms (case-insensitive, max 50). With a {workspaceId} source, reads the latest workspace-standard master.

Partially updates the naming rules (delimiter, case, unknown-word handling, self-reference role prefix). Existing physical names are not regenerated retroactively (noted in warnings) — set the rules before modelling.

Creates an attribute (no attributeId, logicalName required) or updates one (attributeId given, only provided fields change). primaryKey=true forces nullable=false and propagates child FKs. With a domain, the domain decides the data type. autoIncrement marks the column as identity — exported as AUTO_INCREMENT (mysql/cubrid/h2), IDENTITY(1,1) (sqlserver), or GENERATED BY DEFAULT AS IDENTITY (postgres/oracle); it applies to primary keys only.

Bulk form of upsert_attribute: creates/updates many attributes — across any number of entities — in ONE load/save (use this instead of calling upsert_attribute in a loop; each single call costs several server requests and counts against the per-minute cap). Same per-item semantics, applied in order (primaryKey propagates child FKs; a domain decides the data type); all-or-nothing; results returned in input order.

Adds a glossary entry (upsert by logicalWord) or updates one (entryId given). Physical words are normalized to uppercase. Standard-linked (glossaryLink) dictionaries are rejected with dictionary_is_linked.

Bulk form of upsert_dictionary_word: adds or updates many glossary entries in ONE load/save (use this instead of calling upsert_dictionary_word in a loop — each single call costs several server requests and counts against the per-minute cap). Same per-item semantics (upsert by logicalWord, physical words uppercased); later duplicates in the batch win; all-or-nothing; standard-linked dictionaries rejected with dictionary_is_linked.

Creates a domain (upsert by name) or updates one (domainId given). Existing description preserved when omitted.

Bulk form of upsert_domain: creates or updates many domains in ONE load/save (use this instead of calling upsert_domain in a loop — each single call costs several server requests and counts against the per-minute cap). Same per-item semantics; later duplicates in the batch win; all-or-nothing.

Creates an entity (no entityId, logicalName required) or updates one (entityId given, only provided fields change). The physical name is derived automatically.

Creates a relationship (no relationshipId, source/targetEntityId required — FKs derived automatically) or updates one (relationshipId given). On update, sourceEnd/targetEnd take precedence; otherwise ends are re-derived from cardinality. onDelete/onUpdate set the FK referential actions ('noAction' reverts to the DB default); constraintName sets the FK constraint name (empty string reverts to auto-generation).

Validates project structure and referential integrity ({ valid, errors }).

Withdraws your own pending proposal. Proposals by others or already processed return not_found. Requires login.