Skip to content
VS Code

schemacrawler ai for VS Code

io.github.schemacrawler/schemacrawler-ai

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

client:VS Code transport:stdio runtime:oci

Install schemacrawler ai in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "schcrwlr-mcp-server-transport",
      "description": "SCHCRWLR_MCP_SERVER_TRANSPORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "schcrwlr-database-user",
      "description": "SCHCRWLR_DATABASE_USER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "schcrwlr-database-password",
      "description": "SCHCRWLR_DATABASE_PASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "schcrwlr-jdbc-url",
      "description": "SCHCRWLR_JDBC_URL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "schcrwlr-server",
      "description": "SCHCRWLR_SERVER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "schcrwlr-host",
      "description": "SCHCRWLR_HOST",
      "password": true
    },
    {
      "type": "promptString",
      "id": "schcrwlr-port",
      "description": "SCHCRWLR_PORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "schcrwlr-database",
      "description": "SCHCRWLR_DATABASE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "schcrwlr-info-level",
      "description": "SCHCRWLR_INFO_LEVEL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "schcrwlr-log-level",
      "description": "SCHCRWLR_LOG_LEVEL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "schcrwlr-exclude-tools",
      "description": "SCHCRWLR_EXCLUDE_TOOLS",
      "password": true
    }
  ],
  "servers": {
    "schemacrawler-ai": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "schemacrawler/schemacrawler-ai:17.15.4-1"
      ],
      "env": {
        "SCHCRWLR_MCP_SERVER_TRANSPORT": "${input:schcrwlr-mcp-server-transport}",
        "SCHCRWLR_DATABASE_USER": "${input:schcrwlr-database-user}",
        "SCHCRWLR_DATABASE_PASSWORD": "${input:schcrwlr-database-password}",
        "SCHCRWLR_JDBC_URL": "${input:schcrwlr-jdbc-url}",
        "SCHCRWLR_SERVER": "${input:schcrwlr-server}",
        "SCHCRWLR_HOST": "${input:schcrwlr-host}",
        "SCHCRWLR_PORT": "${input:schcrwlr-port}",
        "SCHCRWLR_DATABASE": "${input:schcrwlr-database}",
        "SCHCRWLR_INFO_LEVEL": "${input:schcrwlr-info-level}",
        "SCHCRWLR_LOG_LEVEL": "${input:schcrwlr-log-level}",
        "SCHCRWLR_EXCLUDE_TOOLS": "${input:schcrwlr-exclude-tools}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

schemacrawler ai in other clients