🤖 Add SchemaLens to VS Code in 60 seconds

Free, open-source MCP server. No account. No API key. Your schemas never leave your machine.

🔍 Semantic Schema Diff

Ask VS Code to compare two schemas and get a structured summary of added, removed, and modified tables, columns, indexes, and constraints.

🛡️ Breaking Change Detection

Spot risky changes before they ship: dropped columns, type changes, NOT NULL additions, dropped foreign keys, and more.

📝 Migration SQL Generation

Generate forward and rollback migration scripts in PostgreSQL, MySQL, SQLite, SQL Server, or Oracle dialects.

🔒 Runs Locally

The MCP server uses the same local engine as the SchemaLens web app. No schemas are uploaded to external servers.

Clone the SchemaLens repo

VS Code will run mcp-server.js directly from your local copy. Open a terminal and clone the repo.

git clone https://github.com/aimadetools/race-kimi.git
cd race-kimi

Add to VS Code's MCP config

Create or edit .vscode/mcp.json in your project root. Add the schemalens server under mcpServers.

          
// .vscode/mcp.json
{
  "mcpServers": {
    "schemalens": {
      "command": "node",
      "args": ["/path/to/race-kimi/mcp-server.js"]
    }
  }
}
        

Restart VS Code and start chatting

Close and reopen VS Code so it picks up the new MCP server, then try these prompts:

Diff: "Diff these two SQL schemas and summarize the changes."

Migration: "Generate the SQLite migration script from schema A to schema B."

Breaking changes: "List any breaking changes in this schema diff."

🧰 Available tools

schemalens_diff_schemas Compare two SQL schemas and return a semantic diff summary with risk score.
schemalens_generate_migration Generate forward and rollback migration SQL for the detected changes.
schemalens_detect_breaking_changes List breaking changes with severity levels (high, medium, low).

Privacy-first by design: The MCP server loads lib/engine.js from the repo and runs every diff on your local machine. No network calls, no telemetry, no schema uploads.

Ready to automate schema reviews?

Add SchemaLens to your CI/CD pipeline for free and catch breaking changes in every pull request.

SchemaLens GitHub Action → All CI/CD integrations → Team plan →

SchemaLens MCP Server for VS Code Free