Schemity

MCP数据服务

提供方 tbson

数据服务 未标注 Token 社区 / 第三方 Claude DesktopClaudeCursorVS Code
查看接入方式

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

一句话选型结论

按资料字段整理

Schemity 属于数据服务类 MCP 服务器,传输方式未标注,Token,可直接接入 Claude Desktop、Claude、Cursor 等,有可直接执行的安装命令。接入前先确认权限范围;涉及写入、删除或付款的操作,建议先在测试环境验证。

分类数据服务 传输方式未标注 鉴权Token 部署方式未标注
GitHub 星标 未标注 仓库热度,无公开仓库时显示未标注
工具数 未标注 暴露给模型的工具数量
资源 / 提示词 0 / 0 资源与提示词模板数量
维护方 社区 / 第三方 核验等级 仅资料核对

工具与能力

数据服务
数量来自来源目录的标注,具体工具清单以官方文档为准
工具数量未标注暴露给模型可调用的工具个数
资源数量0可读取的资源条目
提示词数量0内置提示词模板数量

能力标签

database postgresql mysql mariadb sql server sqlite supabase schema

支持客户端

适用场景

databasepostgresqlmysql

安装与配置

未标注 Token
上游未给出传输方式
/Applications/Schemity.app/Contents/MacOS/schemity --mcp

这条命令只是入口,具体启动参数请按官方文档补齐,不要直接照搬到别的服务器。

  1. 1
    准备运行环境

    按官方文档确认运行环境(常见为 Node.js 或 Python),装好后再执行安装命令。

  2. 2
    安装服务

    复制上面的安装命令执行;命令里带占位符的位置,换成自己的密钥或路径。

  3. 3
    写入客户端配置

    在客户端的 MCP 配置里填好启动命令和参数,保存后完全退出客户端再打开,让新配置生效。

  4. 4
    验证是否可用

    连接成功后随便调一个只读工具,确认能返回结果,再接入正式流程。

典型使用场景

3 类
按分类与标签整理的常见用法,具体以官方文档为准
数据库查询

用自然语言查库、取数,不用手写 SQL。

数据同步与清洗

把多来源数据拉到一处做整理。

报表取数

按口径快速拉出统计结果。

选择建议

选之前先看这几条
按条目字段给出的判断,不替你决定用不用

值得选的地方

  • 有现成的安装命令,不用自己找入口,照着跑就能起服务。
  • 已适配 Claude Desktop、Claude、Cursor,换客户端不用重新研究配置。

先想清楚的地方

  • 使用前要准备好Token对应的凭据,并按最小权限配置。
  • 资料没标注工具数量,实际能力要装好后确认。
  • 版本更新与行为细节以官方仓库为准。

更适合

  • 需要在数据服务场景里让模型直接调用外部能力的人。
  • 已经在用 Claude Desktop、Claude 的用户,接入路径最短。
  • 想先快速试一下、能接受在本地或自有环境跑服务的人。

不太适合

  • 不方便管理密钥或第三方授权的人。
  • 需要厂商级 SLA 和技术支持的生产环境。

同类对比

6 个同类
同分类里挑最接近的几条,字段以各自详情页为准
MCP 服务器工具数传输方式部署方式安装命令最后核验
Schemity当前 未标注 未标注 未标注 有 未标注
Memory 9d25f64e 9 未标注 未标注 无 2026-05-17
Getzep MCP 9 stdio · 本地进程 本地部署 有 2026-05-17
anything-llm 未标注 stdio · 本地进程 本地部署 有 2026-04-11
Prisma MCP Server 未标注 stdio · 本地进程 本地部署 有 2026-05-17
Astr Bot 未标注 stdio · 本地进程 本地部署 有 2026-05-17

服务器档案

数据服务
字段来自项目仓库与公开索引,中文说明由本站标注
提供方tbson上游标注的维护方 tbson
分类数据服务本站按上游分类展示
连接方式未标注上游未给出传输方式
鉴权方式Token远程服务建议用最小权限凭据
维护方社区 / 第三方核验等级 仅资料核对
包名 / 运行时未标注 · Cross-platform本地安装时用到的包标识与运行时
部署类型未标注上游给出的部署形态
最近核验未标注上游最后核验时间

详细介绍

7.6 KB
来自项目仓库与上游目录的原文,未做删改

Schemity MCP Server

A local database MCP server built into Schemity, database design software for software engineers. Your AI agent reads the schema of your live PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, or Snowflake database, sees what a migration would do before it runs, and stages diagram edits you review. The agent never gets database credentials, and nothing it does writes to a database.

> The server ships inside the Schemity desktop app, which is closed source. This repository holds its documentation, the tool list it exposes (tools.json), and ready-to-paste host configs (examples/). Bug reports and feature requests go to schemity-feedback.

Why a governed path

Most database MCP servers hand the agent a connection string and run whatever SQL it writes. Schemity works the other way round: the agent works through the diagram you have open, which Schemity read from your database.

  • Reads never change anything.
  • Edits are staged in the open diagram as unsaved changes, recorded in undo history under the agent's name, for you to review and undo before you save.
  • Nothing touches a database until you run the migration yourself.
  • No vendor cloud in the middle. The HTTP server listens on 127.0.0.1 only and requires a bearer token kept in your OS keychain; stdio hosts talk to the app over a local socket. Your schema goes only where your agent host already sends your code, and with a local model it stays on your machine.

Tools

18 tools, as of Schemity 2.13.2. None of them runs SQL the agent writes, and none returns a row. Full input schemas are in tools.json.

list_diagrams

The diagrams open in Schemity right now, with the active tab marked. Read-only.

find_diagrams

Every saved diagram, open or not, matched by name, database, or workspace, best match first. Read-only.

open_diagram

Open a saved diagram in a new tab, or bring it to the front. Opening one with a database may ask for your OS keychain password.

open_schemity

Start Schemity, or bring it to the front.

get_schema

Tables, columns, keys, checks, and indexes of a diagram or one context view, plus your naming convention and the template new tables start with. No row data. Read-only.

get_dependencies

Relations into and out of one table, with the columns on both sides. Read-only.

get_context_views

Context views, the dependencies between them, cycles, and which dependencies are not declared as foreign keys. Read-only.

get_data_dictionary

The documented schema as Markdown, descriptions included. Read-only.

lint

Schema findings: conventions, missing indexes, type mismatches. Read-only.

get_pending_changes

The diagram's unsaved edits, as the undo history that produced them. Read-only.

analyze_impact

What the pending migration would cost: lost data, statements that fail on existing rows, table rewrites, locks on large tables, dependent views and functions. SQL only on request, never run. Read-only.

analyze_migration_file

The same analysis for a migration file, hand-written or generated by Prisma, Alembic, or Flyway. Parsed, never run. Read-only.

count_rows

An exact count behind a finding, as a SELECT COUNT with a 60-second timeout, only when you ask for it.

show_preview

Draw pending edits, a migration file, or a set of tables in Schemity for you to look at, with the findings; nothing is saved.

propose_changes

Create, change, and delete tables, columns, relations, constraints, indexes, legends, and context views. Staged as unsaved edits you review; deleting anything you made asks you first.

group_entities

Group tables into legends by domain, from your source code or your description. Staged as unsaved edits you review.

route_relations

Route relation lines around the tables so they cross less. Staged as unsaved edits you review.

check_relation_lines

Relation lines that overlap or cross, and how many bends they take. Read-only.

Example prompts

Ask in plain words. Your agent host gives the model every tool with its description, and the model calls Schemity's when the request fits one. Saying "in Schemity", "the diagram" or a diagram's name makes that clear; in a code repository, "add a status column" alone may send the agent to your model files instead.

  • "Which diagrams do I have open in Schemity?"
  • "Open my Coffee Shop diagram."
  • "Explain the schema in the current diagram. What are the main domains?"
  • "What depends on the orders table?"
  • "Arrange the current diagram: group the tables by domain, using this codebase to decide the groups."
  • "Untangle the relation lines in the Billing diagram."
  • "Show me the changes in the Coffee Shop diagram."
  • "What would my unsaved changes cost if I migrate?"
  • "Check migrations/0042_add_status.sql against the shop database before I run it."
  • "Add a loyalty_points table to the diagram, linked to customers."

Databases

PostgreSQL, Supabase, MySQL, MariaDB, SQL Server, and SQLite, directly or through an SSH tunnel, and Snowflake.

Setup

  1. Install Schemity on macOS, Windows, or Linux.
  2. Open the diagram you want the agent to see, or let the agent find and open a saved one with find_diagrams and open_diagram.
  3. Open the MCP panel from the plug icon in the control bar, or with Cmd+Shift+A (macOS) / Ctrl+Shift+A (Windows, Linux). It shows the server status, a connection test, and a snippet for each host with the right path for your platform.

The examples below use the macOS path. On Windows and Linux, copy the snippet from the MCP panel instead.

stdio: Claude Code, Claude Desktop, Codex, OpenCode

The host starts the Schemity binary with --mcp, so it can also launch Schemity when the app is closed.

Claude Code```bash
claude mcp add --scope user schemity -- "/Applications/Schemity.app/Contents/MacOS/schemity" --mcp


**Claude Desktop** - `claude_desktop_config.json`, then restart Claude Desktop```json
{
  "mcpServers": {
    "schemity": {
      "command": "/Applications/Schemity.app/Contents/MacOS/schemity",
      "args": ["--mcp"]
    }
  }
}

Codex - `~/.codex/config.toml````toml
[mcp_servers.schemity]
command = "/Applications/Schemity.app/Contents/MacOS/schemity"
args = ["--mcp"]


**OpenCode** - `opencode.json````json
{
  "mcp": {
    "schemity": {
      "type": "local",
      "command": ["/Applications/Schemity.app/Contents/MacOS/schemity", "--mcp"]
    }
  }
}

Streamable HTTP: Cursor and other HTTP clients

Keep Schemity open; an HTTP host cannot start it. The port defaults to 7332 and can be changed in the panel.

Cursor - `~/.cursor/mcp.json`json { "mcpServers": { "schemity": { "url": "http://127.0.0.1:7332/mcp", "headers": { "Authorization": "Bearer <token from the MCP panel>" } } } }

Troubleshooting

  • "Schemity is not running" - only a stdio host can start the app. On an HTTP host such as Cursor, open Schemity yourself and retry.
  • 401 Unauthorized - the token was regenerated in the panel; copy the current one into the host's config.
  • Port in use - pick another port in the panel and click Restart.
  • A tool says a diagram is "not open" - ask the agent to open it with open_diagram, or open it in the Schemity window yourself.

Requirements and pricing

The MCP server is a desktop feature. It runs during the 2-week free trial (every feature unlocked, no credit card) and with a license, a one-time purchase of $129. It is not part of Schemity Lite, the free browser version.

Links

  • Documentation: AI Agents via MCP
  • Impact analysis: what a migration costs before it runs
  • Website: schemity.com

常见问题

7 问
答案由本站依据条目字段整理,不引用上游原文
Schemity 怎么安装?

在客户端按下面的安装命令接入:/Applications/Schemity.app/Contents/MacOS/schemity --mcp。装完在客户端配置里引用同一个包或端点。

Schemity 怎么在 Claude Desktop、Claude、Cursor 里配置?

它的传输方式未标注,在客户端的 MCP 配置里填好启动命令和参数,保存后完全退出客户端再打开,配置才会生效。

Schemity 收费吗?

本站不代收费用,也没有标注具体价格。是否收费取决于服务本身和背后的接口额度,正式使用前按官方说明确认。

Schemity 需要 API Key 吗?

资料标注需要Token认证,使用前准备好对应凭据,并按最小权限配置。

Schemity 支持哪些客户端?

资料标注支持 Claude Desktop、Claude、Cursor、VS Code、Codex、Zed;其他客户端只要能配置 MCP Server,也能用同样的命令或地址接入。

Schemity 能提供哪些能力?

资料显示能力标签包括 database、postgresql、mysql、mariadb、sql server、sqlite。具体工具清单以官方文档为准。

Schemity 需要什么运行环境?

运行时为 Cross-platform。

热门专题

按标签挑服务器
全部专题 →

服务器信息以作者仓库与官方文档为准;分类、传输方式与鉴权方式的中文说明为中文整理,最近核验 未标注。