MCP Server

io.github.schemacrawler/schemacrawler-ai MCP Server

Name: io.github.schemacrawler/schemacrawler-ai MCP Server
Author: io.github.schemacrawler

io.github.schemacrawler/schemacrawler-ai

Repository Registry

What is the io.github.schemacrawler/schemacrawler-ai MCP server?

Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast

How to install io.github.schemacrawler/schemacrawler-ai

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

SCHCRWLR_MCP_SERVER_TRANSPORT
MCP Server transport type - valid values are 'http' or 'stdio', defaulting to 'stdio'.
SCHCRWLR_DATABASE_USER
secret
Database user name. Can be optional depending on the database connection type.
SCHCRWLR_DATABASE_PASSWORD
secret
Database user password. Can be optional depending on the database connection type.
SCHCRWLR_JDBC_URL
JDBC URL for database connection. If this is provided, the server, host, port and database are not used.
SCHCRWLR_SERVER
SchemaCrawler database plugin, for example, 'sqlserver' or 'sqlite'. Used only if the JDBC URL is not provided.
SCHCRWLR_HOST
Database host. Defaults to localhost. Used only if the JDBC URL is not provided.
SCHCRWLR_PORT
Database port. Defaults to the default port for the server type. Used only if the JDBC URL is not provided.
SCHCRWLR_DATABASE
Database to connect to (optional). Used only if the JDBC URL is not provided.
SCHCRWLR_INFO_LEVEL
How much database metadata to retrieve. Values are 'minimum', 'standard', 'detailed' or 'maximum'.
SCHCRWLR_LOG_LEVEL
Logging verbosity level. Values are 'SEVERE', 'WARNING', 'INFO', 'CONFIG', or 'FINE'.
SCHCRWLR_EXCLUDE_TOOLS
MCP Server tools to exclude, as a comma-separated list.

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "schemacrawler-ai": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "schemacrawler/schemacrawler-ai:17.11.4-3"
      ],
      "env": {
        "SCHCRWLR_MCP_SERVER_TRANSPORT": "<YOUR_SCHCRWLR_MCP_SERVER_TRANSPORT>",
        "SCHCRWLR_DATABASE_USER": "<YOUR_SCHCRWLR_DATABASE_USER>",
        "SCHCRWLR_DATABASE_PASSWORD": "<YOUR_SCHCRWLR_DATABASE_PASSWORD>",
        "SCHCRWLR_JDBC_URL": "<YOUR_SCHCRWLR_JDBC_URL>",
        "SCHCRWLR_SERVER": "<YOUR_SCHCRWLR_SERVER>",
        "SCHCRWLR_HOST": "<YOUR_SCHCRWLR_HOST>",
        "SCHCRWLR_PORT": "<YOUR_SCHCRWLR_PORT>",
        "SCHCRWLR_DATABASE": "<YOUR_SCHCRWLR_DATABASE>",
        "SCHCRWLR_INFO_LEVEL": "<YOUR_SCHCRWLR_INFO_LEVEL>",
        "SCHCRWLR_LOG_LEVEL": "<YOUR_SCHCRWLR_LOG_LEVEL>",
        "SCHCRWLR_EXCLUDE_TOOLS": "<YOUR_SCHCRWLR_EXCLUDE_TOOLS>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "schemacrawler-ai": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "schemacrawler/schemacrawler-ai:17.11.4-3"
      ],
      "env": {
        "SCHCRWLR_MCP_SERVER_TRANSPORT": "<YOUR_SCHCRWLR_MCP_SERVER_TRANSPORT>",
        "SCHCRWLR_DATABASE_USER": "<YOUR_SCHCRWLR_DATABASE_USER>",
        "SCHCRWLR_DATABASE_PASSWORD": "<YOUR_SCHCRWLR_DATABASE_PASSWORD>",
        "SCHCRWLR_JDBC_URL": "<YOUR_SCHCRWLR_JDBC_URL>",
        "SCHCRWLR_SERVER": "<YOUR_SCHCRWLR_SERVER>",
        "SCHCRWLR_HOST": "<YOUR_SCHCRWLR_HOST>",
        "SCHCRWLR_PORT": "<YOUR_SCHCRWLR_PORT>",
        "SCHCRWLR_DATABASE": "<YOUR_SCHCRWLR_DATABASE>",
        "SCHCRWLR_INFO_LEVEL": "<YOUR_SCHCRWLR_INFO_LEVEL>",
        "SCHCRWLR_LOG_LEVEL": "<YOUR_SCHCRWLR_LOG_LEVEL>",
        "SCHCRWLR_EXCLUDE_TOOLS": "<YOUR_SCHCRWLR_EXCLUDE_TOOLS>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "schemacrawler-ai": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "schemacrawler/schemacrawler-ai:17.11.4-3"
      ],
      "env": {
        "SCHCRWLR_MCP_SERVER_TRANSPORT": "<YOUR_SCHCRWLR_MCP_SERVER_TRANSPORT>",
        "SCHCRWLR_DATABASE_USER": "<YOUR_SCHCRWLR_DATABASE_USER>",
        "SCHCRWLR_DATABASE_PASSWORD": "<YOUR_SCHCRWLR_DATABASE_PASSWORD>",
        "SCHCRWLR_JDBC_URL": "<YOUR_SCHCRWLR_JDBC_URL>",
        "SCHCRWLR_SERVER": "<YOUR_SCHCRWLR_SERVER>",
        "SCHCRWLR_HOST": "<YOUR_SCHCRWLR_HOST>",
        "SCHCRWLR_PORT": "<YOUR_SCHCRWLR_PORT>",
        "SCHCRWLR_DATABASE": "<YOUR_SCHCRWLR_DATABASE>",
        "SCHCRWLR_INFO_LEVEL": "<YOUR_SCHCRWLR_INFO_LEVEL>",
        "SCHCRWLR_LOG_LEVEL": "<YOUR_SCHCRWLR_LOG_LEVEL>",
        "SCHCRWLR_EXCLUDE_TOOLS": "<YOUR_SCHCRWLR_EXCLUDE_TOOLS>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "schemacrawler-ai": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "schemacrawler/schemacrawler-ai:17.11.4-3"
      ],
      "env": {
        "SCHCRWLR_MCP_SERVER_TRANSPORT": "<YOUR_SCHCRWLR_MCP_SERVER_TRANSPORT>",
        "SCHCRWLR_DATABASE_USER": "<YOUR_SCHCRWLR_DATABASE_USER>",
        "SCHCRWLR_DATABASE_PASSWORD": "<YOUR_SCHCRWLR_DATABASE_PASSWORD>",
        "SCHCRWLR_JDBC_URL": "<YOUR_SCHCRWLR_JDBC_URL>",
        "SCHCRWLR_SERVER": "<YOUR_SCHCRWLR_SERVER>",
        "SCHCRWLR_HOST": "<YOUR_SCHCRWLR_HOST>",
        "SCHCRWLR_PORT": "<YOUR_SCHCRWLR_PORT>",
        "SCHCRWLR_DATABASE": "<YOUR_SCHCRWLR_DATABASE>",
        "SCHCRWLR_INFO_LEVEL": "<YOUR_SCHCRWLR_INFO_LEVEL>",
        "SCHCRWLR_LOG_LEVEL": "<YOUR_SCHCRWLR_LOG_LEVEL>",
        "SCHCRWLR_EXCLUDE_TOOLS": "<YOUR_SCHCRWLR_EXCLUDE_TOOLS>"
      }
    }
  }
}

Claude Code

claude mcp add schemacrawler-ai --env SCHCRWLR_MCP_SERVER_TRANSPORT=<YOUR_SCHCRWLR_MCP_SERVER_TRANSPORT> --env SCHCRWLR_DATABASE_USER=<YOUR_SCHCRWLR_DATABASE_USER> --env SCHCRWLR_DATABASE_PASSWORD=<YOUR_SCHCRWLR_DATABASE_PASSWORD> --env SCHCRWLR_JDBC_URL=<YOUR_SCHCRWLR_JDBC_URL> --env SCHCRWLR_SERVER=<YOUR_SCHCRWLR_SERVER> --env SCHCRWLR_HOST=<YOUR_SCHCRWLR_HOST> --env SCHCRWLR_PORT=<YOUR_SCHCRWLR_PORT> --env SCHCRWLR_DATABASE=<YOUR_SCHCRWLR_DATABASE> --env SCHCRWLR_INFO_LEVEL=<YOUR_SCHCRWLR_INFO_LEVEL> --env SCHCRWLR_LOG_LEVEL=<YOUR_SCHCRWLR_LOG_LEVEL> --env SCHCRWLR_EXCLUDE_TOOLS=<YOUR_SCHCRWLR_EXCLUDE_TOOLS> -- docker run -i --rm schemacrawler/schemacrawler-ai:17.11.4-3