Schemacrawler AI MCP Server

by schemacrawlerio.github.schemacrawler/schemacrawler-aiv17.15.7-1

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

12Dockerstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Active4d ago

Install Schemacrawler AI MCP server

claude mcp add schemacrawler-ai -e SCHCRWLR_DATABASE_USER='<schcrwlr-database-user>' -e SCHCRWLR_DATABASE_PASSWORD='<schcrwlr-database-password>' -- docker run -i --rm -e SCHCRWLR_DATABASE_USER -e SCHCRWLR_DATABASE_PASSWORD schemacrawler/schemacrawler-ai:17.15.7-1

{
  "mcpServers": {
    "schemacrawler-ai": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "SCHCRWLR_DATABASE_USER",
        "-e",
        "SCHCRWLR_DATABASE_PASSWORD",
        "schemacrawler/schemacrawler-ai:17.15.7-1"
      ],
      "env": {
        "SCHCRWLR_DATABASE_USER": "<schcrwlr-database-user>",
        "SCHCRWLR_DATABASE_PASSWORD": "<schcrwlr-database-password>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "schemacrawler-ai": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "SCHCRWLR_DATABASE_USER",
        "-e",
        "SCHCRWLR_DATABASE_PASSWORD",
        "schemacrawler/schemacrawler-ai:17.15.7-1"
      ],
      "env": {
        "SCHCRWLR_DATABASE_USER": "<schcrwlr-database-user>",
        "SCHCRWLR_DATABASE_PASSWORD": "<schcrwlr-database-password>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "schemacrawler-ai": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "SCHCRWLR_DATABASE_USER",
        "-e",
        "SCHCRWLR_DATABASE_PASSWORD",
        "schemacrawler/schemacrawler-ai:17.15.7-1"
      ],
      "env": {
        "SCHCRWLR_DATABASE_USER": "<schcrwlr-database-user>",
        "SCHCRWLR_DATABASE_PASSWORD": "<schcrwlr-database-password>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "schemacrawler-ai": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "SCHCRWLR_DATABASE_USER",
        "-e",
        "SCHCRWLR_DATABASE_PASSWORD",
        "schemacrawler/schemacrawler-ai:17.15.7-1"
      ],
      "env": {
        "SCHCRWLR_DATABASE_USER": "<schcrwlr-database-user>",
        "SCHCRWLR_DATABASE_PASSWORD": "<schcrwlr-database-password>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

Variable	Required	Secret	Description
SCHCRWLR_MCP_SERVER_TRANSPORT	—	—	MCP Server transport type - valid values are 'http' or 'stdio', defaulting to 'stdio'.
SCHCRWLR_DATABASE_USER	—	yes	Database user name. Can be optional depending on the database connection type.
SCHCRWLR_DATABASE_PASSWORD	—	yes	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_DATABASE_ALIAS	—	—	Optional stable alias used to identify this database server in MCP instructions and tool results.
SCHCRWLR_DATABASE_DESCRIPTION	—	—	Optional description of this database server, included in MCP instructions and the about_database response.
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.

Freshness

Active — last maintenance signal 4d ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-10-05 · 4d ago · GitHub
Latest release
2026-09-30 · 10d ago · GitHub · v17.15.7-1
Package published
no data · npm/PyPI
Registry entry updated
2026-09-30 · 10d ago · official registry · v17.15.7-1

FAQ

›How do I install the Schemacrawler AI MCP server in Claude Code?

Run: claude mcp add schemacrawler-ai -e SCHCRWLR_DATABASE_USER='<schcrwlr-database-user>' -e SCHCRWLR_DATABASE_PASSWORD='<schcrwlr-database-password>' -- docker run -i --rm -e SCHCRWLR_DATABASE_USER -e SCHCRWLR_DATABASE_PASSWORD schemacrawler/schemacrawler-ai:17.15.7-1. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does Schemacrawler AI require an API key?

Yes. It expects SCHCRWLR_DATABASE_USER, SCHCRWLR_DATABASE_PASSWORD, of which 2 are secrets.

›Can I use Schemacrawler AI as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is Schemacrawler AI in the official MCP registry?

Yes, as io.github.schemacrawler/schemacrawler-ai.