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