🤖 Add SchemaLens to Cline in 60 seconds

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

🔍 Semantic Schema Diff

Ask Cline 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

Cline 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 Cline's MCP settings

Open the Cline extension in VS Code, go to Settings → MCP Servers, or create .vscode/mcp_settings.json in your project root. Add the schemalens server under mcpServers.

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

Reload Cline and start chatting

Reload the VS Code window so Cline picks up the new MCP server, then try these prompts:

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

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

Breaking changes: "Will this schema change break production?"

🧰 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 Cline Free