← Index

io.github.schemacrawler/schemacrawler-ai

io.github.schemacrawler/schemacrawler-ai·vv17.10.2-1·Web Scraping
Quality Score
80
/100

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

§01  Install
Claude Desktop (Docker)
{
  "mcpServers": {
    "schemacrawler-ai": {
      "command": "docker",
      "args": [
        "run",
        "--rm",
        "-i",
        "schemacrawler/schemacrawler-ai:17.10.2-1"
      ],
      "env": {
        "SCHCRWLR_MCP_SERVER_TRANSPORT": "<schcrwlr_mcp_server_transport>",
        "SCHCRWLR_DATABASE_USER": "<your-schcrwlr_database_user>",
        "SCHCRWLR_DATABASE_PASSWORD": "<your-schcrwlr_database_password>",
        "SCHCRWLR_JDBC_URL": "<schcrwlr_jdbc_url>",
        "SCHCRWLR_SERVER": "<schcrwlr_server>",
        "SCHCRWLR_HOST": "<schcrwlr_host>",
        "SCHCRWLR_PORT": "<schcrwlr_port>",
        "SCHCRWLR_DATABASE": "<schcrwlr_database>",
        "SCHCRWLR_INFO_LEVEL": "<schcrwlr_info_level>",
        "SCHCRWLR_LOG_LEVEL": "<schcrwlr_log_level>",
        "SCHCRWLR_EXCLUDE_TOOLS": "<schcrwlr_exclude_tools>"
      }
    }
  }
}
§02  Environment variables
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.

§03  MCP Quality Score  ·  methodology
freshness
25
completeness
15
installability
25
documentation
15
stability
0
§04  Alternatives in Web Scraping