Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast
{
"SCHCRWLR_MCP_SERVER_TRANSPORT": "YOUR_VALUE_HERE",
"SCHCRWLR_DATABASE_USER": "YOUR_SECRET_VALUE",
"SCHCRWLR_DATABASE_PASSWORD": "YOUR_SECRET_VALUE",
"SCHCRWLR_JDBC_URL": "YOUR_VALUE_HERE",
"SCHCRWLR_SERVER": "YOUR_VALUE_HERE",
"SCHCRWLR_HOST": "YOUR_VALUE_HERE",
"SCHCRWLR_PORT": "YOUR_VALUE_HERE",
"SCHCRWLR_DATABASE": "YOUR_VALUE_HERE",
"SCHCRWLR_INFO_LEVEL": "YOUR_VALUE_HERE",
"SCHCRWLR_LOG_LEVEL": "YOUR_VALUE_HERE",
"SCHCRWLR_EXCLUDE_TOOLS": "YOUR_VALUE_HERE"
}Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.
{
"mcpServers": {
"io-github-schemacrawler-schemacrawler-ai": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-io-github-schemacrawler-schemacrawler-ai"
],
"env": {
"SCHCRWLR_MCP_SERVER_TRANSPORT": "YOUR_VALUE_HERE",
"SCHCRWLR_DATABASE_USER": "YOUR_SECRET_VALUE",
"SCHCRWLR_DATABASE_PASSWORD": "YOUR_SECRET_VALUE",
"SCHCRWLR_JDBC_URL": "YOUR_VALUE_HERE",
"SCHCRWLR_SERVER": "YOUR_VALUE_HERE",
"SCHCRWLR_HOST": "YOUR_VALUE_HERE",
"SCHCRWLR_PORT": "YOUR_VALUE_HERE",
"SCHCRWLR_DATABASE": "YOUR_VALUE_HERE",
"SCHCRWLR_INFO_LEVEL": "YOUR_VALUE_HERE",
"SCHCRWLR_LOG_LEVEL": "YOUR_VALUE_HERE",
"SCHCRWLR_EXCLUDE_TOOLS": "YOUR_VALUE_HERE"
}
}
}
}~/Library/Application Support/Claude/claude_desktop_config.json%APPDATA%\Claude\claude_desktop_config.jsonNo remote HTTP endpoint is advertised. Use the package or stdio setup shown in Install.
schemacrawler-ai is an MCP server for Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast. It supports STDIO transport.
Use the client-specific config in Install and add it to your MCP-compatible client.
Choose the Claude Desktop tab in Install and copy the config into Claude Desktop's MCP server settings.
Choose the Claude Code tab in Install and copy the config into Claude Code's MCP server settings.
Choose the Codex tab in Install and copy the config into Codex's MCP server settings.
Choose the Cursor or VS Code tab in Install and copy the config into Cursor or VS Code's MCP server settings.
schemacrawler-ai uses STDIO transport. Use the package or command config in Install.
schemacrawler-ai inventory is listed when the MCP endpoint exposes tools, resources, or prompts. Some servers require auth first.
schemacrawler-ai does not advertise a verified auth requirement. If discovery fails, it may still need provider login, an API key, a bearer token, or a session header.
| Package | Registry | Version | Inputs |
|---|---|---|---|
schemacrawler/schemacrawler-ai:17.9.0-1stdio | oci | Not captured | Env: SCHCRWLR_MCP_SERVER_TRANSPORT Env: SCHCRWLR_DATABASE_USER secret Env: SCHCRWLR_DATABASE_PASSWORD secret Env: SCHCRWLR_JDBC_URL Env: SCHCRWLR_SERVER Env: SCHCRWLR_HOST Env: SCHCRWLR_PORT Env: SCHCRWLR_DATABASE Env: SCHCRWLR_INFO_LEVEL Env: SCHCRWLR_LOG_LEVEL Env: SCHCRWLR_EXCLUDE_TOOLS |