# Sqemo

> Sqemo is a freemium MCP server for databases. Lets agents design ERDs that follow a team's word list and naming rules, with SQL and DBML. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Freemium
- **Starting price:** $9 a month
- **Platforms:** CLI, Web, macOS, Windows, Linux
- **Website:** https://sqemo.com
- **Repository:** https://github.com/sqemo/sqemo-mcp
- **MCP Registry name:** io.github.sqemo/sqemo
- **Categories:** databases, developer tools
- **Listing updated:** 2026-11-15

## About

The agent describes tables in business language, and Sqemo's word list turns that into physical names, so a Customer Number becomes cust_no because the team's list says customer is cust and number is no. The README shows an agent creating an entity and attributes by logical name only, with each response returning the generated physical name, and then running a lint pass for naming drift, missing words and referential integrity before any DDL exists.

Domains carry data types, so a Content domain is the same varchar everywhere. Overrides are allowed but flagged, and a CLI lint can fail CI on drift. The server can import and export seven SQL dialects and DBML, work on local .erd.json files without an account, or use cloud ERDs after npx sqemo-mcp login. On the Pro plan it can also read a PostgreSQL or MySQL schema, using only the information schema with credentials kept local, and fail CI when the database drifts from the model.

It needs Node.js 22 or newer. The web app is free to use in a browser, with paid Pro and Team plans for more projects, history and members.

## Features

- **Naming from a word list:** Generates physical names from the team's word list, domains and naming rules.
- **Lint pass:** Checks naming drift, missing words and referential integrity before DDL is written.
- **SQL and DBML:** Imports and exports seven SQL dialects and DBML.
- **Local or cloud ERDs:** Edits .erd.json files without an account or ERDs stored in Sqemo cloud.
- **Drift check against a database:** Pro tools compare a live PostgreSQL or MySQL schema read-only with the model.
- **CI gate:** A CLI lint command fails builds when names drift from the standard.

## Good for

- Have an agent model a new feature without inventing column names
- Enforce a shared naming standard across several teams' diagrams
- Import an existing schema and flag off-standard names
- Fail CI when a database drifts from its ERD

## Install

### Claude Code (Terminal)

```sh
claude mcp add sqemo -- npx -y sqemo-mcp
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "sqemo": {
      "command": "npx",
      "args": [
        "-y",
        "sqemo-mcp"
      ]
    }
  }
}
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "sqemo": {
      "command": "npx",
      "args": [
        "-y",
        "sqemo-mcp"
      ]
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "sqemo": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "sqemo-mcp"
      ]
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "sqemo": {
      "command": "npx",
      "args": [
        "-y",
        "sqemo-mcp"
      ]
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "sqemo": {
      "command": "npx",
      "args": [
        "-y",
        "sqemo-mcp"
      ]
    }
  }
}
```

## Tools

- `upsert_entity`: Creates or updates an entity by logical name and returns its physical name.
- `upsert_attribute`: Creates or updates an attribute with a domain and returns its physical name.
- `lint_erd`: Reports naming drift, missing words and referential integrity problems.

## FAQ

### Does it need an account?

Not for local .erd.json files; cloud ERDs and Pro tools need npx sqemo-mcp login.

### What does Sqemo cost?

Free, Pro at 9 dollars a month and Team at 19 dollars per user per month.

### Do my database credentials leave my machine?

The vendor says they are used locally or in your CI job and never sent to Sqemo.

### Which Node version is required?

Node.js 22 or newer.

### Which clients work?

Claude Code, Claude Desktop, Cursor and any MCP client.

### Is Sqemo free?

Sqemo has a free plan, with paid plans for more usage or features. Paid plans start at $9 a month.

### How do I add Sqemo to Claude Code?

Run this command in your terminal: claude mcp add sqemo -- npx -y sqemo-mcp

### What are the best alternatives to Sqemo?

The closest alternatives to Sqemo are REA, Codebase Memory, GitHub, Serena MCP: the IDE for your agent and XERJ.

## Alternatives

- [REA](https://ai-powered.com/mcp/rea): REA is an open-source MCP server for developer tools.
- [Codebase Memory](https://ai-powered.com/mcp/codebase-memory): Codebase Memory is an open-source MCP server for knowledge and memory.
- [GitHub](https://ai-powered.com/mcp/github-2): GitHub is an open-source MCP server for developer tools.
- [Serena MCP: the IDE for your agent](https://ai-powered.com/mcp/serena-mcp-the-ide-for-your-agent): Serena MCP: the IDE for your agent is an open-source MCP server for developer tools.
- [XERJ](https://ai-powered.com/mcp/xerj): XERJ is an open-source MCP server for knowledge and memory.
- [Ouroboros](https://ai-powered.com/mcp/ouroboros): Ouroboros is an open-source MCP server for developer tools.
- [Claude Code Ultimate Guide](https://ai-powered.com/mcp/claude-code-ultimate-guide): Claude Code Ultimate Guide is an open-source MCP server for ai models and llm tooling.
- [Concord MCP](https://ai-powered.com/mcp/concord-mcp): Concord MCP is a freemium MCP server for developer tools.

---
Source: https://ai-powered.com/mcp/sqemo
