Official server.json
{
"name": "io.github.schemacrawler/schemacrawler-ai",
"$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
"version": "v17.16.0-1",
"packages": [
{
"transport": {
"type": "stdio"
},
"identifier": "schemacrawler/schemacrawler-ai:17.16.0-1",
"registryType": "oci",
"environmentVariables": [
{
"name": "SCHCRWLR_MCP_SERVER_TRANSPORT",
"format": "string",
"description": "MCP Server transport type - valid values are 'http' or 'stdio', defaulting to 'stdio'."
},
{
"name": "SCHCRWLR_DATABASE_USER",
"format": "string",
"isSecret": true,
"description": "Database user name. Can be optional depending on the database connection type."
},
{
"name": "SCHCRWLR_DATABASE_PASSWORD",
"format": "string",
"isSecret": true,
"description": "Database user password. Can be optional depending on the database connection type."
},
{
"name": "SCHCRWLR_JDBC_URL",
"format": "string",
"description": "JDBC URL for database connection. If this is provided, the server, host, port and database are not used."
},
{
"name": "SCHCRWLR_SERVER",
"format": "string",
"description": "SchemaCrawler database plugin, for example, 'sqlserver' or 'sqlite'. Used only if the JDBC URL is not provided."
},
{
"name": "SCHCRWLR_HOST",
"format": "string",
"description": "Database host. Defaults to localhost. Used only if the JDBC URL is not provided."
},
{
"name": "SCHCRWLR_PORT",
"format": "string",
"description": "Database port. Defaults to the default port for the server type. Used only if the JDBC URL is not provided."
},
{
"name": "SCHCRWLR_DATABASE",
"format": "string",
"description": "Database to connect to (optional). Used only if the JDBC URL is not provided."
},
{
"name": "SCHCRWLR_DATABASE_ALIAS",
"format": "string",
"description": "Optional stable alias used to identify this database server in MCP instructions and tool results."
},
{
"name": "SCHCRWLR_DATABASE_DESCRIPTION",
"format": "string",
"description": "Optional description of this database server, included in MCP instructions and the about_database response."
},
{
"name": "SCHCRWLR_INFO_LEVEL",
"format": "string",
"description": "How much database metadata to retrieve. Values are 'minimum', 'standard', 'detailed' or 'maximum'."
},
{
"name": "SCHCRWLR_LOG_LEVEL",
"format": "string",
"description": "Logging verbosity level. Values are 'SEVERE', 'WARNING', 'INFO', 'CONFIG', or 'FINE'."
},
{
"name": "SCHCRWLR_EXCLUDE_TOOLS",
"format": "string",
"description": "MCP Server tools to exclude, as a comma-separated list."
}
]
}
],
"repository": {
"url": "https://github.com/schemacrawler/SchemaCrawler-AI",
"source": "github"
},
"websiteUrl": "https://schemacrawler.github.io",
"description": "Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast"
}